Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 788794765D7 for ; Sun, 5 Jan 2003 22:49:03 -0500 (EST) Received: from hivemind.trini0.org (bgp626680bgs.brick201.nj.comcast.net [68.39.132.244]) by postgresql.org (Postfix) with SMTP id 308B5475B8D for ; Sun, 5 Jan 2003 22:48:58 -0500 (EST) Received: (qmail 990 invoked by uid 0); 6 Jan 2003 03:49:02 -0000 Received: from unknown (HELO trini0.org) (192.168.0.5) by 192.168.0.2 with SMTP; 6 Jan 2003 03:49:02 -0000 Message-ID: <3E18FCBD.3000700@trini0.org> Date: Sun, 05 Jan 2003 22:49:17 -0500 From: Gerard Samuel User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.1) Gecko/20021213 X-Accept-Language: en, en-us, nl, th MIME-Version: 1.0 To: Andrew McMillan Cc: pgsql-php@postgresql.org Subject: Re: Database File system requirements. References: <3E18CF80.6070007@trini0.org> <1041814728.6611.72.camel@kant.mcmillan.net.nz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/15 X-Sequence-Number: 1760 Andrew McMillan wrote: >On Mon, 2003-01-06 at 13:36, Gerard Samuel wrote: > > >>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. >> >> > >Surely we'd need to know how many _rows_ there are in those tables? Also >how many indexes and index rows? > True. But not sure how to gather all that info for right now. To get a more accurate picture, I dropped the one database that is in Postgre, stopped and restarted Postgre. It seems to be using just over 62M. I recreated the database and file usage remains unchanged (looking via df -H), the database isn't really that large maybe about 1000 rows of data currently. > >I believe that PostgreSQL does have greater overhead on disk than MySQL, >however. Just to have the database started will mean that you have a >number of write-ahead logs (typically 16MB each - on my laptop these >take up 114M) which are used internally by the database server for >transaction handling - MySQL doesn't need these, of course. > Well if its normal for PostgreSQL to need more disk space, looks like Im going to have to do a couple of disk to disk copying soon, and repartion my HD. Thanks > >Cheers, > Andrew. > > -- Gerard Samuel http://www.trini0.org:81/ http://dev.trini0.org:81/