Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14302: SQL with LIMIT degrades performance seriously - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #14302: SQL with LIMIT degrades performance seriously
Date
Msg-id 87zint4joz.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #14302: SQL with LIMIT degrades performance seriously  (Kaijiang Chen <chenkaijiang@gmail.com>)
Responses Re: BUG #14302: SQL with LIMIT degrades performance seriously
List pgsql-bugs
Tree view 
>>>>> "Kaijiang" == Kaijiang Chen <chenkaijiang@gmail.com> writes:

 Kaijiang> Thank you very much for your quick response!

 Kaijiang> So I know I have to deal with my own solutions. Fortunately,
 Kaijiang> I got the solution with the "WITH" clause:

Why not just create the correct index on each partition?  (parent_id,user_id)

--
Andrew (irc:RhodiumToad)

pgsql-bugs by date:

Previous
From: Kaijiang Chen
Date:
Subject: Re: BUG #14302: SQL with LIMIT degrades performance seriously
Next
From: Christoph Berg
Date:
Subject: Re: [pgsql-pkg-debian] Re: BUG #14299: initdb and man pages are not installed in the alternatives system