Re: shared memory/max_locks_per_transaction error - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: shared memory/max_locks_per_transaction error
Date
Msg-id 20080317150005.GF4317@alvh.no-ip.org
Whole thread Raw
In response to Re: shared memory/max_locks_per_transaction error  ("Kynn Jones" <kynnjo@gmail.com>)
List pgsql-general
Kynn Jones escribió:

> I'm leaning towards the re-design option, primarily because I really don't
> really understand the consequences of cranking up max_locks_per_transaction.
>  E.g. Why is its default value 2^6, instead of, say, 2^15?

It's because it (partly) defines how much shared memory the server will
use.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: postgre vs MySQL
Next
From: AlannY
Date:
Subject: Get info about indexes