Hello,This is probably a common problem, but I couldn't
really find a direct answer in the archives (or maybe just couldn't find
one that satisfied me ;-). I created an index specifically to help a query
and the optimizer does not use it. It prefers an older index
Greetings,It seems that stored procedures that
use SETOF are slower than regular sqlcommands. Why does it
happens?Please check out the following example.bxs=# \d
cham_chamadaTable "public.cham_chamada"Column | Type |
Modifiers---+--
Hi, I has a problem with a production database Postgres 7.1.2.
Happens when finished free space disk.
Some important tables were empty with no reason.
I tried to find respectives files for tables with psql command
:
select relfilenode from pg_classwher