CYBERTEC 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.

PostgreSQL: DELETE vs. TRUNCATE

by Hans-Jürgen Schönig | 03.2023
Data isn't only about storage and accumulation - sometimes it's also about deletion, cleanup and archiving. In SQL there's more […]

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
Analyzing time series often comes with challenges. This is especially true if you want to do a bit more than […]

JSON logs in PostgreSQL 15

by Hans-Jürgen Schönig | 12.2022
As of version 15, PostgreSQL offers you the ability to write the server log in JSON format. This feature has […]

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
Indexing is the key to good performance. However, people often ask: Is there an alternative to btree indexing? Can we […]
1 2 3 4 5 … 18
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