Re: Vacuum, Freeze and Analyze: the big picture

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Vacuum, Freeze and Analyze: the big picture
Date: 2013-06-03 17:46:26
Message-ID: CA+TgmobGXcjWGwMpr434rRTK8F_H3rF8wrNJEU7dJZd1Us_ntg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 3, 2013 at 1:28 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> Does anti-wraparound vacuum (AWAV) write synchronously? If so, there's
> a potential whole world of hurt there.

Not any moreso than anything else ... although it probably does a very
high percentage of FPIs, which might lead to lots of checkpointing.

> Also, locking while it does its work.

Eh?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Миша Тюрин 2013-06-03 17:51:50 Re[2]: [HACKERS] Re: [HACKERS] high io BUT huge amount of free memory
Previous Message Andrew Dunstan 2013-06-03 17:44:21 Re: UTF-8 encoding problem w/ libpq