Re: Requirements for a database server - Mailing list pgsql-admin

From Tom Lane
Subject Re: Requirements for a database server
Date
Msg-id 26203.996210450@sss.pgh.pa.us
Whole thread Raw
In response to Re: Requirements for a database server  (Robert.Farrugia@go.com.mt)
List pgsql-admin
Robert.Farrugia@go.com.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

pgsql-admin by date:

Previous
From: "Selvam"
Date:
Subject: Problem starting postgresql
Next
From: "Nicola Cisternino"
Date:
Subject: Full Case INSENSITIVE ...