Quick Links

Re: Query with limit goes from few ms to hours

From:	henk de wit <henk53602(at)hotmail(dot)com>
To:	"pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: Query with limit goes from few ms to hours
Date:	2012-10-14 07:04:35
Message-ID:	COL104-W143C114F67F241C003CB4F5720@phx.gbl
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

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

In response to

Query with limit goes from few ms to hours at 2012-10-14 06:55:34 from henk de wit

Responses

Re: Query with limit goes from few ms to hours at 2012-10-14 16:15:32 from Tom Lane
Re: Query with limit goes from few ms to hours at 2012-10-15 12:31:47 from Robert Klemme

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Stefan Keller	2012-10-14 12:22:41	Re: Index over all partitions (aka global index)?
Previous Message	henk de wit	2012-10-14 06:55:34	Query with limit goes from few ms to hours