Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with limit goes from few ms to hours - Mailing list pgsql-performance

From Tom Lane
Subject Re: Query with limit goes from few ms to hours
Date
Msg-id 26280.1350231332@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query with limit goes from few ms to hours  (henk de wit <henk53602@hotmail.com>)
Responses Re: Query with limit goes from few ms to hours
List pgsql-performance
Tree view 
henk de wit <henk53602@hotmail.com> writes:
> For some reason the mailinglist software seems to block the email as soon as the planner details are in it, so I
pastedthose on pastebin.com: http://pastebin.com/T5JTwh5T 

You need a less horrid estimate for the join size.  Possibly an ANALYZE
on the parent table (stream_store) would help.

            regards, tom lane

pgsql-performance by date:

Previous
From: Stefan Keller
Date:
Subject: Re: Index over all partitions (aka global index)?
Next
From: John Nash
Date:
Subject: WebSphere Application Server support for postgres