Matt McClure wrote:
>
> You say that vacuum "re-writes" the database. Does it alter row oids???
^^^^^^^^^^^^^^^^^^^^^^
No.
> If so, my scheme completely corrupts my database whenever I do a vacuum,
> since in concert and song the row oids would change, but my inserted
> values would remain the same in concert_song, right?
>
> If vacuum does not alter row oids, then I have another question. How does
> postgres re-use oids? I've seen the numbers grow and grow, but despite
^^^^^^^^^^^^^^^^^^^^
It doesn't.
> deletes, etc, I have never seen a lower oid get re-used. How does this
> work?
Vadim