Re: Restore performance?
От
Tom Lane
Тема
Re: Restore performance?
Дата
Msg-id
26129.1144682669@sss.pgh.pa.us
Ответ на
Re: Restore performance? (Jesper Krogh)
Список
Дерево обсуждения
Restore performance? Jesper Krogh <jesper@krogh.cc>
Re: Restore performance? Andreas Pflug <pgadmin@pse-consulting.de>
Re: Restore performance? Vivek Khera <vivek@khera.org>
Re: Restore performance? "Jesper Krogh" <jesper@krogh.cc>
Re: Restore performance? Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
Re: Restore performance? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Restore performance? Jesper Krogh <jesper@krogh.cc>
Re: Restore performance? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Restore performance? Alvaro Herrera <alvherre@commandprompt.com>
Re: Restore performance? "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Restore performance? PFC <lists@peufeu.com>
"Jesper Krogh" writes: > gzip does not seem to be the bottleneck, on restore is psql the nr. 1 > consumer on cpu-time. Hm. We've seen some situations where readline mistakenly decides that the input is interactive and wastes lots of cycles doing useless processing (like keeping history). Try "psql -n" and see if that helps. regards, tom lane
В списке pgsql-performance по дате отправления
