Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM ANALYZE block the whole database - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: VACUUM ANALYZE block the whole database
Date
Msg-id 501A5FC8020000250004934E@gw.wicourts.gov
Whole thread Raw
In response to VACUUM ANALYZE block the whole database  (Majid Azimi <majid.merkava@gmail.com>)
List pgsql-admin
Tree view 
Majid Azimi <majid.merkava@gmail.com> wrote:

> ran VACUUM ANALYZE on it(it is not VACUUM FULL). but this cause
> the database to completely block.

Please show the results from running the query here:

http://wiki.postgresql.org/wiki/Server_Configuration

-Kevin

pgsql-admin by date:

Previous
From: "Anibal David Acosta"
Date:
Subject: Re: Timeout error on pgstat
Next
From: Scott Marlowe
Date:
Subject: Re: VACUUM ANALYZE block the whole database