Re: Another seq scan instead of index question

On Tue, 07 Aug 2001, Nicholas Piper wrote:

Replying to myself with some more information.

> On Tue, 07 Aug 2001, Tom Lane wrote:

> > select attname,attdispersion,s.*
> > from pg_statistic s, pg_attribute a, pg_class c
> > where starelid = c.oid and attrelid = c.oid and staattnum = attnum
> > and relname = 'cdsongs';

> That doesn't look good to me as it contains dodgy bytes...

I've removed (hopefully) the nasty entries in my tables by deleting
where string is > 'zzzzzz'.

The new table which Tom said would be useful is ;

 attname | attdispersion | starelid | staattnum | staop | stanullfrac | stacommonfrac | stacommonval  | staloval |
  stahival           

---------+---------------+----------+-----------+-------+-------------+---------------+---------------+----------+---------------------------
 songid  |            -1 | 61094022 |         1 |    97 |           0 |   2.38796e-07 | 1             | 1        |
4210874
 cdid    |   4.68083e-06 | 61094022 |         2 |    97 |           0 |    2.3402e-05 | 677           | 1        |
364477
 track   |     0.0231398 | 61094022 |         3 |    97 |           0 |     0.0860681 | 0             | 0        | 97
 song    |   0.000651592 | 61094022 |         4 |  1066 |           0 |    0.00321658 |               |          | zzo,
Moderatocon Allegro 
 extt    |      0.890565 | 61094022 |         5 |   664 |    0.937465 |   2.98494e-05 | The Residents |          | zur
Ruhgebracht 

Unfortunately I'm still getting the same results:

depos=# explain select * from cdsongs where lower(song) like  'mushroom festival in hell';
NOTICE:  QUERY PLAN:

Seq Scan on cdsongs  (cost=0.00..103835.24 rows=41877 width=40)

EXPLAIN
depos=# set enable_seqscan = off;
SET VARIABLE
depos=# explain select * from cdsongs where lower(song) like  'mushroom festival in hell';
NOTICE:  QUERY PLAN:

Index Scan using idx_cdsongs_song on cdsongs  (cost=0.00..114921.91 rows=41877 width=40)

EXPLAIN


--
Part 3 MEng Cybernetics; Reading, UK       http://www.nickpiper.co.uk/
Change PGP actions of mailer or fetch key see website   1024D/3ED8B27F
Choose life. Be Vegan :-) Please reduce needless cruelty + suffering !