Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E9260476F15 for ; Mon, 6 Jan 2003 13:03:54 -0500 (EST) Received: from seapdc01.PNTS (ip63.c216.blk1.bel.nwlink.com [209.20.216.63]) by postgresql.org (Postfix) with ESMTP id 5981B476E7E for ; Mon, 6 Jan 2003 13:03:52 -0500 (EST) Received: from busbydev (BUSBY-DEV [10.0.0.64]) by seapdc01.PNTS with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id ZYR7GPDV; Mon, 6 Jan 2003 10:11:22 -0800 Message-ID: <009d01c2b5ad$8b5d4370$4000000a@busbydev> Reply-To: "David Busby" From: "David Busby" To: "Gerard Samuel" , References: <3E18CF80.6070007@trini0.org> Subject: Re: Database File system requirements. Date: Mon, 6 Jan 2003 10:00:47 -0800 Organization: Pacific Northwest Ticket Services MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/18 X-Sequence-Number: 1763 Also look at the vacuum command, that makes PG clean up itself, you've got to run it though. http://www.postgresql.org/idocs/index.php?sql-vacuum.html ----- Original Message ----- From: "Gerard Samuel" To: Sent: Sunday, January 05, 2003 16:36 Subject: [PHP] Database File system requirements. > Im not sure if this is the right list, but here goes. > I have a dev box, that I allocated, 104M of space to share between, > mysql & pgsql. > In mysql, I have 376 tables across 11 databases which is taking up only > 1.3M. > In pgsql, I have 33 tables on 1 database, and that seems to be taking up > 74M. > > Does postgresql require soooo much disk space to operate?? > Thanks for any insight you may provide. > > -- > Gerard Samuel > http://www.trini0.org:81/ > http://dev.trini0.org:81/ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly