""Ahmad Fajar"" <[EMAIL PROTECTED]> wrote
> Select ids, keywords from dict where keywords='blabla' ('blabla' is a 
> single
> word);
> The table have 200 million rows, I have index the keywords field. On the
> first time my query seem to slow to get the result, about 15-60 sec to get
> the result. But if I repeat the query I will get fast result. My question 
> is
> why on the first time the query seem very slow.
> Table structure is quite simple:
> Ids bigint, keywords varchar(150), weight varchar(1), dpos int.

The first slowness is obviously caused by disk IOs. The second time is 
faster because all data pages it requires are already in buffer pool. 200 
million rows is not a problem for btree index, even if your client tool 
appends some spaces to your keywords at your insertion time, the ideal btree 
is 5 to 6 layers high at most. Can you show the iostats of index from your 
statistics view? 


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to