| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: db grows and grows |
| Date: | 2002-06-19 16:07:31 |
| Message-ID: | 20020619120731.A20388@mail.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2002-06-19 16:09:56 | Re: pl/pgsql function not working |
| Previous Message | Jeff MacDonald | 2002-06-19 16:01:46 | jobs.postgresql.org - sugggestion. |