pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_dump blocking create database? 2+ messages / 2 participants [nested] [flat]
* pg_dump blocking create database? @ 2007-09-12 19:58 Dan Harris <fbsd@drivefaster.net> 0 siblings, 1 reply; 2+ messages in thread From: Dan Harris @ 2007-09-12 19:58 UTC (permalink / raw) To: pgsql-performance My PG server came to a screeching halt yesterday. Looking at top saw a very large number of "startup waiting" tasks. A pg_dump was running and one of my scripts had issued a CREATE DATABASE command. It looks like the CREATE DATABASE was exclusive but was having to wait for the pg_dump to finish, causing a massive traffic jam of locks behind it. Once I killed the pg_dump process, things returned to normal. Version 8.0.12. Is this a bug? It also concerns me because my workload is likely to expose this problem again. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dump blocking create database? @ 2007-09-13 03:21 Tom Lane <tgl@sss.pgh.pa.us> parent: Dan Harris <fbsd@drivefaster.net> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2007-09-13 03:21 UTC (permalink / raw) To: Dan Harris <fbsd@drivefaster.net>; +Cc: pgsql-performance Dan Harris <fbsd@drivefaster.net> writes: > My PG server came to a screeching halt yesterday. Looking at top saw a very > large number of "startup waiting" tasks. A pg_dump was running and one of my > scripts had issued a CREATE DATABASE command. It looks like the CREATE DATABASE > was exclusive but was having to wait for the pg_dump to finish, causing a > massive traffic jam of locks behind it. > Once I killed the pg_dump process, things returned to normal. > Version 8.0.12. Is this a bug? It's operating as designed :-(. 8.1 and later use less strict locking on pg_database during create/drop database. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-09-13 03:21 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-09-12 19:58 pg_dump blocking create database? Dan Harris <fbsd@drivefaster.net> 2007-09-13 03:21 ` Tom Lane <tgl@sss.pgh.pa.us>
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