CYBERTEC Logo

Tag: query tuning

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

Enforcing join orders in PostgreSQL

by Hans-Jürgen Schönig | 03.2024
After the pgconfeu23 in Prague - which has been an excellent event - I decided to share some of the […]

Forcing a join order in PostgreSQL

by Laurenz Albe | 05.2023
  Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]

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 […]

Query parameter data types and performance

by Laurenz Albe | 03.2022
  Recently, I could help solve a “mysterious” performance problem for a customer. The problem turned out to be a […]

Data warehousing: Making use of synchronized seq scans

by Hans-Jürgen Schönig | 06.2021
PostgreSQL contains some hidden gems which have been around for many years and help to silently speed up your queries. […]

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: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017
A couple of weeks ago I have seen a horribly designed, 370 billion (with a “b”) row Oracle database monster […]

Using "lightweight" functional indexes - BRIN

by CYBERTEC Guest | 11.2017
By Kaarel Moppel - Using BRIN to improve query performance - This is a quick performance tip for all those […]

Detecting unstable execution times in PostgreSQL

by Hans-Jürgen Schönig | 12.2016
Do you have queries with unstable execution times? You have a query which is sometimes slow and sometimes just lightning […]

paginators - The story about voluntary pain in PostgreSQL

by Hans-Jürgen Schönig | 08.2016
It happens on a quite regular basis that people contact the CYBERTEC PostgreSQL Support Desk to get  support for a […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

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

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