Re: [PERFORM]

2013-04-21 Thread Scott Marlowe
On Sun, Apr 21, 2013 at 6:46 AM, sunil virmani sun...@gmail.com wrote: Hi, My databases are updated regularly so I am vacuuming frequently (every one hour). Recently i also added template1 database to avoid over wrapping problem. But somehow i am seeing strange behavior. Most of the time

Re: [PERFORM]

2013-04-21 Thread Scott Marlowe
I was gonna tell you to turn off full page writes, but in 8.1 that setting is ignored. For reference, here's the pages that you should look at for this: http://www.postgresql.org/docs/8.1/static/runtime-config-wal.html http://www.postgresql.org/docs/8.1/static/wal-configuration.html For 9.1,

[PERFORM] Issues with OSX and SHMMAX?

2013-04-21 Thread Josh Berkus
Folks, I've heard a rumor that the most recent update of OSX mountain lion lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from installing. Can anyone verify this? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com. -- Sent via pgsql-performance mailing list

Re: [PERFORM] Issues with OSX and SHMMAX?

2013-04-21 Thread Evgeny Shishkin
On Apr 22, 2013, at 1:29 AM, Josh Berkus j...@agliodbs.com wrote: Folks, I've heard a rumor that the most recent update of OSX mountain lion lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from installing. Can anyone verify this? kern.sysv.shmmax: 4194304 mac os x 10.8.3