From: | "Ricky Prasla" <praslar(at)hotmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Select Query Performance |
Date: | 2003-06-02 01:12:54 |
Message-ID: | Law8-F48x1DkIUoXd7J00041c6a@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
I am running Postgresql 7.2.3 on a linux Qube with 256 RAM. I have a tabe
with about 100,000 records. The table has a postgis geometry column. I have
a GIST index on the table on the geometry column. Here are my questions:
1)When I do a spatial select query on the geometry column in this table it
takes a few seconds. What more can I do in terms of the Postgresql
configuration or query tuning besides adding the GIST index?
Here's a sample query I make:
Select [column] from [table_name] where [spatial_column] && [the geometry
object];
2)Also, I execute this query over the web. If there are mltiple select
queries then I have to execute one get its reultset and then send the other
one. Is there a faster way to execute multiple select queries over the web?
Thanks in advance.
Riyaz
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2003-06-02 01:48:31 | Re: Select Query Performance |
Previous Message | Bruno Wolff III | 2003-06-01 19:04:09 | Re: Index speeds up one row table (why)? |