Query Optimization - Mailing list pgsql-novice

From shakil tanvir
Subject Query Optimization
Date
Msg-id 20060521065619.9666.qmail@web52403.mail.yahoo.com
Whole thread Raw
In response to Where to get more info. about the optimizer?  ("Dhruv Matani" <dhruvbird@gmail.com>)
Responses Re: Query Optimization
List pgsql-novice
Hi Guys,

Can anyone tell me, how i can see at psql that how fast my query is executing?

Shakil

Dhruv Matani <dhruvbird@gmail.com> wrote:
Hello,
  I have downloaded the PgSql sources, and saw the README file in the optimizer directory of the sources. Is there any other resource(s) for getting more info. on this?
More specifically, I'm interested in knowing if the optimizer uses the Referential Integrity constraints while performing optimizations. I mean things such as the FOREIGN key, CHECK constraints, etc....


--
   -Dhruv Matani.
http://www.geocities.com/dhruvbird/

"The biggest room is the room for improvement."
     -- Navjot Singh Siddhu.


Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

pgsql-novice by date:

Previous
From: kmh496
Date:
Subject: Re: PG on zeta 1.0
Next
From: Andreas Kretschmer
Date:
Subject: Re: Query Optimization