CYBERTEC Logo

Tag: index

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: index. You can go back to all blog posts or take a look into our other categories & tags.

B-tree index improvements in PostgreSQL v12

by Laurenz Albe | 11.2019
  If you thought that the B-tree index is a technology that was perfected in the 1980s, you are mostly […]

Composite/ combined indexes vs. separate indexes in PostgreSQL

by Hans-Jürgen Schönig | 07.2019
A “composite index”, also known as “concatenated index” or a combined index, is an index on multiple columns in a […]

Killed index tuples

by Laurenz Albe | 11.2018
  Since I only recently learned about the concept of “killed index tuples”, I thought there might be some others […]

Foreign Key Indexing and Performance in PostgreSQL

by Laurenz Albe | 10.2018
Foreign key constraints are an important tool to keep your database consistent while also documenting relationships between tables. A fact […]

Correlation of PostgreSQL columns explained

by Laurenz Albe | 09.2018
After you ANALYZE a PostgreSQL table to collect value distribution statistics, you will find the gathered statistics for each column […]

PostgreSQL: Parallel CREATE INDEX for better performance

by Hans-Jürgen Schönig | 09.2018
As of PostgreSQL 11 postgres users have the ability to create indexes in parallel. For many years various commercial database […]

Adding an index can decrease SELECT performance

by Laurenz Albe | 06.2018
  We all know that you have to pay a price for a new index you create — data modifying […]

Get rid of your unused indexes!

by Laurenz Albe | 04.2018
Why should I get rid of unused indexes? Everybody knows that a database index is a good thing because it […]

PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics)

by Hans-Jürgen Schönig | 02.2018
Many people ask about index scans in PostgreSQL. This blog is meant to be a basic introduction to the topic. […]

PostgreSQL: Indexes and foreign keys

by Hans-Jürgen Schönig | 07.2017
Recently we have received a couple of PostgreSQL support calls, which were related to bad performance on various deployments. In […]
1 2 3
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram