On Jun 27, 5:46 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> Linux isn't real friendly to putting shared libraries outside the
> standard directories. If you want to keep libxml2.so in its own directory
> you'll need to teach the dynamic linker to look there. See ldconfig.
What could be more friend
Tom,
I'm using 8.3.1. I did run EXPLAIN but have never familiarized myself
with how to read/use it beside simple comparing cost estimation and
whether there is any seq scan that can benefit from creating index.
Thanks for replying
On Jun 7, 11:19 am, [EMAIL PROTECTED] (Tom Lane) wrote:
&g
Hi all,
I have been using IN clause almost exclusively until recently I tried
to use EXISTS and gained significant performance increase without
changing/creating any indexes:
SELECT ... FROM a WHERE a.ref IN (SELECT b.id WHERE ...)
vs
SELECT ... FROM a WHERE EXISTS (SELECT 1 FROM b WHERE a.ref=
Hello everybody!
I'm having problem with postgresql 8.3 (not sure if it is related to
this particular version). Suppose we have accounting system database
with the following rule (no other rules are there):
create or replace rule update_or_create_balance as
on insert to ledger when exists (select
