Matching unique primary keys
От | Kevin Old |
---|---|
Тема | Matching unique primary keys |
Дата | |
Msg-id | 1035321163.4491.139.camel@oc обсуждение исходный текст |
Ответы |
Re: Matching unique primary keys
|
Список | pgsql-general |
Hello all, I have a table of data that is very large (502 columns) and whenever I query it, I only query on up to 4 columns and on average only 20 fields are returned. I've come up with a way to increase the speed of the queries. I could could put the 20 fields that are searched and returned into a separate table and then link them by a unique id. Sounds easy......but I'm stuck on something. I am dealing with about 1 million records per day. One option is to put a sequence on the tables, but dealing with so many records I'd have to use a BIGINT and with a ceiling of 9223372036854775807 it seems to me that numbers this large might slow down the query process. I realize it would take quite a while to get to this point, but would like other's opinions. Another option is that I have 3 fields that when combine, make each record unique. Is there some way I can combine these dynamically and then use "views" of them to reference my records and display them from the larger table. I realize this is very confusing, please get back with me if I should elaborate on something. Any help is appreciated. Thanks, Kevin
В списке pgsql-general по дате отправления: