Skip site navigation (1) Skip section navigation (2)

Re: fatal out of shared memory postgres

From: Rensi Arteaga Copari <rarteaga(at)ende(dot)bo>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: fatal out of shared memory postgres
Date: 2010-09-27 14:35:22
Message-ID: 4CA0ABAA.1060005@ende.bo (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
  gracias por la respuesta y  disculpame la tardanza


El 23/09/2010 15:33, Alvaro Herrera escribió:
> Excerpts from Rensi Arteaga Copari's message of vie sep 17 16:19:27 -0400 2010:
>
>> Unable to connect to PostgreSQL server:
>> FATAL: out of shared memory HINT: You may need to increase
>> max_locks_per_transacction, in
>> /opt/lampp/htdocs/endesis/cls_conexion.php on line 57
> ¿Y max_locks_per_transaction cuánto es?
ersta con su valor por defecto (en mi archivo se encuentra comentado)


#deadlock_timeout = 1000                # in milliseconds
*#max_locks_per_transaction = 64         # min 10*
# note: each lock table slot uses ~220 bytes of shared memory, and there are
# max_locks_per_transaction * (max_connections + max_prepared_transactions)
# lock table slots.


> ¿Por qué subiste tanto temp_buffers y work_mem?
Como el servidor es grande y exclusivo para postgres buscamos aprovechar 
el hardware,
en algún manual de tunning de postgres  leímos que podíamos ir subiendo 
estos valores
> ¿Tienes muchas particiones?
*tengo estas particiones*

[root(at)polea ~]# fdisk -l

Disk /dev/sda: 292.3 GB, 292326211584 bytes
255 heads, 63 sectors/track, 35539 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

    Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14       35539   285362595   8e  Linux LVM

*y sobre LVM*


[root(at)polea ~]# lvdisplay -a
   /dev/hda: open failed: No medium found
   --- Logical volume ---
   LV Name                /dev/VolGroup00/LogVol00
   VG Name                VolGroup00
   LV UUID                3SMdWA-Ar6i-XBuk-IGbg-6Taw-D5tq-mFTz8n
   LV Write Access        read/write
   LV Status              available
   # open                 1
   LV Size                68.34 GB
   Current LE             2187
   Segments               1
   Allocation             inherit
   Read ahead sectors     auto
   - currently set to     256
   Block device           253:0

   --- Logical volume ---
   LV Name                /dev/VolGroup00/LogVol02
   VG Name                VolGroup00
   LV UUID                xLZokd-TV0X-7QjV-3Syv-ugU8-30Zh-BsTVmE
   LV Write Access        read/write
   LV Status              available
   # open                 1
   LV Size                200.88 GB
   Current LE             6428
   Segments               1
   Allocation             inherit
   Read ahead sectors     auto
   - currently set to     256
   Block device           253:1

   --- Logical volume ---
   LV Name                /dev/VolGroup00/LogVol01
   VG Name                VolGroup00
   LV UUID                5tsBn0-7vyy-MykD-9PGu-LqR6-Woq7-yUFCTf
   LV Write Access        read/write
   LV Status              available
   # open                 1
   LV Size                2.91 GB
   Current LE             93
   Segments               1
   Allocation             inherit
   Read ahead sectors     auto
   - currently set to     256
   Block device           253:2










-- 
EMPRESA NACIONAL DE ELECTRICIDAD
www.ende.bo
Tel.: (591-4) 4520317 - 4120900
Fax: (591-4) 4520318
---------------------------------------------------------------------------------
Este mensaje ha sido analizado automaticamente por el MailScanner de ENDE
y no han sido detectados virus ni otros contenidos peligrosos.

In response to

Responses

pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2010-09-27 15:19:14
Subject: Re: fatal out of shared memory postgres
Previous:From: p valdesDate: 2010-09-26 17:27:44
Subject: Re: [pgsql-es-ayuda] Búsqueda de palabras con Acent?==?ISO-8859-1?Q?os

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group