On Wed, Dec 14, 2016 at 5:59 AM, Michael Paquier
wrote:
> On Wed, Dec 14, 2016 at 5:00 AM, Torsten Förtsch
> wrote:
> > one of the major enhancements in 96 is skipping completely frozen pages
> in
> > vacuum freeze. I assume that requires a special bit on the page.
>
> The freeze map uses an add
On Wed, Dec 14, 2016 at 5:00 AM, Torsten Förtsch wrote:
> one of the major enhancements in 96 is skipping completely frozen pages in
> vacuum freeze. I assume that requires a special bit on the page.
The freeze map uses an additional bit in the vm, and pg_upgrade would
take care of the conversion
Hi,
one of the major enhancements in 96 is skipping completely frozen pages in
vacuum freeze. I assume that requires a special bit on the page.
If I upgrade from 93 using pg_upgrade, that is re-using the data files, can
it still do that? Or do I have to recreate the table?
Thanks,
Torsten
On Thu, Dec 4, 2014 at 9:02 AM, Mike Blackwell
wrote:
> check_postgres.pl (--action=autovac_freeze) recently complained that we
> needed to run VACUUM FREEZE. Doing so generated a boatload of WAL files -
> perhaps on the order of the of the database itself.
>
> Is VACUUM FREEZE something that is
On Thu, Dec 4, 2014 at 12:02 PM, Mike Blackwell wrote:
> check_postgres.pl (--action=autovac_freeze) recently complained that we
> needed to run VACUUM FREEZE. Doing so generated a boatload of WAL files -
> perhaps on the order of the of the database itself.
>
> Is VACUUM FREEZE something that is
I don't think autovacuum can predict you will not update your table(s)
anymore, so there's no way to know to run FREEZE on it.
On Thu, Dec 4, 2014 at 12:02 PM, Mike Blackwell
wrote:
> check_postgres.pl (--action=autovac_freeze) recently complained that we
> needed to run VACUUM FREEZE. Doing so
check_postgres.pl (--action=autovac_freeze) recently complained that we
needed to run VACUUM FREEZE. Doing so generated a boatload of WAL files -
perhaps on the order of the of the database itself.
Is VACUUM FREEZE something that is normally handled by autovac? If so, how
would we approach findi
=?iso-8859-2?Q?Zlatko_Mati=E6?= <[EMAIL PROTECTED]> writes:
> I performed vacuum freeze instead vacuum full, by mistake, using =
> PgAdmin.
> Is there any danger for my database ?
No.
regards, tom lane
---(end of broadcast)-
I performed vacuum freeze instead vacuum full, by
mistake, using PgAdmin.
Is there any danger for my database ?
Zlatko
