Re: PostgreSQL 9.0.4 blocking in lseek? - Mailing list pgsql-performance

From Claudio Freire
Subject Re: PostgreSQL 9.0.4 blocking in lseek?
Date
Msg-id CAGTBQpZfxmdvoLOt7V5QrU8MYdtR2zq-FWYeQ3ZaEKjYVo5w1g@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 9.0.4 blocking in lseek?  (Matteo Beccati <php@beccati.com>)
Responses Re: PostgreSQL 9.0.4 blocking in lseek?
List pgsql-performance
On Wed, Dec 28, 2011 at 3:02 PM, Matteo Beccati <php@beccati.com> wrote:
> The query eventually completed in more than 18h. For comparison a normal
> run doesn't take more than 1m for that specific step.
>
> Do you think that bad stats and suboptimal plan alone could explain such
> a behaviour?

Did you get the explain analyze output?

pgsql-performance by date:

Previous
From: Matteo Beccati
Date:
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?
Next
From: Matteo Beccati
Date:
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?