Re: Bug #474: Index using problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #474: Index using problem
Date
Msg-id 7019.1002289940@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug #474: Index using problem  (Andreas Wernitznig <andreas@insilico.com>)
Responses Re: Bug #474: Index using problem  (Andreas Wernitznig <andreas@insilico.com>)
List pgsql-bugs
Andreas Wernitznig <andreas@insilico.com> writes:
> If I don't disconnect from the database but use the first connection
> again, the database still uses the (now) slower "seq scan" for
> "primary/foreign key" checking. In this case the query optimizer
> statistics are not updated for established connections.

Sure they are --- in my tests, anyway.  What did you do *exactly*?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #474: Index using problem
Next
From: Nathan Johnson
Date:
Subject: natural join kills postmaster