On 17 Mar 2003, Trevor Bylsma wrote:
> I'm using postgreSQL and perl DBI and have come across this issue:
>
> postmaster will use most of the CPU for an extended amount of time
> (which isn't odd) but 75% of that is system level (which seems odd)...
When was the last time you vacuum / analyzed this database? It sounds
like it may be that the system is having to look through thousands of dead
tuples to return your dataset, hence the high system load.
Could be index bloat too.
How much space does the $PGDATA directory on both those machines take up?
(i.e. 'du -s $PGDATA' as the postgres super user.)