Tag: vacuum

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

What is autovacuum doing to my temporary tables?

by Hans-Jürgen Schönig | 10.2019
Did you know that your temporary tables are not cleaned up by autovacuum? Autovacuum cleans tables automatically Since the days […]

A beginners guide to PostgreSQL's UPDATE and autovacuum

by Hans-Jürgen Schönig | 07.2018
Looking at the type of PostgreSQL support requests, we have received recently, it is striking to see, how many of […]

Four reasons why VACUUM won't remove dead rows from a table

by Laurenz Albe | 03.2018
Why vacuum? Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid […]

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? Many readers might actually be surprised that there might be a […]

Speeding up things with hint bits

by Hans-Jürgen Schönig | 08.2014
Post UPDATED June 2023: PostgreSQL is a highly sophisticated relational database system capable of performing wonderful operations. But, sophistication also […]

Table bloat revisited: Making tables shrink in PostgreSQL

by Hans-Jürgen Schönig | 08.2013
UPDATED August 2023 - Table bloat in PostgreSQL: Many people wonder why deleting data from a table in a PostgreSQL […]
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram