Re: psql \q hang

Поиск
Список
Период
Сортировка
От Jeff Ross
Тема Re: psql \q hang
Дата
Msg-id 4CAB33EC.5020904@wykids.org
обсуждение исходный текст
Ответ на Re: psql \q hang  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: psql \q hang  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 10/04/10 15:55, Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
>> This is more of an odd anoyance than anything, but for the past month or
>> so when I \q out of psql I have to wait 20-25 seconds for the return to
>> the shell prompt.  This is the only copy of psql running and it doesn't
>
> Perhaps there is an issue writing to the ~/.psql_history file? Try running
> with --no-readline and see if it still happens. Otherwise, consider
> using strace or lsof to see what it is doing during those 20 seconds.
>
> - --
> Greg Sabino Mullane greg@turnstep.com
> End Point Corporation http://www.endpoint.com/
> PGP Key: 0x14964AC8 201010041754
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----

Thanks for the hint, Greg!  It was indeed the .psql_history file.
Although I'm using the default history size, the file was over 5MB in
size and full of a table dump.  I truncated the file and no more delay
quitting psql.

Jeff


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

Предыдущее
От: Miklosi Attila
Дата:
Сообщение: Re: error messages
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: queriing the version of libpq