Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Vacuum questions...
- From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
- To: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Vacuum questions...
- Date: Tue, 27 Sep 2005 14:47:46 -0400
- Message-id: <433993D2(dot)2050408(at)Yahoo(dot)com>
On 9/24/2005 8:17 PM, Jim C. Nasby wrote:
Would it be difficult to vacuum as part of a dump? The reasoning behindthis is that you have to read the table to do the dump anyway,
I think aside from what's been said so far, it would be rather difficult anyway. pg_dump relies on MVCC and requires to run in one transaction to see a consistent snapshot while vacuum jiggles around with transactions in some rather non-standard way.
Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck(at)Yahoo(dot)com #
- Follow-Ups:
- Re: Vacuum questions...
- From: Jim C. Nasby
- Re: Vacuum questions...
- References:
- Vacuum questions...
- From: Jim C. Nasby
- Vacuum questions...
- Prev by Date: Re: effective SELECT from child tables
- Next by Date: Re: Open items list for 8.1
- Previous by thread: Re: Vacuum questions...
- Next by thread: Re: Vacuum questions...
- Indexes: