Re: db grows and grows

On Wed, Jun 19, 2002 at 09:30:23AM -0500, Shaun Thomas wrote:
> On 18 Jun 2002, Jason Earl wrote:

> My script doesn't really lock anything, it must just be a natural
> side-effect of the REINDEX command,

According to

<http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/locking-tables.html>

CREATE INDEX gets a ShareLock.  Which will block UPDATE, DELETE and
INSERT.  So, not _quite_ as bad as VACUUM FULL, but not something to
do in the middle of a busy day.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110