Skip site navigation (1) Skip section navigation (2)

Re: varying pagesize in postgresql

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: gayatri ganpaa <gayatri_ganpaa(at)yahoo(dot)com>,pgsql-admin(at)postgresql(dot)org
Subject: Re: varying pagesize in postgresql
Date: 2005-06-21 17:22:00
Message-ID: 20050621172200.GA19214@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-admin
[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 (<alvherre[a]surnet.cl>)
"God is real, unless declared as int"

In response to

Responses

pgsql-admin by date

Next:From: gayatri ganpaaDate: 2005-06-22 04:10:52
Subject: Re: varying pagesize in postgresql
Previous:From: Jim C. NasbyDate: 2005-06-21 16:58:44
Subject: Re: varying pagesize in postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group