indexes on varchar fields
От | Peter Nixon |
---|---|
Тема | indexes on varchar fields |
Дата | |
Msg-id | 20021108133700.708dec47.listuser@peternixon.net обсуждение исходный текст |
Ответы |
Re: indexes on varchar fields
|
Список | pgsql-general |
Hi guys I have a large database (actually a bunch of large databases) that a running as the backends of radius servers running voip accounting. The databases are getting quite large now and some queries are taking > 5min to return. Now I read somewhere that indexing varchar fields is not particularly worth it especially if you are only doing queries occasionally. I am doing 200-500 inserts per min but only a query run on this particular field when I want to compare my flat file logs against whats in the DB to see if they match for billing purposes. Can someone inform me as to whether an index on the following field: h323ConfID varchar(64) DEFAULT '' NOT NULL Which contains data resembling the following: 41A4DCE3 8CF2D611 85170004 75AE73D4 which is most likely unique, but not guaranteed so, is going to be worth it? -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
В списке pgsql-general по дате отправления: