Re: pg_dump blocking create database?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dan Harris <fbsd(at)drivefaster(dot)net>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: pg_dump blocking create database?
Date: 2007-09-13 03:21:13
Message-ID: 25728.1189653673@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dan Harris <fbsd(at)drivefaster(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2007-09-13 05:58:10 Re: [Again] Postgres performance problem
Previous Message Scott Marlowe 2007-09-12 21:58:34 Re: db performance/design question