Re: [GENERAL] index bloat question

2011-10-17 Thread Szymon Guz
On 17 October 2011 15:42, Merlin Moncure wrote: > On Mon, Oct 17, 2011 at 2:15 AM, Szymon Guz wrote: > > > > > > On 17 October 2011 02:01, Scott Marlowe wrote: > >> > >> On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz wrote: > >> > Hi, > >> > just a couple of questions: > >> > will there be an ind

Re: [GENERAL] index bloat question

2011-10-17 Thread Merlin Moncure
On Mon, Oct 17, 2011 at 2:15 AM, Szymon Guz wrote: > > > On 17 October 2011 02:01, Scott Marlowe wrote: >> >> On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz 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

Re: [GENERAL] index bloat question

2011-10-17 Thread Szymon Guz
On 17 October 2011 02:01, Scott Marlowe wrote: > On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz 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? > >

Re: [GENERAL] index bloat question

2011-10-16 Thread Rob Sargent
Scott Marlowe wrote: On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz 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 inc

Re: [GENERAL] index bloat question

2011-10-16 Thread Scott Marlowe
On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz 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

[GENERAL] index bloat question

2011-10-16 Thread Szymon Guz
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