PDA

View Full Version : ERROR 53200 - Out of Memory when vakuuming or purging



wettongl
05-15-2009, 08:32 AM
Hi,

this Problem occurs when vakuuming my DB after 1second and says


CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: analyzing "public.pokersites"INFO: "pokersites": scanned 1 of 1 pages, containing 16 live rows and 0 dead rows; 16 rows in sample, 16 estimated total rowsINFO: vacuuming "public.handhistories"
ERROR: out of memory
DETAIL: Failed on request of size 536870910.

ERROR: out of memory
DETAIL: Failed on request of size 536870910.

When purging its the same thing. But when I purgen only about 10 days, it work ... but what can I do about vakuum/analyse-problem?


My System:
Windows Vista Home Premium x64
newest PostgreSQL (installed 1 week ago)
running pgadmin and HM as admin
8GB RAM
at least 20 GB HDD-Space on the windows drive
and 18 GB left on the SSD, where der Database is running on.

And my Momery-Config in postgres.conf looks like this


# - Memory -

shared_buffers = 1024MB # min 128kB or max_connections*16kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 5 # can be 0 or more
# (change requires restart)
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
work_mem = 256MB # min 64kB
maintenance_work_mem = 1024MB # min 1MB
#max_stack_depth = 2MB # min 100kB


I have tried restarting my System so that more % of my RAM would be empty - no use ... 1 second and theres the error again.

Do you have any idea what this could be?

morny
05-15-2009, 03:54 PM
Escalated to Roy, hell respond asap

Rvg72
05-15-2009, 08:42 PM
Is this all being done through pgadmin?

If it is being done through HM then make sure you have 1.08.03

Roy

wettongl
05-16-2009, 07:12 AM
Hi Roy,

thanks you for your answer - but my DB crashed totally yesterday. The DB wouldn't load anymore (even when using the the backup I made of the "postgres.conf"). So I deinstalled postgres and HM, formatted the SSD and now I am giving it a new try. I hope its not an issue with my system or the SSD - but it could be, since it's all new Hardware.

I will give you an update on this, in ~ 30 hours.

PS: When formatting a 64GB HDD for Postgres-use only. What cluster-size would you advise? 512 bytes - 64 kilobytes are possible - i chose something in between....

PPS: Importing at 110h/s right now ;)



EDIT: And yes - I was using 1.08.03 and running the vakuum via pgadmin

wettongl
05-17-2009, 02:46 PM
well - the reinstall did work.

I imported about 7 Mio Hands on two Limits (for stats), purged them again and now I am vakuuming without problems ... it must have been something with the postgres-install or the DB - now everything runs smoothly.

:)


Keey up that outstanding job, Roy!