An earlier post referenced a bunch of Oracle performance pages. One of
them,
http://www.ixora.com.au/notes/direct_io.htm
indicates that on Linux 2.4 kernels one can use Direct I/O (if you DB
supports it).
Does Postgresql support the use of Direct I/O or Raw I/O? Base on
another page
http://ww
I created a function with iscachable,
' LANGUAGE 'plpgsql' WITH (iscachable);
I then call the function.
Then I decide to change the return type of the function so I first drop
the
function, then change the return type.
The next time I attempt to execute the function I get:
ERROR: plpgsql: cac
I'm I correct in understanding that the correct way to delete a
LargeObject from within
a PL/psql procedure is to call:
lo_unlink(oid);
Are there any other issues?
Thanks.
Richard
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comma
Premise:
There exists a mapping of any legal PL/pgsql procedure into the
equivilent C code.
Question:
Has anyone every written a PL/pgsql-2-C transformer?
Issues:
One would really like to map the optimized PL/pgsql into C, not just the
unoptimized,
as coded, PL/pgsql.
Optimization depends upon
