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 2E05AD70EC for ; Tue, 23 Aug 2005 16:39:49 -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 62267-01 for ; Tue, 23 Aug 2005 19:39:46 +0000 (GMT) Received: from 217-20-115-93.internetserviceteam.com (217-20-115-93.internetserviceteam.com [217.20.115.93]) by svr1.postgresql.org (Postfix) with ESMTP id 3AF2CD6FEF for ; Tue, 23 Aug 2005 16:39:45 -0300 (ADT) Received: from [192.168.1.120] (93.Red-83-40-76.pooles.rima-tde.net [83.40.76.93]) by 217-20-115-93.internetserviceteam.com (Postfix) with ESMTP id 5379938D8B; Tue, 23 Aug 2005 20:50:03 +0200 (CEST) Message-ID: <430B7B76.1030009@mediaroot.de> Date: Tue, 23 Aug 2005 20:39:34 +0100 From: Aldor User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: jose fuenmayor Cc: pgsql-admin@postgresql.org Subject: Re: Fwd: Indexes (Disk space) References: <69f2062a0508221037690f8d2b@mail.gmail.com> <69f2062a0508231101463f25b7@mail.gmail.com> In-Reply-To: <69f2062a0508231101463f25b7@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/290 X-Sequence-Number: 18609 select * from pg_class; or select relname, relpages from pg_class where relname = '[index-name]'; the pages give you the information about the space the index uses, a page has 8kb. [...]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. [...] Source-URL: http://www.postgresql.org/docs/8.0/interactive/storage-page-layout.html 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 your > message can get through to the mailing list cleanly >