bigserial vs serial - which one I'd have to use?
От | Medve Gabor |
---|---|
Тема | bigserial vs serial - which one I'd have to use? |
Дата | |
Msg-id | 1043616281.829.38.camel@maci обсуждение исходный текст |
Ответы |
Re: bigserial vs serial - which one I'd have to use?
Re: bigserial vs serial - which one I'd have to use? |
Список | pgsql-performance |
Hi all, Have you got any data (ie in percentage) of around how much more CPU work needed with the bigserial type in the queries? I have a log database with 100million records (the biggest table contains 65million records) and I use bigserial data type as primary key now. The primary key looks this way: YYYYMMDD1xxxxxxx where the first 8 numbers are the date, and the x's are the record sequence number on that day. This way the records are in ascendant order. Almost all of the queries contains date constraints (PK like 'YYYYMMDD%'). I'd like to know if I do it in a stupid way or not. I'm not a DBA expert so every idea are welcome. If you need more information about the hardware/software environment, the DB structure then I'll post them. Thanks in advance for your help. Gabor
В списке pgsql-performance по дате отправления: