Sebastien Lemieux <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
