index bloat question

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: index bloat question
Date: 2011-10-16 20:41:44
Message-ID: CAFjNrYtpkA4YbdKo6eWR32bNzOOnY3uPoia_qe0QWNNY3GM_cA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2011-10-16 21:40:51 Re: 9.1 got really fast ;)
Previous Message Edson Richter 2011-10-16 13:59:59 Re: 9.1 got really fast ;)