Re: Weird error - Mailing list pgsql-general

From Philip Molter
Subject Re: Weird error
Date
Msg-id 20010627082735.I12723@datafoundry.net
Whole thread Raw
In response to Re: Weird error  (Alex Pilosov <alex@pilosoft.com>)
Responses Re: Weird error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Jun 27, 2001 at 06:16:35AM -0400, Alex Pilosov wrote:
: This is definitely FALSE. Vacuum does not lock the database, it acquires
: certain locks while its vacuuming certain tables. I.E. your clients may
: not be able to modify table while its being vacuumed.
:
: Regarding the error you are getting: Which postgres version is it? See if
: 7.1.2 has it fixed...

I am using 7.1.2.  Plenty of memory (512MB, about 300MB used), Linux
2.4.2, SMP.  The problem is real intermittent.  It's happened twice in
the 24 hours the system has been running (this particular action
happens once an hour).

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip@datafoundry.net

pgsql-general by date:

Previous
From: Feite Brekeveld
Date:
Subject: vacuum job taking very long time to complete
Next
From: Justin Clift
Date:
Subject: Re: PostgreSQL book online