Postgres Pro
Downloads
Home   >   mailing lists

Re: reloption to prevent VACUUM from truncating empty pages at the end of relation - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
Date
Msg-id 844911551340228@iva3-0d9a30469759.qloud-c.yandex.net
Whole thread Raw
In response to Re: reloption to prevent VACUUM from truncating empty pages at theend of relation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Hi

> The default should always be to shrink, unless either the VACUUM
> option or the reloption turn that off. (So it doesn't make sense to set
> either the VACUUM option or the reloption to "on").

I think VACUUM option can be set to "on" by hand in order to override reloption only for this VACUUM call.

regards, Sergei

pgsql-hackers by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: Drop type "smgr"?
Next
From: Masahiko Sawada
Date:
Subject: Re: New vacuum option to do only freezing