Home > mailing lists

Optimize the query, help me please. - Mailing list pgsql-general

From	Капралов Александр
Subject	Optimize the query, help me please.
Date	November 23, 2011 06:57:20
Msg-id	CAJqqVEXfy4Q8XK=4OEn6kA7VPeO3Yzwc+Wsk5i-U9HO8EmamKQ@mail.gmail.com Whole thread
Responses	Re: Optimize the query, help me please. Re: Optimize the query, help me please. Re: Optimize the query, help me please.
List	pgsql-general

Query is:

SELECT * FROM a UNION SELECT * FROM b ORDER BY time DESC LIMIT 100

how can i get only last 100 row from a and b and then do union. Explain of select said that all recond selected from a and b.

thanks.

From: Scott Marlowe
Date: 23 November 2011, 02:27:51
Subject: Re: autovacuum stuck on a table for 18+ hours, consuming lots of CPU time

From: Raymond O'Donnell
Date: 23 November 2011, 07:07:47
Subject: Re: Optimize the query, help me please.