Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum lock conflict - Mailing list pgsql-general

From Michael Lewis
Subject Re: Autovacuum lock conflict
Date
Msg-id CAHOFxGr_L9r2j41TCc9vPtZ4YQ8n2C-udthnCJDS2qRMHivG5A@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum lock conflict  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Autovacuum lock conflict
List pgsql-general
Tree view
- For tables that receive only INSERTs, schedule a regular VACUUM
  with "cron" or similar.  Unfortunately, PostgreSQL isn't very smart
  about vacuuming insert-only tables.


What is the need to vacuum on an insert only table? Does that just maintain the freespace map?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: can't install pg 12 beta on centos 6
Next
From: Corey Taylor
Date:
Subject: Re: postgres 9.6: insert into select finishes only in pgadmin not psql