CYBERTEC PostgreSQL Logo

Tag: sql help

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

# GROUP BY: Fixing optimizer estimates

by Hans-Jürgen Schönig | 01.2025
The more columns your GROUP BY statement contains, the more likely it is that optimizer overestimates the row count. Read more how to handle.

The Slonik's Gambit

by Svitlana Lytvynenko | 12.2024
Learn about the technical background of our chess tournament as part of PG Conf EU 2024.

Why "SELECT * FROM table" is NOT a read

by Hans-Jürgen Schönig | 09.2024
People tend to think that a SELECT-operation is always a read. This might look obvious and make sense but does it actually hold true?

Making the PostgreSQL visibility map visible

by Laurenz Albe | 06.2024
This article explains how to examine the PostgreSQL visibility map and showcases performance improvements added in recent releases.

Foreign keys in PostgreSQL: Circular dependencies

by Hans-Jürgen Schönig | 06.2024
In this blog Hans-Jürgen Schönig would like to tell you more about "Foreign keys and circular dependencies".

TDE: A dive into encrypted data

by Andreas Kretschmer | 02.2024
In this article we will tell you how you can find out, if your TDE works and if files on disk are encrypted.

ERROR: current transaction is aborted in PostgreSQL

by Hans-Jürgen Schönig | 10.2023
ERROR: current transaction is aborted, commands ignored until end of transaction block in PostgreSQL: what it means & how to fix this error.

Kill long running queries in PostgreSQL

by Hans-Jürgen Schönig | 10.2023
How to detect and terminate long running queries in PostgreSQL using two different methods. Also: How to automatically kill slow queries.

"hired" vs. "fired" - fuzzy search in PostgreSQL

by Hans-Jürgen Schönig | 09.2023
How to implement community open source PostgreSQL to do a fuzzy search & get better results. Find out how to use the fuzzystrmatch extension.

Exclusion constraints in PostgreSQL and a tricky problem

by Christoph Berg | 09.2023
Exclusion constraints in PostgreSQL are complex, see this use case using WHERE STATUS. There are limits to what exclusion constraints can do.
1 2 3 … 14
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.

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