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

varying pagesize in postgresql

From: gayatri ganpaa <gayatri_ganpaa(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: varying pagesize in postgresql
Date: 2005-06-21 06:09:36
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
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?


Yahoo! Sports
 Rekindle the Rivalries. Sign up for Fantasy Football


pgsql-admin by date

Next:From: Grega BremecDate: 2005-06-21 10:13:44
Subject: Re: No Space Left On Device
Previous:From: Scott MarloweDate: 2005-06-20 16:03:49
Subject: Re: Temporary Tables

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