Postgres Pro
Downloads
Home   >   mailing lists

Re: How to efficiently duplicate a whole schema? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How to efficiently duplicate a whole schema?
Date
Msg-id 9346.1060207612@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to efficiently duplicate a whole schema?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-performance
Tree view 
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> Another thing might be the management of the trigger queue.  I don't think
> 7.3.2 had the optimization for limiting the scans of the queue when you
> have lots of deferred triggers.  It looks like 7.3.4 may though.

Good point.  We put that in in 7.3.3, according to the CVS logs.

            regards, tom lane

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How to efficiently duplicate a whole schema?
Next
From: Yaroslav Mazurak
Date:
Subject: Re: PostgreSQL performance problem -> tuning