very slow when writing query to file

Поиск
Список
Период
Сортировка
От boris pezzatti
Тема very slow when writing query to file
Дата
Msg-id 4EA803AB.4090709@wsl.ch
обсуждение исходный текст
Ответы Re: very slow when writing query to file  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
I have a postgresql database 8.3 on a server. When querying the data 
with the pgAdmin sql editor, I can get an answer in about 10 s, for 
100'000 rows. When I'm pressing the button to execute the query to a 
file it takes more than 1 hour to get the query results saved (writes 
about 10 MB in 45 minutes).

Am I doing something wrong?
Are there some parameters to set?

This happens with the version 1.14 of pgAdmin, but used also to be very 
slow with the previous versions (2-3 years ago).

OS : Archlinux (but had the same problem 1-2 years ago with ubuntu)

Thank you ,
Boris



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

Предыдущее
От: Henry Drexler
Дата:
Сообщение: Re: Minor bug, keyboard navigation
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Re: Bug - Rows in Query Output pane fail to grow in height when font size preference size is larger