Postgres Pro
Downloads
Home   >   mailing lists

Re: Horrific time for getting 1 record from an index? - Mailing list pgsql-performance

From Daniel Farina
Subject Re: Horrific time for getting 1 record from an index?
Date
Msg-id CAAZKuFabVWYx2HHGdU_jAiiw35tKRASn1V8bVOFfLmj-O783pQ@mail.gmail.com
Whole thread Raw
In response to Re: Horrific time for getting 1 record from an index?  (Jim Nasby <jnasby@enova.com>)
List pgsql-performance
Tree view 
On Mon, Nov 11, 2013 at 1:57 PM, Jim Nasby <jnasby@enova.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.

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Horrific time for getting 1 record from an index?
Next
From: Jeff Janes
Date:
Subject: Re: Horrific time for getting 1 record from an index?