Re: Requirements for a database server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert(dot)Farrugia(at)go(dot)com(dot)mt
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Requirements for a database server
Date: 2001-07-27 05:07:30
Message-ID: 26203.996210450@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Robert(dot)Farrugia(at)go(dot)com(dot)mt writes:
> I'm trying to vacuum the tables, but the pg_xlog is gettting very big
> (filling up the harddrive). As an estimate, how much space do you need to
> vacuum a 30GB table (data + indexes) ?

Not a lot, if you apply the previously posted patch to truncate the xlog
a little more enthusiastically. I'm too tired to look up the URL yet
again, but it's in the patches archives from mid-June or so.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nicola Cisternino 2001-07-27 11:31:56 Full Case INSENSITIVE ...
Previous Message Roy Souther 2001-07-26 22:54:04 psql error: file to large!