Re: again on index usage (7.1.3)

Поиск
Список
Период
Сортировка
От Daniel Kalchev
Тема Re: again on index usage (7.1.3)
Дата
Msg-id 200202121650.SAA01238@dcave.digsys.bg
обсуждение исходный текст
Ответ на again on index usage (7.1.3)  (Daniel Kalchev <daniel@digsys.bg>)
Ответы Re: again on index usage (7.1.3)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
>>>Stephan Szabo said:> Do you have a single value that is much more common than the rest (say> approximately 170000 of
therows?)  It's estimating almost 18000 matching> rows, but I'm guessing that that's not a reasonable estimate.
 

Not likely. There are no more than 30-40 attributes per user (this is another 
story, but I discuss there the PostgreSQL aspect, not RADIUS :). Entries with 
most rows have up to 35 rows.

However, there is indeed an user_name entry with 179225 values! Somehow on 
these rows user_name is ''.

Time to change my standard answer...

Daniel



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu
Следующее
От: Daniel Kalchev
Дата:
Сообщение: Re: again on index usage (7.1.3)