Re: Query with limit goes from few ms to hours

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
Subject: Re: Query with limit goes from few ms to hours
From: henk de wit <henk53602@xxxxxxxxxxx>
Date: Sun, 14 Oct 2012 09:04:35 +0200
Importance: Normal
In-reply-to: <COL104-W53D001BC091CFA02343989F5720@phx.gbl>
References: <COL104-W53D001BC091CFA02343989F5720@phx.gbl>

Hi,

For some reason the mailinglist software seems to block the email as soon as the planner details are in it, so I pasted those on pastebin.com: http://pastebin.com/T5JTwh5T

Kind regards

Follow-Ups:
- Re: Query with limit goes from few ms to hours
  - From: Robert Klemme
- Re: Query with limit goes from few ms to hours
  - From: Tom Lane

References:
- Query with limit goes from few ms to hours
  - From: henk de wit

Prev by Date: Query with limit goes from few ms to hours
Next by Date: Re: Index over all partitions (aka global index)?
Previous by thread: Query with limit goes from few ms to hours
Next by thread: Re: Query with limit goes from few ms to hours
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux