With reference to:
Consider a case
1. wherein a database dump takes 2 hrs to complete.
2. A cron gets fired which drops a certain table and recreates it.
3. A set of frequently requested web pages depends on reading from the table in 2
Since 2 will wait for 1 till it finishes, and 3 will wait for 2 this means those
set of webpages will become inaccessible while the backup is in progress.
Whereas if we have something like a lock_timeout 2 will abort within a limited
time duration automatically and the sys admin could get notified to reschedule
it and this problem can get averted.
I feel lock_timeout it will be a nice feature . Lemme know what would be
the solution of the above problem from existing set of features.
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
pgsql-general by date
|Next:||From: Otto Blomqvist||Date: 2004-07-01 00:11:13|
|Subject: pg_dump and pg_restore problems|
|Previous:||From: wespvp||Date: 2004-06-30 23:23:08|
|Subject: Re: backups|