| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Yann Michel <yann-postgresql(at)spline(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: PG_DUMP and table locking in PG7.4 |
| Date: | 2005-11-16 07:22:11 |
| Message-ID: | 437ADE23.6070107@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> I'm asking, because we have a bigger datawarehouse and dump the data for
> a backup every night. Unfortunately, the backup now takes realy long.
> That means, other processes that insert data will have to wait which is
> sometime really long! I was searching for a way to avoid this. I thought
> besides the query-speedub we could also gain some benefit for the backup
> timing... but it sounds, that this will not automatically help me with
> that. :-(
No, all the tables are locked in ACCESS SHARE mode. All that means is
that you cannot alter the schema of the tables in any way.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2005-11-16 07:28:31 | Re: PG_DUMP and table locking in PG7.4 |
| Previous Message | Yann Michel | 2005-11-16 07:09:31 | Re: PG_DUMP and table locking in PG7.4 |