pull down to refresh

60 sats \ 6 replies \ @k00b 23h \ parent \ on: Spoiler Alert: Stacker News Will Hit +1.5 Million Items in 2025 oracle
It's more complicated than just unpaid items or deletions. Rollbacks after inserts also leave "holes" in sequences.
Because smallserial, serial and bigserial are implemented using sequences, there may be "holes" or gaps in the sequence of values which appears in the column, even if no rows are ever deleted. A value allocated from the sequence is still "used up" even if a row containing that value is never successfully inserted into the table column. This may happen, for example, if the inserting transaction rolls back.
Afaik the best we can say about sequences is that they're monotonically increasing (if NO CYCLE is used (which is the default)).
The id is not the item count. It's a rough overestimate of the item count.
write
preview
40 sats \ 5 replies \ @0xbitcoiner 22h
You could just make a temporary buffer (new table) until the item paid.
reply
40 sats \ 4 replies \ @k00b 22h
100% not worth it.
reply
40 sats \ 3 replies \ @0xbitcoiner 22h
I bet that's a pain in the ass. Any way to know the real number of paid items right now?
reply
30 sats \ 2 replies \ @k00b 22h
SQL's count.
reply
0 sats \ 1 reply \ @0xbitcoiner 21h
No doubt you can do it. I was just asking the pleb stacker!
reply
20 sats \ 0 replies \ @SimpleStacker 20h
Write a script to check each item number
reply on another page