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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
