| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Suvarna <suvarnat(at)cygnus(dot)stpp(dot)soft(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: bug in 7.3.2 |
| Date: | 2006-03-01 19:59:59 |
| Message-ID: | 20060301195959.GA82390@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 01, 2006 at 10:17:04AM +0530, Suvarna wrote:
> actually the number which are missing are in the range of 20-30 and at the
> max only 3 transactions are going on at any given point in time.
> So if 3 numbers are missing then it was understood the missing numbers are
> very large.
The number of transactions is irrelevant. If a single transaction
obtains 20 values from a sequence and that transaction is rolled
back, then those 20 sequence values are gone. Think of a sequence
as a generator of arbitrary unique numbers, not as a way to get
numbers guaranteed to have no gaps.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-03-01 20:13:15 | Re: [SQL] Interval subtracting |
| Previous Message | Hannu Krosing | 2006-03-01 19:59:58 | Re: Automatic free space map filling |