From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Peter Brant <Peter(dot)Brant(at)wicourts(dot)gov>, Bugs for PostgreSQL <pgsql-bugs(at)postgreSQL(dot)org>, PostgreSQL-patches <pgsql-patches(at)postgreSQL(dot)org> |
Subject: | Re: [Win32] Problem with rename() |
Date: | 2006-06-16 20:05:21 |
Message-ID: | 200606162005.k5GK5LI28654@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
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" <Peter(dot)Brant(at)wicourts(dot)gov> 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. +
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Brant | 2006-06-16 20:45:37 | Re: [Win32] Problem with rename() |
Previous Message | Tom Lane | 2006-06-16 14:33:59 | Re: BUG #2481: select from table's join with geometries doesn't go |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2006-06-16 20:08:57 | Re: table/index fillfactor control, try 2 |
Previous Message | Tom Lane | 2006-06-16 18:50:48 | Re: TupleDesc refcounting |