X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D6FC5D6F4E for ; Wed, 24 Aug 2005 09:43:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40964-08 for ; Wed, 24 Aug 2005 12:43:32 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.198]) by svr1.postgresql.org (Postfix) with ESMTP id D7E37D6EC9 for ; Wed, 24 Aug 2005 09:43:30 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z6so53418nzd for ; Wed, 24 Aug 2005 05:43:35 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lZ++g+geHU2U7DYluS8Fvi37ItWzYedCSnMUQHoEbtYuA1R5ztofv/dVu8PtV+ZJT1S5eKAaB9RzOq4CSzGYGf2/sDwb3JJ5wGTJMcqa0vkW8S7py8zsv/izPXePkIii/IW1FZoUdADJI8mPWDQbVtft80t/58TJSJaQqPlBm6s= Received: by 10.36.129.15 with SMTP id b15mr19058nzd; Wed, 24 Aug 2005 05:43:35 -0700 (PDT) Received: by 10.36.138.5 with HTTP; Wed, 24 Aug 2005 05:43:35 -0700 (PDT) Message-ID: <69f2062a05082405432fd92c92@mail.gmail.com> Date: Wed, 24 Aug 2005 08:43:35 -0400 From: jose fuenmayor To: Aldor , pgsql-admin@postgresql.org Subject: Re: Fwd: Indexes (Disk space) In-Reply-To: <430B7B76.1030009@mediaroot.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <69f2062a0508221037690f8d2b@mail.gmail.com> <69f2062a0508231101463f25b7@mail.gmail.com> <430B7B76.1030009@mediaroot.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.723 required=5 tests=[AWL=0.183, FROM_ENDS_IN_NUMS=0.516, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/298 X-Sequence-Number: 18617 Ok I understand but I need to know the size of the index before i create it I need to know how much space it will ocupy (before actually create the index, having the information of the table on wich I will build the index), is this possible? thanks in advance to everyone that can help me. On 8/23/05, Aldor wrote: > select * from pg_class; >=20 > or >=20 > select relname, relpages from pg_class where relname =3D '[index-name]'; >=20 > the pages give you the information about the space the index uses, a > page has 8kb. >=20 > [...]Every table and index is stored as an array of pages of a fixed > size (usually 8Kb, although a different page size can be selected when > compiling the server). In a table, all the pages are logically > equivalent, so a particular item (row) can be stored in any page. In > indexes, the first page is generally reserved as a metapage holding > control information, and there may be different types of pages within > the index, depending on the index access method. [...] >=20 > Source-URL: > http://www.postgresql.org/docs/8.0/interactive/storage-page-layout.html >=20 > jose fuenmayor wrote: > > ---------- Forwarded message ---------- > > From: jose fuenmayor > > Date: Aug 22, 2005 1:37 PM > > Subject: Indexes (Disk space) > > To: pgsql-admin@postgresql.org > > > > > > Hi all, > > I have the following question. > > Is there anyway for me to know how much space on disk will ocupy an > > index, created in a determined row or rows of a table?, anything like > > a rule, formula, calculation? that allow me to know in advance how > > much space will the index use before actually created it. > > > > I aprecciate all the help you can give me > > > > Thanks in advance. > > > > ---------------------------(end of broadcast)--------------------------= - > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that you= r > > message can get through to the mailing list cleanly > > >