On Thu, Apr 17, 2008 at 11:24 AM, kevin kempter
> Hi List;
> I have a large tble (playback_device) with 6million rows in it. The
> aff_id_tmp1 table has 600,000 rows.
> - why am I still getting a seq scan ?
You're selecting almost all the rows in the product of aff_id_tmp1 *
playback_fragment. A sequential scan will be far faster than an index
scan. You can prove this to yourself using 'set enable_seqscan to
false' and running the query again. It should be much slower.
In response to
pgsql-performance by date
|Next:||From: Rodrigo Gonzalez||Date: 2008-04-17 18:31:10|
|Subject: Re: seq scan issue...|
|Previous:||From: kevin kempter||Date: 2008-04-17 18:24:26|
|Subject: seq scan issue...|