> From: Christo Du Preez
> Sent: Tuesday, June 12, 2007 2:38 AM
> Where do I set the planner settings or are you reffering to
> settings in postgres.conf that may affect the planner?
Yes I'm reffering to settings in postgres.conf. I'm wondering if
enable_indexscan or something got turned off on the server for some reason.
Here is a description of those settings:
So when you move data from the laptop to the server, I see that your script
correctly runs an analyze after the load, so have you run analyze on the
fast laptop lately? Hopefully running analyze wouldn't make the planner
choose a worse plan on the laptop, but if we are trying to get things
consistant between the laptop and server, that is something I would try.
If the consistancy problem really is a problem of the planner not using
index scans on the server, then if you can, please post the table definition
for the table with a million rows and an EXPLAIN ANALYZE of a query which
selects a few rows from the table.
In response to
pgsql-performance by date
|Next:||From: Steinar H. Gunderson||Date: 2007-06-12 14:30:33|
|Subject: Re: test / live environment, major performance difference|
|Previous:||From: Arnau||Date: 2007-06-12 14:27:39|
|Subject: How much memory PostgreSQL is going to use?|