Mailing List Archive

member table sequence gaps
Hello,

We are experiencing gaps between the id's in the member table. The id's are not always sequential. Sometimes the gaps are small, like 3 or 4. Sometimes there are no gaps. Other times we have found large gaps.

In our PostgreSQL sequence setup for that table, it is set to increment by 1. I believe NEXTVAL is used in the Bric pm files, so we are confused about why there would be gaps.

Is anyone else experiencing this?

Thank you,
Mike
Re: member table sequence gaps [ In reply to ]
On Jul 26, 2010, at 2:35 PM, Fletcher, Michael wrote:

> Hello,
>
> We are experiencing gaps between the id's in the member table. The id's are not always sequential. Sometimes the gaps are small, like 3 or 4. Sometimes there are no gaps. Other times we have found large gaps.
>
> In our PostgreSQL sequence setup for that table, it is set to increment by 1. I believe NEXTVAL is used in the Bric pm files, so we are confused about why there would be gaps.
>
> Is anyone else experiencing this?

There might be code to delete member records when an object is removed from a group. Or an ID might be fetched and then the transaction rolled back, which means the ID doesn't get used at all. I wouldn't worry about it.

Best,

David