ere any missing ???i have configured python libmy box is using freebsd 5.0, python 2.4.2, postgresql-8.1.2
thank you all for your kinness---(end of broadcast)---TIP 4: Have you searched our list archives?
http://archives.postgresql.org-- Atte: Dario Brignardello
anation of the statistics views, check:
http://www.postgresql.org/docs/7.4/interactive/monitoring-stats.htmlHope it helps.Best regardsDario -- Atte: Dario Brignardello
time of failing),
> but no suspects found.
>
> Kindly give me a solution to overcome this problem.
> Also kindly tell me a way to find, which process is accessing the
> template1.
>
>
> Thanks in advance.
>
> regards
> KArthik.S
>
>
>
ages during that time?
>
> |-Original Message-
> |From: Dario Brignardello [mailto:[EMAIL PROTECTED]
> |Sent: Mittwoch, 03. August 2005 19:33
> |To: KÖPFERL Robert
> |Cc: pgsql-admin@postgresql.org
> |Subject: Re: [ADMIN] Blocking connection and timeout problem
> |
ke so. I waited for two hours and it still existed.
>
> But non-the-less. Can this timeout be configured to be less?
>
> |
> | regards, tom lane
> |
>
> ---(end of broadcast)---
> TIP 6: explain analyze
Assuming you are on a linux box (Not sure if it's stated in your mail,
sorry if I missed that) you could set
/proc/sys/net/ipv4/tcp_keepalive_time
to a lower value. That should do the trick.
Hope this helps
Greetings
Dario
On Wed, 2005-08-03 at 16:48 +0200, KÖPFERL Robert wrote:
>
>
>
> |
eatly appreciated. Since now, thanks a lot.
Yours: Dario Brignardello
S/MIME Cryptographic Signature
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Thanks for your help, its working now :-).
Yours:
Dario Brignardello
Tom Lane wrote:
> Dario Brignardello <[EMAIL PROTECTED]> writes:
> > checkpoint_segments = 1
> > checkpoint_timeout = 30
>
> Reducing checkpoint_segments and checkpoint_time
eatly appreciated. Since now, thanks a lot.
Yours: Dario Brignardello
S/MIME Cryptographic Signature
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
