Postgres Pro
Downloads
Home   >   mailing lists

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

From Капралов Александр
Subject Optimize the query, help me please.
Date
Msg-id CAJqqVEXfy4Q8XK=4OEn6kA7VPeO3Yzwc+Wsk5i-U9HO8EmamKQ@mail.gmail.com
Whole thread Raw
Responses Re: Optimize the query, help me please.  (Raymond O'Donnell <rod@iol.ie>)
Re: Optimize the query, help me please.  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Re: Optimize the query, help me please.  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: autovacuum stuck on a table for 18+ hours, consuming lots of CPU time
Next
From: Raymond O'Donnell
Date:
Subject: Re: Optimize the query, help me please.