Quoting "Scott Marlowe" :
Whether or not max relations is the root of the login hang problem,
you likely have gotten a fair bit of bloat in your database if your
setting was too low by a factor of 10 for so long.You may need to
look at recovering lost space in bloated tables and / or indexes.
On Wed, May 13, 2009 at 1:42 AM, Henry wrote:
> Quoting "Thomas Markus" :
>>
>> check your hardware (especially harddrive) for errors.
>
> Ja, that was my first suspicion as well, but no. Using a RAID5 setup, with
> smart monitoring, etc ... no errors.
>
> I've also just bumped up max_fsm_relatio
Quoting "Thomas Markus" :
check your hardware (especially harddrive) for errors.
Ja, that was my first suspicion as well, but no. Using a RAID5 setup,
with smart monitoring, etc ... no errors.
I've also just bumped up max_fsm_relations to 1 - it was using the
default of 1000 or somet
Hi,
check your hardware (especially harddrive) for errors.
regards
Thomas
Henry schrieb:
>
> Greets,
>
> Pg: 8.3.7
>
> I'm trying to diagnose why I cannot login to Pg on occasion. The psql
> command will just hang (so I cannot get in to see what it's doing) and
> a telnet into 5432 will give t
Greets,
Pg: 8.3.7
I'm trying to diagnose why I cannot login to Pg on occasion. The psql
command will just hang (so I cannot get in to see what it's doing) and
a telnet into 5432 will give the usual:
Connected to localhost (127.0.0.1).
Escape character is '^]'.
indicating the backend ac
