PDA

View Full Version : postgres problem: vacuum analyse/memory exceded at



horsetranquilizer
11-23-2009, 07:07 AM
Hi there,

i use postgres 8.4 on a windows 7 system w lots of free HD space and memory space available.

database is 2 month old, first vacuum analyse worked fine.

now i tried to do it again /via postgresadmin/ and it didnt work.



FEHLER: Speicher aufgebraucht
DETAIL: Fehler bei Anfrage mit Größe 268435452.

FEHLER: Speicher aufgebraucht
DETAIL: Fehler bei Anfrage mit Größe 268435452.


memory exceeded

hopefully someone can help me here
greets horse



PS: i set higher values in order to increase db performance in postgresql.conf for:

"shared_buffers = xMB"

"work_mem = xMB"

"maintenance_work_mem = xMB"

horsetranquilizer
11-23-2009, 07:08 AM
sorry, this may be the wrong forum

Patvs
11-23-2009, 10:08 PM
You still have this problem when you reset

"shared_buffers = xMB"

"work_mem = xMB"

and
"maintenance_work_mem = xMB"


to its original values??