Results 141 to 150 of about 5,230 (160)

PostgreSQL Ins and Outs

Открытые системы. СУБД, 2023
В помощь специалистам, знакомым с устройством реляционных СУБД, планирующим переход на PostgreSQL, издательство «ДМК Пресс» выпустило книгу «PostgreSQL 15 изнутри». The exodus of western IT vendors from Russia has led to shrinkage of local enterprise database ...
openaire   +1 more source

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

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

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

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

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

Best Ways to Install PostgreSQL

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

Implementation and improvement of TPM for PostgreSQL in Linux

2008 International Conference on Control, Automation and Systems, 2008
In this paper we improve TPM (transaction processing monitor) and aim at a further performance enhancement of PostgreSQL. Therefore we examined introduction of mechanism to change dynamically the number of the server connections to solve the problem in this study.
Hidenori Umeno, Shenkun Liu
openaire   +2 more sources

Runtime Specialization of PostgreSQL Query Executor

2018
For computationally intensive workloads, achieving high database performance is in direct correspondence to utilizing CPU efficiently. At the same time, interpretation overhead inherent to traditional interpretive SQL engines gets in the way of optimal CPU utilization.
Ruben Buchatskiy, Arseny Sher, Arseny Sher, Eugene Sharygin, Eugene Sharygin, Roman Zhuykov   +5 more
openaire   +2 more sources