Re: Copy command Faster than original select

Hi

2015-02-06 9:30 GMT+01:00 belal <belalhamed(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>