Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6E630475B8D for ; Sun, 5 Jan 2003 19:59:04 -0500 (EST) Received: from socrates.catalyst.net.nz (socrates.catalyst.net.nz [203.96.153.226]) by postgresql.org (Postfix) with ESMTP id 59EA2475B8C for ; Sun, 5 Jan 2003 19:59:02 -0500 (EST) Received: from kant.catalyst.net.nz (hume.catalyst.net.nz [203.96.153.228]) by socrates.catalyst.net.nz (8.12.3/8.12.3/Debian -4) with ESMTP id h060x4EP023234; Mon, 6 Jan 2003 13:59:04 +1300 Received: from 127.0.0.1 (ident=unknown) by kant.catalyst.net.nz with esmtp (masqmail 0.2.16) id 18VLbN-1Vs-00; Mon, 06 Jan 2003 13:58:49 +1300 Subject: Re: Database File system requirements. From: Andrew McMillan To: Gerard Samuel Cc: pgsql-php@postgresql.org In-Reply-To: <3E18CF80.6070007@trini0.org> References: <3E18CF80.6070007@trini0.org> Content-Type: text/plain Organization: Message-Id: <1041814728.6611.72.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 06 Jan 2003 13:58:49 +1300 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/13 X-Sequence-Number: 1758 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? 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. Cheers, Andrew. -- --------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Survey for nothing with http://survey.net.nz/ ---------------------------------------------------------------------