Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL seems to wait and block all the queries - Mailing list pgsql-general

From William Yu
Subject Re: PostgreSQL seems to wait and block all the queries
Date
Msg-id ck3qsl$nd9$1@news.hub.org
Whole thread Raw
List pgsql-general
Tree view 
HM wrote:
> I would like to know why the database seems frozen.
 > ...
> The problem happened at 04:15 AM during a vacuum FULL and could occurs
> at every moment

VACUUM FULL locks your tables.

pgsql-general by date:

Previous
From: Steven Klassen
Date:
Subject: Re: Reading a text file into PostgreSQL
Next
From: Ron St-Pierre
Date:
Subject: Re: Reading a text file into PostgreSQL