On Apr 22, 2013, at 1:29 AM, Josh Berkus 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
> --
> J
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 (pgsql-p
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, the
On Sun, Apr 21, 2013 at 6:46 AM, sunil virmani 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 all db vacuu
On Sun, Apr 21, 2013 at 5:46 AM, sunil virmani wrote:
> My DB version is little old - 8.1.18.
>
Your db is exceptionally old and very much unsupported. Vacuum has
massively improved since 8.1 .
See http://www.postgresql.org/support/versioning/ regarding supported
versions.
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 all db vacuuming finish in 30 secs.
but once in a day or two
- My actual DB is
