Re: Horrific time for getting 1 record from an index?

From: Daniel Farina <daniel(at)heroku(dot)com>
To: Jim Nasby <jnasby(at)enova(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Horrific time for getting 1 record from an index?
Date: 2013-11-11 21:59:49
Message-ID: CAAZKuFabVWYx2HHGdU_jAiiw35tKRASn1V8bVOFfLmj-O783pQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 11, 2013 at 1:57 PM, Jim Nasby <jnasby(at)enova(dot)com> wrote:
> We do run a regular process to remove older rows... I thought we were
> vacuuming after that process but maybe not.

Could be a long query, idle-in-transaction, prepared transaction, or
hot standby feedback gone bad, too.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2013-11-11 22:57:16 Re: Horrific time for getting 1 record from an index?
Previous Message Jim Nasby 2013-11-11 21:57:47 Re: Horrific time for getting 1 record from an index?