Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id F14CA2E0077 for ; Wed, 21 May 2008 16:08:36 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 97853-03 for ; Wed, 21 May 2008 16:08:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.231]) by developer.postgresql.org (Postfix) with ESMTP id 3B35A2E0046 for ; Wed, 21 May 2008 16:08:30 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 76so1607181wra.10 for ; Wed, 21 May 2008 12:08:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=Stk1fT0zc1FWZV6Gd1esNAae8o3MpNwXtkAy/UsUJg8=; b=UZcH7J8+jABsFDPo6soDpR6IJnid46e2bxhlZYvD1qtj27ua08Jo+AW7F+wyoxYEfsLdNBS0P5h1IoRLgrdfZJsf6vELUnXuYOMcDHUJH4Tess05T/xD44rzKkuu7o0/luRT7k3uGpzfA2EagSSroL52OmtAIbvmInDmfToXM0E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=F43E4j0jeCxv5zkN/YRUryuPlCfmPG1kpVQrMUWgJubGKUoB0YChi6oDPyOCC5IPdqrqSPfLjCc4QA3naYHT8SZTyAdqcTfzyB740JnPDND+xEi0k5lLIDoDMhSg32CIB5L/Bi4UonYMk5GrnWSkcfs1NVM7PsqK8cN9Fa6EgmY= Received: by 10.114.59.1 with SMTP id h1mr10928917waa.39.1211396909050; Wed, 21 May 2008 12:08:29 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Wed, 21 May 2008 12:08:29 -0700 (PDT) Message-ID: Date: Wed, 21 May 2008 13:08:29 -0600 From: "Scott Marlowe" To: "Duan Ligong" Subject: Re: [Admin]To estimate the size of db Cc: pgsql-admin@postgresql.org In-Reply-To: <004301c8b62b$b183e840$f623480a@nsl.ad.nec.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <004301c8b62b$b183e840$f623480a@nsl.ad.nec.co.jp> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/180 X-Sequence-Number: 29264 On Wed, May 14, 2008 at 7:33 PM, Duan Ligong wrote: > > Hi, all > > Is there a way to estimate the size of the space which a postgresql database > occupies? or the max size of db? > > I know there are a lot of factors, such as the frequency > of updating, data size, which affects the size of db and it seems difficult > to estimate it precisely. There's also the old fashioned way: sudo su - postgres cd $PGDATA # or wherever you point with -D on startup du -sh .