Executing "Select count(a.*) from (select ... from mytable join .. join ...
order by ....) as a;" 

Total query runtime: 454 ms.
1 row retrieved.





--
View this message in context: 
http://postgresql.nabble.com/Copy-command-Faster-than-original-select-tp5836886p5837105.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to