Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id ED5202E0052 for ; Thu, 15 May 2008 01:36:06 -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 64759-04-6 for ; Thu, 15 May 2008 01:35:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by developer.postgresql.org (Postfix) with ESMTP id 492DC2E00AB for ; Thu, 15 May 2008 01:27:49 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n4so317799wag.5 for ; Wed, 14 May 2008 21:27:48 -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=ebK0YqlIE/jBMmy/rsLap96t+GYUBpNPZvWgHA27akI=; b=uu7zEtpiCCeDAX9jmB/jqSEDw1it1qX8hDAbnhUDBin7Q/QQr34luqQvmHnNJ4gvzJH0k6cFBohEcq118o7Lo75SN9PBc2asvrOdhdySi9lTqk01g9Uwt3yIeTVW0iXrgX06ix7CO1XEU01VJFdHZZI2cLvvby7WLLgh8JyExy4= 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=j9xNvWMEbwaK7Bysb1d/BZzny3r97g/M6HEXLtkklfrCFA9HLuAlowVT5ZBtfeLR/jB1ksFgohVXedmJursG7gyE1c9lzBpSeClZcLm9u1iPB0HHhmDcm/AdZDiRQ49dsPebx7Mjgh0Cji4pWXnZIAWOVD1rB+RWCfhg/d7peI4= Received: by 10.114.59.1 with SMTP id h1mr2023625waa.39.1210825667127; Wed, 14 May 2008 21:27:47 -0700 (PDT) Received: by 10.114.67.1 with HTTP; Wed, 14 May 2008 21:27:47 -0700 (PDT) Message-ID: Date: Wed, 14 May 2008 23:27:47 -0500 From: "Jaime Casanova" 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: quoted-printable Content-Disposition: inline References: <004301c8b62b$b183e840$f623480a@nsl.ad.nec.co.jp> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/133 X-Sequence-Number: 29217 On Wed, May 14, 2008 at 8:33 PM, Duan Ligong wr= ote: > > Hi, all > > Is there a way to estimate the size of the space which a postgresql datab= ase > occupies? or the max size of db? > if pg >=3D 8.1 then http://www.postgresql.org/docs/8.1/static/functions-admin.html#FUNCTION= S-ADMIN-DBSIZE else there is a contrib/dbsize end if --=20 Atentamente, Jaime Casanova Soporte y capacitaci=F3n de PostgreSQL Guayaquil - Ecuador Cel. (593) 087171157