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!