Re: psql \q hang

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