Scott Marlowe wrote:
On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz <mabewlun@xxxxxxxxx> wrote:
Hi,
just a couple of questions:
will there be an index bloat if I have:
- a serial column and only add rows to the table?
- a text column and I only add rows to the table?
For the serial column the numbers are only incremented, for the text column
I add random strings.
With no deletes or updates, the only bloat will be from a non 100% fill factor.
Is there no index rebalancing overhead on monotonically increasing keys
compare to (decently) random. Seems one would continuously write to the
"right-most" sub-leaf node.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
