¿Cuanta memoría necesita postgres?

From: Pablo Braulio <brulics(at)gmail(dot)com>
To: postgres <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: ¿Cuanta memoría necesita postgres?
Date: 2008-04-17 11:05:39
Message-ID: 48072F03.5040408@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hola a todos.

He tratado de hacer la instalación de postgresql 7.4, en un servidor
virtual con debian y me ha dado un error de memoria.

Configurando postgresql-7.4 (7.4.19-0etch1) ...
Creating new cluster (configuration: /etc/postgresql/7.4/main, data:
/var/lib/postgresql/7.4/main)...
TopMemoryContext: 32768 total in 3 blocks; 12912 free (11 chunks); 19856
used
TopTransactionContext: 8192 total in 1 blocks; 7896 free (0 chunks); 296
used
DeferredTriggerXact: 0 total in 0 blocks; 0 free (0 chunks); 0 used
PortalMemory: 0 total in 0 blocks; 0 free (0 chunks); 0 used
CacheMemoryContext: 253952 total in 5 blocks; 10304 free (13 chunks);
243648 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 6928 free (0 chunks); 1264 used
DynaHashTable: 8192 total in 1 blocks; 6112 free (0 chunks); 2080 used
DynaHashTable: 8192 total in 1 blocks; 4048 free (0 chunks); 4144 used
DynaHashTable: 8192 total in 1 blocks; 4560 free (0 chunks); 3632 used
DynaHashTable: 8192 total in 1 blocks; 976 free (0 chunks); 7216 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
ERROR: memoria agotada
DETALLE: Falla en petición de tamaño 269.

He instalado la versión 7.4 pues es la que actualmente hay en los
repositorios de debian etch.

La máquina no tiene mucha memoria que se diga, pero me extraña que le
problema sea la falta de memoria, pues otras veces lo he instalado en
máquina con poca memoria y sin problemas.

# cat /proc/meminfo
MemTotal: 196608 kB
MemFree: 30776 kB
Buffers: 0 kB
Cached: 0 kB
SwapCached: 0 kB
Active: 0 kB
Inactive: 0 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 196608 kB
LowFree: 30776 kB
SwapTotal: 0 kB
SwapFree: 0 kB
Dirty: 0 kB
Writeback: 0 kB
AnonPages: 0 kB
Mapped: 0 kB
Slab: 0 kB
PageTables: 0 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 0 kB
Committed_AS: 0 kB
VmallocTotal: 0 kB
VmallocUsed: 0 kB
VmallocChunk: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
Hugepagesize: 2048 kB

- --

< ¡¡Nos vemos!! >
----------------------------
\
\
.::!!!!!!!:.
.!!!!!:. .:!!!!!!!!!!!!
~~~~!!!!!!. .:!!!!!!!!!UWWW$$$
:$$NWX!!: .:!!!!!!XUWW$$$$$$$$$P
$$$$$##WX!: .<!!!!UW$$$$" $$$$$$$$#
$$$$$ $$$UX :!!UW$$$$$$$$$ 4$$$$$*
^$$$B $$$$\ $$$$$$$$$$$$ d$$R"
"*$bd$$$$ '*$$$$$$$$$$$o+#"
"""" """""""
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIBy8DK7lGsMchFswRAlT6AKC3eRcC4+dm0N6T16u+AgCa2HRUqQCgkqay
SQMGUOLoYK9Ix+709ZeJvJI=
=qsUL
-----END PGP SIGNATURE-----

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Moises Alberto Lindo Gutarra 2008-04-17 11:50:25 Re: OT: Dudas sobre OLAP en Postgres + Windows XP
Previous Message Gabriel Hermes Colina Zambra 2008-04-17 10:51:46 Re: respaldo programado