Re: beta1 & beta2 & Windows & heavy load - Mailing list pgsql-hackers

From Daniel Schuchardt
Subject Re: beta1 & beta2 & Windows & heavy load
Date
Msg-id ci6c25$1tu8$1@news.hub.org
Whole thread Raw
In response to Re: beta1 & beta2 & Windows & heavy load  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane schrieb:
> 
> Had you been running the server for very long before forcing the error,
> I don't think this would have happened, because the buffer hashtable
> would have already expanded to its full working size.

Yes, you are right - this was a fresh started pgserver.

> 
> Once we fix subxacts to not hold their XID locks after
> subcommit, the probability of a problem should go back down to the same
> low value that's allowed us to ignore this risk for the past many years.
> 

I think so, too.


Daniel


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: libpq and prepared statements progress for 8.0
Next
From: Marc Colosimo
Date:
Subject: tweaking MemSet() performance - 7.4.5