From: Tom Lane <tgl@sss.pgh.pa.us>
To: Carlos Moreno <moreno@mochima.com>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Having trouble with backups (was: Re: Crash Recovery)
Date: Fri, 24 Jan 2003 16:01:41 -0500
Message-ID: <22650.1043442101@sss.pgh.pa.us> (raw)
In-Reply-To: <3E3158DA.7080807@mochima.com>
References: <2147483647.1043361178@[10.0.1.133]>
<1043416377.29437.70.camel@haggis>
<3E3158DA.7080807@mochima.com>
Carlos Moreno <moreno@mochima.com> writes:
> And the second (and intriguing) problem: whenever I run pg_dump,
> my system *freezes* until pg_dump finishes. When I say "system",
> I mean the software that is running and sending data to the PG
> database.
Other people have responded on the assumption that this is a performance
problem, but you should also consider the possibility that it's bad
coding of your application software. Does your app try to grab
exclusive table locks? If so, it'll sit there waiting for the pg_dump
to complete. pg_dump only takes ACCESS SHARE lock on the tables it's
working on, which is the weakest type of lock and does not conflict with
most database operations ... but it does conflict with ACCESS EXCLUSIVE
lock requests.
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, moreno@mochima.com
Subject: Re: Having trouble with backups (was: Re: Crash Recovery)
In-Reply-To: <22650.1043442101@sss.pgh.pa.us>
References: <2147483647.1043361178@[10.0.1.133]> <1043416377.29437.70.camel@haggis> <3E3158DA.7080807@mochima.com> <22650.1043442101@sss.pgh.pa.us>
* 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