pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSelect Query Performance
2+ messages / 2 participants
[nested] [flat]
* Select Query Performance
@ 2003-06-02 01:12 Ricky Prasla <praslar@hotmail.com>
2003-06-02 01:48 ` Re: Select Query Performance Rod Taylor <rbt@rbt.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Ricky Prasla @ 2003-06-02 01:12 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Select Query Performance
2003-06-02 01:12 Select Query Performance Ricky Prasla <praslar@hotmail.com>
@ 2003-06-02 01:48 ` Rod Taylor <rbt@rbt.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Rod Taylor @ 2003-06-02 01:48 UTC (permalink / raw)
To: Ricky Prasla <praslar@hotmail.com>; +Cc: pgsql-performance
> 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?
Going with the assumption the result-set is not used to generate further
queries, you might look into the use of Asynchronous connections.
It'll enable you to easily establish several connections to the database
for parallel work to be done.
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=libpq-connect.html
Even PHP will let you use the Asynchronous query mechanism within
PostgreSQL.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-06-02 01:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-06-02 01:12 Select Query Performance Ricky Prasla <praslar@hotmail.com>
2003-06-02 01:48 ` Rod Taylor <rbt@rbt.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox