Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Sören Meyer-EpplerDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group