[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"
