Andreas Wernitznig <andreas(at)insilico(dot)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
In response to
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2001-10-05 15:13:14|
|Subject: Bug #475: "hard coded" tk.h search|
|Previous:||From: Tom Lane||Date: 2001-10-05 13:48:50|
|Subject: Re: Bug #474: Index using problem |