Path: db1.oztralis.com.au!CEAMAIL!svr1.postgresql.org!localhost!svr1.postgresql.org!svr4.postgresql.org!ns2.oztralis.com.au X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.64 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.64 (2004-01-11) on ns2.oztralis.com.au X-Spam-Abuse-To: abuse@oztralis.com.au X-Spam-Abuse-Info: When reporting abuse, please include all headers as this will help us track down the offender. X-Spam-Abuse-Policy: http://www.oztralis.com.au/terms.htm Sender: pgsql-benchmarks-owner@postgresql.org Precedence: bulk X-Mailing-List: pgsql-benchmarks X-Virus-Scanned: by amavisd-new at hub.org Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" X-Mailer: Internet Mail Service (5.5.2657.72) MIME-Version: 1.0 Date: Tue, 14 Sep 2004 15:40:05 -0300 Subject: [pgsql-benchmarks] Largest DATABASE To: "'pgsql-benchmarks@postgresql.org'" From: Jamil Message-ID: X-Original-To: pgsql-benchmarks-postgresql.org@localhost.postgresql.org Newsgroups: lists.postgresql.pgsql-benchmarks Bytes: 795 Lines: 23 Xref: db1.oztralis.com.au lists.postgresql.pgsql-benchmarks:10 Hello everyone, I would like to know witch was the largest database that you ever had to administrate. My database is about to 160GB and I=B4ve got some problems to backup it using the pg_dump command and I too have some problems to run vaccum. Do you know any other way to do this operations?=20 My hardware is a IBM F50 with 4 processors and 2GB RAM and 163GB of hard disks plus 16GB of disks to the AIX Operation System. My backup unit is a 20/40 DAT and if I do a pg_dump them compress it, I can put all the database in only one tape. > Best Regards, >=20 > Jamil Marques Figueira Junior=20 >=20 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org