On Wednesday, Sep 10, 2003, at 11:16 America/Denver, Josh Berkus wrote:
What about explaining your disk setup? Or mentioning
postgresql.conf? For
somebody who wants help, you're ignoring a lot of advice and questions.
Personally, I'm not going to be of any further help until you report
back
Thanks Josh that helped. I had gone looking for some kind of cluster
option but was looking under create database, create index and
initlocation - didn't see the CLUSTER index ON table.
I ran the CLUSTER which took about 2 1/2 hours to complete. That
improved the query performance about 6x - wh
I've got an application that needs to chunk through ~2GB of data. The
data is ~7000 different sets of 300 records each. I put all of the data
into a postgres database but that doesn't look like its going to work
because of how the data lives on the disk.
When the app runs on a 500 Mhz G4 the CP
