Skip site navigation (1) Skip section navigation (2)

Re: [Win32] Problem with rename()

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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. +

In response to

Responses

pgsql-bugs by date

Next:From: Peter BrantDate: 2006-06-16 20:45:37
Subject: Re: [Win32] Problem with rename()
Previous:From: Tom LaneDate: 2006-06-16 14:33:59
Subject: Re: BUG #2481: select from table's join with geometries doesn't go

pgsql-patches by date

Next:From: Simon RiggsDate: 2006-06-16 20:08:57
Subject: Re: table/index fillfactor control, try 2
Previous:From: Tom LaneDate: 2006-06-16 18:50:48
Subject: Re: TupleDesc refcounting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group