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?
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?