Re: again on index usage (7.1.3)

From: Daniel Kalchev <daniel(at)digsys(dot)bg>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: again on index usage (7.1.3)
Date: 2002-02-12 16:50:43
Message-ID: 200202121650.SAA01238@dcave.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>Stephan Szabo said:
> Do you have a single value that is much more common than the rest (say
> approximately 170000 of the rows?) 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-02-12 17:08:18 Re: alter table drop column status
Previous Message Stephan Szabo 2002-02-12 16:40:02 Re: again on index usage (7.1.3)