Results 241 to 250 of about 49,363 (264)

Deploying Azure Arc-enabled PostgreSQL Hyperscale

2021
While Chapter 5 was handling SQL Managed Instance, this chapter will guide through the necessary steps when it comes to working with PostgreSQL Hyperscale instead.
Anthony E. Nocentino, Ben Weissman
openaire   +2 more sources

Realization of replication mechanism in PostgreSQL DBMS

2017 International Conference on Industrial Engineering, Applications and Manufacturing (ICIEAM), 2017
Nowadays we have a project of a high-performance parallel encrypted database on a cluster platform that will work with large volumes of data. For the smooth operation of the system, a reliable and high-speed data replication mechanism is required which should satisfy certain criteria of PostgreSQL DBMS and the mentioned project.
R. Sh. Minyazev, I.S. Vershinin, R. F. Gibadullin   +2 more
openaire   +2 more sources

Algorithms for integrating PostgreSQL with the semantic web

Programming and Computer Software, 2009
This paper addresses the integration of the PostgreSQL database management system (DBMS) with the Semantic Web. Integration algorithms based on the use of the DBMS capabilities that do not introduce changes in SQL are proposed. An integration based on one of the algorithms supporting main formats of the Semantic Web is presented.
A. S. Markov, D. V. Levshin
openaire   +2 more sources

Using PostgreSQL Database

2016
PostgreSQL 9.5 offers several new features such as support for UPSERT, BRIN indexing, faster sorts, and the TABLESAMPLE clause for getting a statistical sample of a large table. In this chapter we shall discuss creating a PostgreSQL 9.5 cluster using the Kubernetes cluster manager.
openaire   +2 more sources

Database Migration from ORACLE to PostgreSQL

Programming and computer software, 2023
E. Kurako, V. Orlov
semanticscholar   +1 more source

Flash-aware index scan in PostgreSQL

2015 31st IEEE International Conference on Data Engineering Workshops, 2015
Recently, the trend of storage markets has changed from HDDs that have dominated the markets for the last several decades to flash based SSDs. Corresponding to the drift, various studies have been conducted to adapt traditional DBMS to SSD based storage devices. However, most DBMSs are still more HDD-friendly.
Woon-Hak Kang, Da-som Hwang, Gihwan Oh, Sang-Won Lee   +3 more
openaire   +2 more sources

PgCuckoo: Laying Plan Eggs in PostgreSQL's Nest

SIGMOD Conference, 2019
We demonstrate how to use PostgreSQL's planner hook to open a side entrance through which we can pass plan trees for immediate execution. Since this reaches deep into PostgreSQL, we implement plan detail inference and decoration to ensure that externally
Denis Hirn, Torsten Grust
semanticscholar   +1 more source

Examining the evolution of code comments in PostgreSQL

Proceedings of the 2006 international workshop on Mining software repositories, 2006
It is common, especially in large software systems, for developers to change code without updating its associated comments due to their unfamiliarity with the code or due to time constraints. This is a potential problem since outdated comments may confuse or mislead developers who perform future development.
Ahmed E. Hassan, Zhen Ming Jiang
openaire   +2 more sources

An implementation of the M-tree index structure for PostgreSQL using GiST

2019 IEEE 15th International Scientific Conference on Informatics, 2019
Several index structures are competing for efficient operations on various types of data, but there are some forms of information that cannot fit into the existing models, because by forcing them into one of the currently available representations they ...
István Donkó, J. Szalai-Gindl, G. Gombos, A. Kiss   +3 more
semanticscholar   +1 more source

Best Ways to Install PostgreSQL

2020
This chapter covers the best ways to install PostgreSQL. It answers the following questions:
openaire   +2 more sources