Hello all,
I have a table with about 400,000 records and a btree index (numeric). A
simple SELECT * FROM table WHERE id = ... takes more than a second for
every query and I need to query each record at least once. It helps to
do an UPDATE tabel WHERE id IN (..., ...), but I don't have the patience
to wait for more than 400,000 seconds to pass...
I'm looking for a solution, and I think the main problem is that
PostgreSQL may not be able to keep the index on this particular table
entirely in memory. If so, a 'simple' memory upgrade (the server
currently has 1GB) would help a great deal, but could there be other
causes of this problem?
It would be a bit of a waste to have convinced my boss that his servers
(there are a development and a production server involved) need a memory
upgrade, when it turns out not to solve this problem... :(
Regards,
Alban Hertroys,
MAG Productions.