Results 221 to 230 of about 11,404 (241)

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

PostgreSQL Essentials

PostgreSQL Essentials covers everything from fundamental architecture to advanced vector database implementations for Large Language Model (LLM) Embeddings. The book's practical approach ensures you'll grasp complex concepts through real-world examples, making even the most challenging database concepts easy to understand.
openaire   +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

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

Best Ways to Install PostgreSQL

2020
This chapter covers the best ways to install PostgreSQL. It answers the following questions:
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

Autonomic Buffer Pool Configuration in PostgreSQL

2005 IEEE International Conference on Systems, Man and Cybernetics, 2006
As database management systems (DBMSs) continue to expand into new application areas, the complexity of the systems and the diversity of database workloads are increasing. Managing the performance of DBMSs via manual adjustment of resource allocations in this new environment has become impractical.
Wenhu Tian, Wendy Powley, Patrick Martin, N. Ogeer   +3 more
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

PostgreSQL ДҚБЖ. SQL негіздері

Оқу құралында қазіргі заманғы ашық бастапқы коды PostrgreSQL реляциялық дерекқорды басқару жүйесінде декларативті бағдарламалауда қолданылатын SQL тілінің барлық негізгі синтаксистік құрылымдары жеткілікті түрде егжей-тегжейлі берілген. Теориялық материал нақты ақпараттық жүйенің дерекқорының жеңілдетілген үлгісі болып табылатын оқу деректер базасына ...
openaire   +1 more source