From: jing han <jing_han_66@yahoo.com>
To: postgres interface <pgsql-interfaces@postgresql.org>
Subject: problems about updating a table and cluster this table at the same time
Date: Mon, 15 Aug 2005 10:03:54 -0700 (PDT)
Message-ID: <20050815170354.49947.qmail@web53509.mail.yahoo.com> (raw)
Hello,
I work on a large database. I make use of cron job to
cluster certain database table periodically.
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.
I tried to lock that table using 'lock tableName'
command before updating that table, I run 'clusterdb
-t tableName dbName', I found clusterdb ignore the
fact that the table is locked and go ahead finishing
cluster job.
So how can I protect the table when I update it to
avoid cluster cron job interrupt the update?
Any suggestion will be greatly appreciated!
jing
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jing_han_66@yahoo.com
Subject: Re: problems about updating a table and cluster this table at the same time
In-Reply-To: <20050815170354.49947.qmail@web53509.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox