DANTE ALEXANDRA <[EMAIL PROTECTED]> 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 workspa
Hi,
you need to increase maintenance_work_mem in postgresql.conf file.
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
Regards
Pandu
On 12/12/05, DANTE ALEXANDRA <[EMAIL PROTECTED]> wrote:
> Hello,
>
> This is my first posting in this mailing list and I am a PostGreSQL newbie.
>
Hello,
This is my first posting in this mailing list and I am a PostGreSQL newbie.
I've posted this message in the "novice" mailing list last friday, but I
have any response.
I hope somenone could help me.
I realize a benchmarck on PostGreSQL on a 300Gb database. I used the
release 8.1.0.
I
