Bill Moran wrote:
> What I suspect is that the typical tuning advice applies here. I don't
> see any information about your configuration or your hardware setup.
> * What are shared_buffers set at?
> * What do the checkpoint configs look like?
> * In general, what does your postgresql.conf look like, how much tuning
> have you done?
> * What is your hardware setup? You're not running RAID 5 are you?
Also, how many indexes does this table have?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.