On Mon, 1 Apr 2002, Ricardo Vaz Mannrich wrote:
> I have a database with four tables (here named tab1, tab2, tab3 and
> hawb_extra).
>
> tab1 has 322556 rows,
> tab2 has 334394,
> tab3 has 2360079,
> and hawb_extra has 472906.
>
> hawb_extra is fulled by triggers on tab1, tab2 and tab2 using INSERTs and
> UPDATEs.
>
> I had an index on hawb_extra using data_col and locatual fields and when I
> tried to run a query using these fields, PG didn't used index scan. So, I
> dropped and tried to create again the index. See what I get. I tried a lot of
> times. Thanks for your help:
It'd probably be helpful to get a backtrace from the core this should have
produced in your database directory (if it didn't produce a core, you may
need to change your user limits to get one).