Hi 2015-02-06 9:30 GMT+01:00 belal <belalha...@gmail.com>:
> I made complex select using PGAdmin III Query Editor, Postgre server 9.3 > > > select ... from mytable join .. join ... order by .... > > I get [Total query runtime: 8841 ms. 43602 rows retrieved.] > > but when I use > > copy ([same above select]) to '/x.txt' > I get [Query returned successfully: 43602 rows affected, 683 ms execution > time.] > > these test made on the same machine as the postgresql server. > > > can anyone explain huge difference in executing time? > probably terrible uneffective execution plan can you send a explain analyze of your slow query? Regards Pavel > > best regards all > > > > -- > View this message in context: > http://postgresql.nabble.com/Copy-command-Faster-than-original-select-tp5836886.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 >
