Postgres Pro
Downloads
Home   >   mailing lists

Re: problems about updating a table and cluster this table at the same time - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: problems about updating a table and cluster this table at the same time
Date
Msg-id 11063.1124130401@sss.pgh.pa.us
Whole thread Raw
In response to problems about updating a table and cluster this table at the same time  (jing han <jing_han_66@yahoo.com>)
List pgsql-interfaces
Tree view 
jing han <jing_han_66@yahoo.com> writes:
> I found when updating a table and clusterdb cron job
> happens to run at exactly the same time clustering
> that table, then both updating and clustering stuck.
> Database server hault. This cause my system hault.

This is really hard to believe.  Can you give us a repeatable test case?
        regards, tom lane

pgsql-interfaces by date:

Previous
From: Munteanu Gabriel
Date:
Subject: unsubscribe
Next
From: elein@varlena.com (elein)
Date:
Subject: Re: [GENERAL] in transaction