pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Select Query Performance
2+ messages / 2 participants
[nested] [flat]

* Select Query Performance
@ 2003-06-02 01:12  Ricky Prasla <praslar@hotmail.com>
  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:48  Rod Taylor <rbt@rbt.ca>
  parent: Ricky Prasla <praslar@hotmail.com>
  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