Re: Index Scans become Seq Scans after VACUUM ANALYSE - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date
Msg-id 3CBE3191.99192319@fourpalms.org
Whole thread Raw
In response to Re: Index Scans become Seq Scans after VACUUM ANALYSE  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
...
> I'm of a belief that *eventually* we really can take enough of the
> variables into consideration for planning the best query every time.  I
> didn't say it was gunna be soon, nor easy though.

I agree. But I'd like to eliminate the optimizer variability which
depends solely on the syntactical differences between traditional and
"join syntax" inner join queries. If the reason for these differences
are to allow explicit control over join order, let's get another
mechanism for doing that.
                  - Thomas


pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE
Next
From: Justin Clift
Date:
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE