Re: [BUGS] BUG #8034: pg_buffercache gets invalid memory alloc request size with very large shared memory buffers

2013-04-04 Thread Tom Lane
Mark Kirkwood writes: >> When a very large shared buffer pool (~480GB) is used with postgresql, >> pg_buffercache contrib module gets an allocation error trying to Allocate >> NBuffers worth of BufferCachePagesRec records: > Yes indeed - however I'm not sure this is likely to be encountered in >

Re: [BUGS] BUG #8034: pg_buffercache gets invalid memory alloc request size with very large shared memory buffers

2013-04-04 Thread Mark Kirkwood
On 03/04/13 08:44, dben...@whitepages.com wrote: The following bug has been logged on the website: Bug reference: 8034 Logged by: Devin Ben-Hur Email address: dben...@whitepages.com PostgreSQL version: 9.2.3 Operating system: Ubuntu Precise Description: When a very large sh

Re: [BUGS] pg_stat_statements doesn't work with --disable-spinlocks

2013-04-04 Thread Tom Lane
Heikki Linnakangas writes: > pg_stat_statements (re-)initializes spinlocks as part of normal > operation. With --disable-spinlock, spinlocks are implemented using > semaphores, and semaphores are expected to be created at postmaster > startup. Hence, you get an assertion failure: > postgres=#

[BUGS] pg_stat_statements doesn't work with --disable-spinlocks

2013-04-04 Thread Heikki Linnakangas
pg_stat_statements (re-)initializes spinlocks as part of normal operation. With --disable-spinlock, spinlocks are implemented using semaphores, and semaphores are expected to be created at postmaster startup. Hence, you get an assertion failure: postgres=# select * from pg_stat_statements ; Th

Re: [BUGS] BUG #8036: how to disable toasting

2013-04-04 Thread Kevin Grittner
This is not a bug report; please use the pgsql-general list for questions like this, or for any follow-up on this question. "zahid.qua...@cloverinfotech.com" wrote: > PostgreSQL version: 9.0.5 You need to update to 9.0.13 as soon as possible. http://www.postgresql.org/support/versioning/ http

Re: [BUGS] BUG #8036: how to disable toasting

2013-04-04 Thread Bruce Momjian
On Thu, Apr 4, 2013 at 11:12:54AM +, zahid.qua...@cloverinfotech.com wrote: > The following bug has been logged on the website: > > Bug reference: 8036 > Logged by: anonymous > Email address: zahid.qua...@cloverinfotech.com > PostgreSQL version: 9.0.5 > Operating system:

[BUGS] BUG #8036: how to disable toasting

2013-04-04 Thread zahid . quadri
The following bug has been logged on the website: Bug reference: 8036 Logged by: anonymous Email address: zahid.qua...@cloverinfotech.com PostgreSQL version: 9.0.5 Operating system: windows Description: how to disable toasting in postgresql 9.0 please guide -- Sen