Search Postgresql Archives

Re: PostGreSQL 8.1.0 : out of memory during vacuum full analyze

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



DANTE ALEXANDRA <ALEXANDRA.DANTE@xxxxxxxx> writes:
> Then, on each table, I have launched the "VACUUM FULL ANALYZE" command 
> as a non-root user.
> This command failed on the last table, the biggest, called "lineitem" 
> which contains 1799989091 rows (near 300 Gb of datas).

VACUUM FULL requires workspace proportional to the number of blocks in
the table.  You probably need to bump up the kernel's per-process memory
limit (see ulimit and so on) if you want to VACUUM FULL such a large table.

My advice: you shouldn't be using VACUUM FULL anyway.  Quite aside from
the memory issue, it's likely to take forever and a day.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux