2015-02-06 10:15 GMT+01:00 Belal Al-Hamed <belalha...@gmail.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
