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: 20050621060936.80324.qmail@web51504.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,
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?
 
Thanks,
gayatri.

__________________________________________________


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

Responses

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-2014 The PostgreSQL Global Development Group