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

Reply via email to