From: | Jeff Ross <jross(at)wykids(dot)org> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: psql \q hang |
Date: | 2010-10-05 14:19:00 |
Message-ID: | 4CAB33EC.5020904@wykids.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)turnstep(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2010-10-05 14:32:11 | Re: queriing the version of libpq |
Previous Message | Miklosi Attila | 2010-10-05 13:54:41 | Re: error messages |