CYBERTEC PostgreSQL Logo

Category: Performance

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

Index bloat reduced in PostgreSQL v14

by Laurenz Albe | 09.2021
  PostgreSQL v12 brought more efficient storage for indexes, and v13 improved that even more by adding deduplication of index […]

PostgreSQL: The power of a SINGLE missing index

by Hans-Jürgen Schönig | 08.2021
This poem post shows the importance of even one missing index for a target PostgreSQL table from a performance perspective.

PostgreSQL vs Redis vs Memcached performance

by CYBERTEC Guest | 08.2021
PostgreSQL vs Redis vs Memcached: How would it look on the performance side, if one just skips the cache & hit the database directly?

Data warehousing: Making use of synchronized seq scans

by Hans-Jürgen Schönig | 06.2021
Did you know PostgreSQL has the ability to synchronize sequential scans? If you are running data warehouses, you might have already used it without knowing.

How to interpret PostgreSQL EXPLAIN ANALYZE output

by Laurenz Albe | 05.2021
  UPDATED July 2023: EXPLAIN ANALYZE is the key to optimizing SQL statements in PostgreSQL. This article does not attempt […]

PostgreSQL: Bulk loading huge amounts of data

by Hans-Jürgen Schönig | 05.2021
This article is about bulk loading, which is the quickest way to import large amounts of data into a PostgreSQL database.

PostgreSQL: Detecting slow queries quickly

by Hans-Jürgen Schönig | 05.2021
UPDATED Mar 2023: How to use pg_stat_statements to detect slow queries - including examples and code - improve PostgreSQL performance

Terminating database connections in PostgreSQL

by Hans-Jürgen Schönig | 05.2021
This blog posting explains you, how to terminate queries and database connections in PostgreSQL. Find out more.

How the PostgreSQL query optimizer works

by Hans-Jürgen Schönig | 03.2021
Get insight into how the PostgreSQL optimizer works and how it speeds up queries. Find out about anti-join & from_collapse_limit.

PostgreSQL: CREATE STATISTICS - advanced query optimization

by Hans-Jürgen Schönig | 02.2021
The PostgreSQL query planner doesn't know which data usually correlates. How to use CREATE STATISTICS to find correlations.
1 … 3 4 5 6 7 … 17
CYBERTEC Logo white
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