[DOCS] directly construct a query plan
Hello everyone, I plan to directly construct a query plan without going through the query optimizer, by manipulating the various data structures for representing query plan tree and parse tree. Is there any facility inside/outside postgresql that can be of help? Is there any known issue/difficulty related to this? Thanks! Steve _ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] directly construct a query plan
"Chengkai Li" <[EMAIL PROTECTED]> writes: > I plan to directly construct a query plan without going through the query > optimizer, by manipulating the various data structures for representing > query plan tree and parse tree. Is there any facility inside/outside > postgresql that can be of help? Is there any known issue/difficulty related > to this? Only that your code *will* break in each future release, because we have no hesitation about whacking those data structures around ... regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] Message Error
Secure Mail System Beta Test. +++ Attachment: No Virus found +++ MessageLabs AntiVirus - www.messagelabs.com ** ** WARNING: WinProxy has detected a virus in file attached to this e-mail message! The attachment has been automatically removed to protect your network. WinProxy Administrator: [EMAIL PROTECTED] 10/04/04 12:40:26 WinProxy (Version 5.1 R1b (5.0.50.4)) - http://www.Ositis.com/ Antivirus Vendor: Panda Software Scan Engine Version: 4.7.0.2_4.1.6.408 Pattern File Version: 3.84613 (Timestamp: 2004/10/04 11:59:17) Machine name: DOPEY Machine IP address: 68.124.106.89 Server: 200.46.204.209 Client: 192.168.1.10 Protocol: SMTP Virus: "W32/Netsky.P.worm" found! Attachment: message.zip ** ** ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] directly construct a query plan
Hi Tom, Thanks! So if I want to try out some new join algorithm, or even new type of plan nodes, before I feel the algorithms/nodes are so good that I want to enable the optimizer to consider them as options, is there any better way to experiment with possible new plans? regards, Steve > I plan to directly construct a query plan without going through the query > optimizer, by manipulating the various data structures for representing > query plan tree and parse tree. Is there any facility inside/outside > postgresql that can be of help? Is there any known issue/difficulty related > to this? Only that your code *will* break in each future release, because we have no hesitation about whacking those data structures around ... regards, tom lane _ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
