JC Praud escribió:
> - Last night the database locked. pg_log full of messages about insert into
> the mother table waiting for a lock.
This bit does not make much sense to me. A transaction waiting will not
show up in the log. Were they cancelled? Can you paste an extract from
> - After about 40min, the waiting queries acquired their locks and ran.
Do you have a vacuum in cron or something like that? As Tom says, if it
had been autovacuum, it should have been cancelled automatically (else
we've got a bug); but something invoking vacuum externally wouldn't
have, so what you describe is what we would expect.
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-general by date
|Next:||From: John R Pierce||Date: 2009-10-27 23:58:23|
|Subject: Re: how to identify outliers|
|Previous:||From: Merlin Moncure||Date: 2009-10-27 23:18:22|
|Subject: Re: Slow running query with views...how to increase efficiency? with index?|