Re: PostgreSQL seems to wait and block all the queries

From: William Yu <wyu(at)talisys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL seems to wait and block all the queries
Date: 2004-10-07 16:30:59
Message-ID: ck3qsl$nd9$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Eyinagho Newton 2004-10-07 16:41:47 Reading a text file into PostgreSQL
Previous Message Vic Cekvenich 2004-10-07 16:30:37 pre-sroted table (w/ index)