X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4E866D1B442 for ; Wed, 26 Nov 2003 04:38:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84401-10 for ; Wed, 26 Nov 2003 00:37:54 -0400 (AST) Received: from web10804.mail.yahoo.com (web10804.mail.yahoo.com [216.136.130.246]) by svr1.postgresql.org (Postfix) with SMTP id E108FD1B479 for ; Wed, 26 Nov 2003 00:37:53 -0400 (AST) Message-ID: <20031126043752.51857.qmail@web10804.mail.yahoo.com> Received: from [129.128.48.83] by web10804.mail.yahoo.com via HTTP; Tue, 25 Nov 2003 20:37:52 PST Date: Tue, 25 Nov 2003 20:37:52 -0800 (PST) From: Grzegorz Dostatni Subject: Re: Size on Disk To: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/438 X-Sequence-Number: 11425 Thank you for your very quick response Chester. I guess I should clarify something. Knoppix is a version of linux that runs entirely in memory. I need as smallest footprint as possible. Currently the datase is roughly 80 Megs. About half of the size is stored in pg_xlog directory. I managed to figure out that those files are transaction log files? How can I delete them safely? (after creatation the database will pretty much be read-only - any changes will be in memory only). Are there any other tricks I can use to get the size down? Please keep in mind that I work with a fairly new database - I'm always recreating it from a dump so only the initial inserts are in there, no changes or deletions. Vacuuming helps a bit, but nowhere near as much as I would hope. Greg Greg __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/