dbTalk Databases Forums  

Re: [BUGS] Is it bug???

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] Is it bug??? in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ringo
 
Posts: n/a

Default Re: [BUGS] Is it bug??? - 09-04-2003 , 12:47 PM






What a prick..

"Tom Lane" <tgl (AT) sss (DOT) pgh.pa.us> wrote

Quote:
Dinar <dinar (AT) yantel (DOT) ru> writes:
I thought that explain analyze doesn't execute query

You thought wrong. Is the manual's explanation not clear enough?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply With Quote
  #2  
Old   
Bruno Wolff III
 
Posts: n/a

Default Re: [BUGS] Is it bug??? - 09-05-2003 , 08:14 AM






On Wed, Sep 03, 2003 at 23:19:24 -0700,
Ringo <no (AT) email (DOT) com> wrote:
Quote:
What a prick..
From observing Tom's responses here, I think this is a real question (not
an RTFM response). If the documentation doesn't make it clear to new readers
that explain analyze does execute the query (though doesn't return the
results), then the documentation needs to get fixed.

Quote:
"Tom Lane" <tgl (AT) sss (DOT) pgh.pa.us> wrote in message
news:25792.1062510815 (AT) sss (DOT) pgh.pa.us...
Dinar <dinar (AT) yantel (DOT) ru> writes:
I thought that explain analyze doesn't execute query

You thought wrong. Is the manual's explanation not clear enough?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.