X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9BCE652828 for ; Tue, 21 Jun 2005 14:22:08 -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 59770-05 for ; Tue, 21 Jun 2005 17:22:03 +0000 (GMT) Received: from mr1.surnet.cl (smtp1.surnet.cl [216.155.73.162]) by svr1.postgresql.org (Postfix) with ESMTP id 7BA25528C3 for ; Tue, 21 Jun 2005 14:22:01 -0300 (ADT) Received: from smtp1.surnet.cl (216.155.73.168) by mr1.surnet.cl (7.0.031.3) id 42587EDE00F94FD6; Tue, 21 Jun 2005 13:21:25 -0400 Received: from smtp1.surnet.cl (mr1.surnet.cl []) by mr1.surnet.cl ([216.155.73.168]); Tue, 21 Jun 2005 17:21:25 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp1.surnet.cl (7.0.031.3) id 42587C6E00C6E1F5; Tue, 21 Jun 2005 13:21:25 -0400 Received: from localhost (216.155.78.203) by cluster.surnet.cl (7.0.043) id 42B3EF6000065E51; Tue, 21 Jun 2005 13:21:57 -0400 Received: by localhost (Postfix, from userid 1000) id 1072CC9D800; Tue, 21 Jun 2005 13:22:00 -0400 (CLT) Date: Tue, 21 Jun 2005 13:22:00 -0400 From: Alvaro Herrera To: "Jim C. Nasby" Cc: gayatri ganpaa , pgsql-admin@postgresql.org Subject: Re: varying pagesize in postgresql Message-ID: <20050621172200.GA19214@surnet.cl> References: <20050621060936.80324.qmail@web51504.mail.yahoo.com> <20050621165844.GB528@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050621165844.GB528@decibel.org> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.544 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200506/161 X-Sequence-Number: 17916 [reformatted for sanity] > On Mon, Jun 20, 2005 at 11:09:36PM -0700, gayatri ganpaa wrote: > > How do I change the page size in postgresql? I have the postgresql-7.4.3 version. > > I am trying to create an r*-tree index on a spatial table with > > around 100,000 rows. I just want to check if increasing the page > > size would make the join of two tables faster. Are there any other > > options I could use to make this faster? Would increasing the page > > size help? On Tue, Jun 21, 2005 at 11:58:44AM -0500, Jim C. Nasby wrote: > pg_dumpall > Change something in one of the header files (which is docummented > somewhere...) BLCKSZ, in src/include/pg_config_manual.h. I doubt it would make the index faster anyway ... I think you could post the query, schema, and EXPLAIN ANALYZE to pgsql-performance so that people can give you further advice. Going forward, rtree is somewhat obsolete -- maybe try setting up a GiST index instead (not sure if it would be faster than rtree.) -- Alvaro Herrera () "God is real, unless declared as int"