Re: Copy command Faster than original select

2015-02-06 10:15 GMT+01:00 Belal Al-Hamed <belalhamed(at)gmail(dot)com>:

> "this slowdown can be enforced by slow client (or slow network)."
> As I said i made the tow test on the same machine as the server using
> PGAdmin no network involved.
>
> "pgAdmin is not terrible fast"
> I also try the same query from my application using libpq I get same
> results
>

what is speed of

CREATE TABLE xx AS SELECT /* your query */ ?

regards

Pavel

>
> regards
>
>
>
> --
> View this message in context:
> http://postgresql.nabble.com/Copy-command-Faster-than-original-select-tp5836886p5836893.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
>