hi,
thx for the hint. i decreased work_mem. its working now.
the dump written in the logfile is:
TopMemoryContext: 40960 total in 5 blocks; 11064 free (37 chunks); 29896 used
TopTransactionContext: 8192 total in 1 blocks; 7856 free (0 chunks); 336 used
Remote Con hash: 8192 total in 1 blocks; 5
Hello,
i have a statement which ends with
ERROR: out of memory
DETAIL: Failed on request of size 639.
i tried it several times, the number after size changes but not the outcome.
could someone tell me what information you need to tell me whats wrong?
what i have so fare is:
PostgreSQL ver
Hi,
i have
- PostgreSQL 8.1.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 3.3.5 20050117 (prerelease) (SuSE Linux)
- 2 services running, one on port 5432 and another one on port 5431.
vacuum fails in every way i tried (psql, pgadmin, autovac, jdbc;
single table, whole database) but ana
