SPI vs low level functions.

From: Tzahi Fadida <tzahi_ml(at)myrealbox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SPI vs low level functions.
Date: 2005-02-26 02:17:46
Message-ID: 009d01c51ba9$6252e570$0b00a8c0@llord
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Rick Apichairuk 2005-02-26 02:24:13 Re: Newbie: help with FUNCTION
Previous Message elein 2005-02-26 02:08:57 Re: basic trigger using OLD not working?