473,289 Members | 2,091 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

inlined sql functions in 7.4

Hi!

I found the very useful feature into 7.4 release
Release Notes 7.4:
Function-inlining for simple SQL functions
Simple SQL functions can now be inlined by including their SQL in the main query.
This improves performance by eliminating per-call overhead.
That means, simple SQL functions now behave like macros.


but, i can't find any docs about syntax :(

Could you point me in the right direction?

Thx in advance

Aleksey
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #1
3 1226
--- Aleksey Serba <as****@voltweb.com> wrote:
Hi!

I found the very useful feature into 7.4 release
Release Notes 7.4:
Function-inlining for simple SQL functions
Simple SQL functions can now be inlined by including their SQL in the main query.
This improves performance by eliminating

per-call overhead.
That means, simple SQL functions now behave

like macros.

but, i can't find any docs about syntax :(

Could you point me in the right direction?


This happens automatically, i.e. you don't need to do
anything. It is a performance optimization in the
backend.

Thx in advance

Aleksey
---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2
Aleksey Serba <as****@voltweb.com> writes:
I found the very useful feature into 7.4 release
Function-inlining for simple SQL functions

but, i can't find any docs about syntax :(


There isn't any --- it happens automatically if the planner thinks it's
an appropriate transformation.

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

Nov 23 '05 #3
I found the very useful feature into 7.4 release
Function-inlining for simple SQL functions

but, i can't find any docs about syntax :(


TL> There isn't any --- it happens automatically if the planner thinks it's
TL> an appropriate transformation.
TL> regards, tom lane

Ops. I was mistaken.
I'm sorry for wasting your time.

Aleksey
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Andy | last post by:
Someone supposedly knowledgeable tells me that any member function declared in class scope is automatically inlined. I am a little skeptical about this claim. Is this true (I know it cannot be ......
15
by: Steven T. Hatton | last post by:
I know this is, to some extent, implementation dependent, but since the Standard specifies an inline specifier, there must be some "reasonable assumptions" I can make about what should happen when...
2
by: Steve McLellan | last post by:
Hi, We've found some pretty serious performance hits that we didn't expect in a mixed mode C++ application. The number crunching bits of our algorithms are compiled with #pragma unmanaged. They...
5
by: Felix I. Wyss | last post by:
Good Afternoon, I recently noticed that some very simple methods of a template declared and used in a DLL library get inlined when used by the DLL itself, but not by other DLLs and EXEs. After...
4
by: sks | last post by:
All, I thought all template instantiations were inlined until I analyzed the following code. template<typename t> class Something { public: inline int getSomething() { return 1; }
2
by: Michael Nemtsev | last post by:
AFAIK, method could be candidate for inlining. But is it possible to view after compiling that method became inlined? Are there some keywords in ILDASM that can show that method is inlined? ---...
9
by: Bilgehan.Balban | last post by:
Hi, If I define an inline function in one .c file, and use it from another, after compiling and linking the two, it seems the function is not inlined but rather called as a regular function. I...
2
by: newbie | last post by:
I happened to read boost library code and realized that most (the part I read) functions are inlined like: template <class Key> inline void Foo(const Key& k) { ... ... } Is there a strong...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.