Postgres Pro
Downloads
Home   >   mailing lists

Thread: Where to get more info. about the optimizer?

Where to get more info. about the optimizer?

From
"Dhruv Matani"
Date:
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.

Query Optimization

From
shakil tanvir
Date:
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.

Re: Query Optimization

From
Andreas Kretschmer
Date:
shakil tanvir <tanvirshakil@yahoo.com> schrieb:

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

You can use "\timing" to switch timing on/off, and you can use explain
and explain analyse.

09:33 < akretschmer|home> ??explain
09:33 < rtfm_please> For information about explain
09:33 < rtfm_please> see http://techdocs.postgresql.org/oscon2005/robert.treat/OSCON_Explaining_Explain_Public.sxi
09:33 < rtfm_please> or http://www.postgresql.org/docs/current/static/sql-explain.html

Btw.: please no HTML, and please don't hijacking other threads.


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°