From: Patrick Vachon <pvachon.videotron@videotron.ca>
To: pgsql-performance@postgresql.org
Subject: Difference between 8.1 & 8.3
Date: Wed, 16 Jul 2008 17:37:58 -0400
Message-ID: <487E6A36.3010100@videotron.ca> (raw)
Hi guys,
I've got a query that is running slower on 8.3 than on 8.1 (with
equivalent server config),
because the join ordering is not the same, at least that's my guess... ;-)
In 8.1.4, table A had 122880 pages, B 112690 pages and C 80600 pages.
Now in 8.3.3, table A has only 77560 pages, B 69580 but C remains at
80600 pages.
In 8.1 the tables were joined in that way (using explain analyse):
C join A join B
now in 8.3:
B join A join C
Beside that, the plan is very similar, but the indexes used are not the
same.
Could the number of disk pages of a table influence the
order in which it is joined, even when it is scanned with an index?
I'm pretty sure it is because of the reduced table sizes,
since the server configuration is the same.
Thoughts?
Thanks,
Patrick
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pvachon.videotron@videotron.ca
Subject: Re: Difference between 8.1 & 8.3
In-Reply-To: <487E6A36.3010100@videotron.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox