Re: Slow Foreign Key

Both indexed...

But... When I try EXPLAIN SELECT * FROM detail WHERE master_id = XXXXXX;
PostgreSQL uses seq scan (why?)

It's very confusing.

Em Seg, 2004-03-22 às 18:34, Sam Barnett-Cormack escreveu:
> On Mon, 22 Mar 2004, Tom Lane wrote:
>
> > Ricardo Vaz Mannrich <rvm_l1@silcom.com.br> writes:
> > > Is FOREIGN KEY so slow like that?
> >
> > Not normally.  Have you checked that the referencing and referenced
> > columns are of the same datatype?  Have you done ANALYZE on both tables
> > recently?
>
> Other question that seems, from my experience, to be relevant - are the
> referenced/referencing columns indexed?
--
Ricardo Vaz Mannrich <rvm_l1@silcom.com.br>