I am assuming this problem and the other rash of Win32 problems reported
in March are now all fixed in 8.1.4.  If not, please let me know.


Tom Lane wrote:
> I wrote:
> > "Peter Brant" <[EMAIL PROTECTED]> writes:
> >> Does that also explain why an attempt to make a new connection just
> >> hangs?
> > Actually, I was just wondering about that --- seems like a bare
> > connection attempt should not generate any WAL entries.  Do you have any
> > nondefault actions in ~/.psqlrc or something like that?
> I just repeated the hangup scenario here, and confirmed that I can still
> start and stop a plain-vanilla psql session (no ~/.psqlrc, no special
> per-user or per-database settings) without it hanging.  I can also do
> simple read-only SELECTs.  So I'm thinking your hang must involve some
> additional non-read-only actions.
> [ thinks for awhile longer ... ]  No, I take that back.  Once you'd
> exhausted the current pg_clog page (32K transactions), even read-only
> transactions would be blocked by the need to create a new pg_clog page
> (which is a WAL-logged action).  A read-only transaction never actually
> makes a WAL entry, but it does still consume an XID and hence a slot on
> the current pg_clog page.  So I just hadn't tried enough transactions.
>                       regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to