Am 26.04.2011 08:05, schrieb Milos Wimmer: > On Tue, 26 Apr 2011, Pascal Gienger wrote: > > Hello Pascal, > >> What's the size/value of >> >> shared_buffers = ... >> and >> max_locks_per_transaction = ... >> >> in your postgresql.conf? > > > shared_buffers = 24MB [default value] > max_locks_per_transaction = 256 [default value = 64] > > > thank, > Milos > Hallo Milos,
you should increase the kernels maximum size of shared memory segment. To do this. edit your /etc/sysctl.conf. For example: kernel.shmmax = 134217728 (sets the value to 128 MB). You can also find a explanation in http://www.postgresql.org/docs/8.4/interactive/kernel-resources.html cu Sven -- [email protected] https://inverse.ca/sogo/lists
