Re: Copy command Faster than original select

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Copy command Faster than original select
Дата
Msg-id CAFj8pRAx4kEBc8fomWdUtERs9VKVi_wXbO-wSw1r=9P-w0mP8w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Copy command Faster than original select  (Belal Al-Hamed <belalhamed@gmail.com>)
Ответы Re: Copy command Faster than original select
Список pgsql-performance


2015-02-06 10:15 GMT+01:00 Belal Al-Hamed <belalhamed@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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Belal Al-Hamed
Дата:
Сообщение: Re: Copy command Faster than original select
Следующее
От: Belal Al-Hamed
Дата:
Сообщение: Re: Copy command Faster than original select