Re: PostgreSQL 9.0.4 blocking in lseek?

From: Sören Meyer-Eppler <soerenme(at)google(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?
Date: 2011-10-31 13:56:32
Message-ID: 4EAEA910.9070000@google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> (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
is XFS.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sören Meyer-Eppler 2011-10-31 14:09:37 Re: PostgreSQL 9.0.4 blocking in lseek?
Previous Message Sorbara, Giorgio (CIOK) 2011-10-31 13:52:21 Re: Strange query plan