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 9140.1060206456@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to efficiently duplicate a whole schema?  (Sebastien Lemieux <slemieux@elitra.com>)
Responses Re: How to efficiently duplicate a whole schema?  (Sebastien Lemieux <slemieux@elitra.com>)
List pgsql-performance
Sebastien Lemieux <slemieux@elitra.com> writes:
> On Wed, 6 Aug 2003, Tom Lane wrote:
>> The idea here is to make sure that the planner's statistics reflect the
>> "full" state of the table, not the "empty" state.  Otherwise it may pick
>> plans for the foreign key checks that are optimized for small tables.

> I added the 'analyze' but without any noticable gain in speed.  I can't
> use 'truncate' since I need to 'set constraints all deferred'.

What are you using, exactly?

            regards, tom lane

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: PostgreSql under Linux
Next
From: Stephan Szabo
Date:
Subject: Re: How to efficiently duplicate a whole schema?