Re: speeding up pg_dump? - Mailing list pgsql-novice

From
Subject Re: speeding up pg_dump?
Date
Msg-id 007f01c60aac$3995f760$6402a8c0@iwing
Whole thread Raw
In response to speeding up pg_dump?  (<me@alternize.com>)
List pgsql-novice
From: "Tom Lane" <tgl@sss.pgh.pa.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




pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: speeding up pg_dump?
Next
From: Ramon Orticio
Date:
Subject: Re: 2 Questions