Home > mailing lists

index bloat question - Mailing list pgsql-general

From	Szymon Guz
Subject	index bloat question
Date	October 16, 2011 20:41:51
Msg-id	CAFjNrYtpkA4YbdKo6eWR32bNzOOnY3uPoia_qe0QWNNY3GM_cA@mail.gmail.com Whole thread Raw
Responses	Re: index bloat question (Scott Marlowe <scott.marlowe@gmail.com>)
List	pgsql-general

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.

regards

Szymon

From: "Schoen Matthew-MSCHOEN1"
Date: 16 October 2011, 16:12:15
Subject: Files being created under data/pg_xlog during failover testing

From: Filip Rembiałkowski
Date: 16 October 2011, 21:41:19
Subject: Re: 9.1 got really fast ;)