Joost Kraaijeveld wrote:
Hi all,
I have a freshly vacuumed table with 1104379 records with a index on zipcode.
Can anyone explain why the queries go as they go, and why the performance
differs so much (1 second versus 64 seconds, or stated differently, 1
records per second versus 1562 recor
Hi all,
I have a freshly vacuumed table with 1104379 records with a index on zipcode.
Can anyone explain why the queries go as they go, and why the performance
differs so much (1 second versus 64 seconds, or stated differently, 1
records per second versus 1562 records per second) and why t
