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

Re: shared_buffers vs. -B flag: 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein(at)varlena(dot)com (elein)
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: shared_buffers vs. -B flag: 7.4
Date: 2005-01-23 20:46:36
Message-ID: 6399.1106513196@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
elein(at)varlena(dot)com (elein) writes:
> Hmmm. This was reproduced at a customer site by
> a very meticulous dba.  I'll check back with him.  

It would be worth enquiring exactly what values he was testing.
IIRC, 7.4 doesn't have any defense against setting NBuffers so large
as to make the shmem segment size calculation overflow.
This would of course lead to crashes at runtime, but I think the
postmaster startup would complete ...

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Kim HansenDate: 2005-01-24 00:41:10
Subject: BUG #1437: converting column from text to int4 requires USING
Previous:From: eleinDate: 2005-01-23 20:28:08
Subject: Re: shared_buffers vs. -B flag: 7.4

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