Thank you for your post. I finally spent some quality time with the query
planner section in the docs' server config chapter. Very instructive, even
considering that most of it went over my head!
On Sat, Mar 8, 2008 at 4:08 PM, Tom Lane [EMAIL PROTECTED] wrote:
...have you got
Kynn Jones [EMAIL PROTECTED] writes:
So it seems like turning off ENABLE_SEQSCAN is the way to go.
Try reducing random_page_cost a bit instead. Also, have you got
effective_cache_size set to something that's realistic for your
machine?
One problem with this test is that your smaller tables
Kynn Jones wrote:
my_db= SET ENABLE_SEQSCAN TO OFF;
my_db= EXPLAIN ANALYZE SELECT * FROM T NATURAL JOIN B;
QUERY PLAN