Quick Links

Re: BUG #14302: SQL with LIMIT degrades performance seriously

From:	Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To:	Kaijiang Chen <chenkaijiang(at)gmail(dot)com>
Cc:	Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject:	Re: BUG #14302: SQL with LIMIT degrades performance seriously
Date:	2016-08-31 05:01:39
Message-ID:	87zint4joz.fsf@news-spur.riddles.org.uk
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

>>>>> "Kaijiang" == Kaijiang Chen <chenkaijiang(at)gmail(dot)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)

	From	Date	Subject
Next Message	Christoph Berg	2016-08-31 09:35:27	Re: Re: [BUGS] BUG #14299: initdb and man pages are not installed in the alternatives system
Previous Message	Kaijiang Chen	2016-08-31 04:09:50	Re: BUG #14302: SQL with LIMIT degrades performance seriously