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(at)silcom(dot)com(dot)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(at)silcom(dot)com(dot)br>
In response to
pgsql-admin by date
|Next:||From: Mike Bell||Date: 2004-03-23 13:47:52|
|Subject: Cache loolup failed problems with tsearch following pg_restore|
|Previous:||From: CoL||Date: 2004-03-23 11:06:42|
|Subject: Re: Databases Vs. Schemas|