Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Ramon OrticioDate: 2005-12-27 08:25:00
Subject: Re: 2 Questions
Previous:From: Tom LaneDate: 2005-12-27 05:56:05
Subject: Re: speeding up pg_dump?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group