[ADMIN] Temporary Tables

2005-06-20 Thread Anjan Dave
Hi,   A developer is trying to use a Temporary Table via the java based application. The problem is following the temp table creation, he wants subsequent queries to query the temp table, but they are not in the same database session as the temp table. Is this something I can setup somewh

Re: [ADMIN] Temporary Tables

2005-06-20 Thread Scott Marlowe
On Mon, 2005-06-20 at 10:20, Anjan Dave wrote: > Hi, > > > > A developer is trying to use a Temporary Table via the java based > application. The problem is following the temp table creation, he > wants subsequent queries to query the temp table, but they are not in > the same database session

[ADMIN] varying pagesize in postgresql

2005-06-20 Thread gayatri ganpaa
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