Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy command Faster than original select - Mailing list pgsql-performance

From Belal Al-Hamed
Subject Re: Copy command Faster than original select
Date
Msg-id 1423390110274-5837105.post@n5.nabble.com
Whole thread Raw
In response to Re: Copy command Faster than original select  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Copy command Faster than original select
Next
From: sridhar bamandlapally
Date:
Subject: Vs NULL