> (1) is it *only* that query?
No. There seem to be one or two others exhibiting similarly bad performance.
> (2) is there some reason you might have excessive disk fragmentation,
> like running on a VM?
No VM. The database is the only thing running on the server. Filesystem
In response to
pgsql-performance by date
|Next:||From: Sören Meyer-Eppler||Date: 2011-10-31 14:09:37|
|Subject: Re: PostgreSQL 9.0.4 blocking in lseek?|
|Previous:||From: Sorbara, Giorgio (CIOK)||Date: 2011-10-31 13:52:21|
|Subject: Re: Strange query plan|