Problems with memory - Mailing list pgsql-general

From Pau Marc Munoz Torres
Subject Problems with memory
Date
Msg-id 19b5841a0805070419s7bb2c0br37c32b4874caecd0@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi

 I'm setting up a big database , and when i say big, i mean BIG, the problem with this is that some times, when a do a query the database run out of memory, so I really need to increase the amount of memory reserved to postgress almost 10x, could anyone tell me how can i do that? i mean, what configuration file and variables do i have to modify?

Thanks

pau

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc.munoz@bioinf.uab.cat

pgsql-general by date:

Previous
From: Michael Enke
Date:
Subject: pg_dumpall: pg_conversion table not saved
Next
From: "John Smith"
Date:
Subject: Backup/Restore of single table in multi TB database