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.

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.

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/oscon...ain_Public.sxi
09:33 < rtfm_please> or http://www.postgresql.org/docs/curre...l-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°

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly