Re: Primary Key Increment Doesn't Seem Correct Under Table Partition

On 26 Jan 2010, at 11:00, Yan Cheng Cheok wrote:

> However, whenever I insert row into measurement table, I realize its primary key value is going from 2, 4, 6, 8,
10...
>
> May I know how can I prevent this?

Apparently nextval on that sequence gets called multiple times in your queries.

> Also, is it necessary to create index for measurement_id found in measurement's child table? I am concern on the read
speed.


Serials don't create indexes, only a sequence. Primary keys create indexes (to guarantee uniqueness) - foreign keys do
not.
So yes, you want an index on that column in the child table.

Alban Hertroys

--
Screwing up is the best way to attach something to the ceiling.


!DSPAM:737,4b5ec59910605107914066!