SPI vs low level functions. - Mailing list pgsql-general

From Tzahi Fadida
Subject SPI vs low level functions.
Date
Msg-id 009d01c51ba9$6252e570$0b00a8c0@llord
Whole thread Raw
List pgsql-general
Hi,
I am trying to determine if there is a difference in
I/O cost between SPI functions and low level functions
like heap_fetch, heap_getnext, etc...
I want to decide if there is any merit for using the low
level functions instead of the easier SPI.
My guess is that they both use the same underlying framework
for reading and caching blocks but I can't be sure.

Also, is there any significant CPU cost between them?
10x.


Regards,
    tzahi.

WARNING TO SPAMMERS:  see at
http://members.lycos.co.uk/my2nis/spamwarning.html



pgsql-general by date:

Previous
From: elein@varlena.com (elein)
Date:
Subject: Re: basic trigger using OLD not working?
Next
From: Rick Apichairuk
Date:
Subject: Re: Newbie: help with FUNCTION