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.

Pagination and the problem of the total result count

by Laurenz Albe | 01.2023
  When processing a big result set in an interactive application, you want to paginate the result set, that is, […]

Improving GROUP BY with CREATE STATISTICS

by Hans-Jürgen Schönig | 01.2023
For a PostgreSQL time series report - find out how CREATE STATISTICS can improve performance when you group on expressions

JSON logs in PostgreSQL 15

by Hans-Jürgen Schönig | 12.2022
Find out how JSON logs can be configured in PostgreSQL 15 and get all the advantages of this brand new feature

UNION ALL, data types and performance

by Laurenz Albe | 12.2022
  A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]

pg_dump compression specifications in PostgreSQL 16

by Pavlo Golub | 12.2022
What is pg_dump compression? pg_dump is a PostgreSQL utility for backing up a local or remote PostgreSQL database. It creates […]

Faceting large result sets in PostgreSQL

by Ants Aasma | 12.2022
While the term faceting may sound foreign to you, you almost certainly have run into it in your adventures online. […]

EXPLAIN that parameterized statement in PostgreSQL!

by Laurenz Albe | 11.2022
  For detailed query performance analysis, you need EXPLAIN (ANALYZE, BUFFERS) output for an SQL statement. With a parameterized statement, […]

Rewrite OR to UNION in PostgreSQL queries

by Laurenz Albe | 11.2022
  In my article that reviles OR, I showed how in certain cases, it is possible to rewrite OR in […]

btree vs. BRIN: 2 options for indexing in PostgreSQL data warehouses

by Hans-Jürgen Schönig | 11.2022
How do you index in a data warehouse? See the advantages and disadvantages of btree (AKA B-tree) and BRIN indexes in PostgreSQL.

Why are my PostgreSQL updates getting slower?

by Laurenz Albe | 10.2022
  Recently, a customer asked me why a bulk load into a PostgreSQL table kept slowing down as time went […]
1 2 3 4 5 … 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