Postgres Pro
Downloads
Home   >   mailing lists

Re: reindex/vacuum locking/performance? - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: reindex/vacuum locking/performance?
Date
Msg-id 20031004151854.GK580@libertyrms.info
Whole thread Raw
In response to reindex/vacuum locking/performance?  (Rob Nagler <nagler@bivio.biz>)
List pgsql-performance
Tree view 
On Fri, Oct 03, 2003 at 02:24:42PM -0600, Rob Nagler wrote:
> I've read some posts that says vacuum doesn't lock, but my experience
> today indicates the opposite.  It seemed that "vacuum full analyze"

VACUUM doesn't.  VACUUM FULL does.

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: Re: Tuning/performance issue...
Next
From: Andrew Sullivan
Date:
Subject: Re: reindex/vacuum locking/performance?