Re: speeding up pg_dump?

From: <me(at)alternize(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: speeding up pg_dump?
Date: 2005-12-27 06:10:23
Message-ID: 007f01c60aac$3995f760$6402a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Every transaction takes ExclusiveLock on its own transaction ID. That
> in itself isn't an issue. You sure you don't see any rows with granted
> = 'f' while pg_dump is running and everything seems blocked?

yes. during a pg_dump, there are like 30 locks - all of then granted (t)

i'll set up pg8.1.1 tomorrow on a new server to check if its db/web or
server related...

best regards,
thomas

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ramon Orticio 2005-12-27 08:25:00 Re: 2 Questions
Previous Message Tom Lane 2005-12-27 05:56:05 Re: speeding up pg_dump?