Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 78BD32E011F for ; Wed, 13 Feb 2008 15:38:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82231-04 for ; Wed, 13 Feb 2008 15:37:59 -0400 (AST) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.190]) by postgresql.org (Postfix) with ESMTP id A49C52E0122 for ; Wed, 13 Feb 2008 15:38:01 -0400 (AST) Received: by fk-out-0910.google.com with SMTP id b27so138620fka.3 for ; Wed, 13 Feb 2008 11:38:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:in-reply-to:references:mime-version:content-type:message-id:cc:content-transfer-encoding:from:subject:date:to:x-mailer; bh=Xvcc3WgEBy9kyOhIaA6Fk5OqBbta3a5xgEbvFxNIGLA=; b=S3P2bmNAzcJu4gwwrFkKy8HJwAh0oceS9aerbsVfrvbZ+Xs+qYbDGvNe0yAAfDirsZuL8sqush6ja2+1i9xHnb1hKnVMAVGIr7iW9LCS6QD59ztVJefJ/VwaQ4Yj+llnOWRoe5PTTLuWosgkSM+yItuV/2FC/TWAPAetZNT5f+4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=in-reply-to:references:mime-version:content-type:message-id:cc:content-transfer-encoding:from:subject:date:to:x-mailer; b=LsT3XD6adTXdfsb3AmXL9wI8XPrEjjXHE5Wtt5rBUHxucIY51e2tDlKH9Ycjc/4Um0MTiUojqin+fhCYFDsyc9KC2ThpcxsANV/q100j98TZY2mfXiDmZDKPXlDxZCOU3YHSczvj6wf1USevPKd3xqyQAo7EBgC2qH1cvmJkA4c= Received: by 10.82.158.12 with SMTP id g12mr608704bue.18.1202931479996; Wed, 13 Feb 2008 11:37:59 -0800 (PST) Received: from ?192.168.0.24? ( [83.14.243.146]) by mx.google.com with ESMTPS id c28sm3784403fka.0.2008.02.13.11.37.58 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 13 Feb 2008 11:37:59 -0800 (PST) In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v753) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: paul socha Subject: Re: How much space do database objects take up in data files Date: Wed, 13 Feb 2008 20:37:55 +0100 To: Peter Kovacs X-Mailer: Apple Mail (2.753) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/159 X-Sequence-Number: 28233 Hi Im not sure ;] but ... http://www.postgresql.org/docs/8.3/static/functions-admin.html and table 9-54 merlin=# select tablename, pg_size_pretty(pg_relation_size (tablename)) from pg_catalog.pg_tables where tableowner='merlin';; tablename | pg_size_pretty -----------+---------------- foo | 8192 bytes ip | 8192 bytes (2 rows) On 2008-02-13, at 19:43, Peter Kovacs wrote: > Hi, > > How can I find out how much space is taken up by database objects > in data files? > > Thanks > Peter Pawel Socha pawel.socha@gmail.com perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`- { a%%s%%$_%ee'