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.

What PostgreSQL Full-Text-Search has to do with VACUUM

by Hans-Jürgen Schönig | 03.2018
What does PostgreSQL Full-Text-Search have to do with VACUUM? Find out about the GIN pending list and how to use it to improve performance.

New features for sequences: gains and pitfalls

by Laurenz Albe | 02.2018
About sequences Sequences are used to generate artificial numeric primary key columns for tables. A sequence provides a “new ID” […]

PostgreSQL performance: How the optimizer handles views

by Hans-Jürgen Schönig | 02.2018
How does the PostgreSQL optimizer handle views? Are views good or bad? Write better and faster code, improve performance.

Detect PostgreSQL performance problems easily

by Hans-Jürgen Schönig | 02.2018
Every DBA in charge of PostgreSQL should know, how to track down potential performance problems to figure out, what is really going on.

PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics)

by Hans-Jürgen Schönig | 02.2018
Introduction to PostgreSQL indexing. How and when to use an index scan, bitmap scan and/or sequential scan. Get performance tips.

Avoiding unnecessary function calls in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
Fix bad performance related to slow function calls: When it comes to slow procedures, PostgreSQL often isn't to blame. Here's why.

CYBERTEC pgconfigurator: Configuring PostgreSQL visually

by Hans-Jürgen Schönig | 01.2018
CYBERTEC pgconfigurator is the ideal tool to configure postgresql.conf visually. PostgreSQL configuration has never been easier.

How a bad network configuration can cause table bloat

by Laurenz Albe | 01.2018
(Updated 2023-04-20) I recently had an interesting support case with table bloat that shows how the cause of a problem […]

ALTER TABLE: High-Availability taken care of

by Hans-Jürgen Schönig | 01.2018
Adding columns, dropping columns,... might be necessary. But changing data structures should not be done mindlessly. Use ALTER TABLE wisely.

PostgreSQL: Speeding up GROUP BY and joins

by Hans-Jürgen Schönig | 12.2017
Most people actually implement aggregations slightly wrong in PostgreSQL. This blogpost shows how to spped up group by and joins.
1 10 11 12 13 14 17
CYBERTEC Logo white
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