From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | scrappy(at)hub(dot)org (The Hermit Hacker) |
Cc: | stuporg(at)erols(dot)com, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] What I'm working on |
Date: | 1998-08-24 03:13:52 |
Message-ID: | 199808240313.XAA16492@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> On Sun, 23 Aug 1998, Bruce Momjian wrote:
>
> > Yes, I guess you could have both. I just think the normal user is going
> > to prefer the span stuff better, but you have a good point. If we had
> > one, we could buy time getting the other.
>
> For whomever is implementing the row-span stuff, can something be
> added that keeps track of number of rows that are spanned? ie. if most of
> the rows are spanning the rows, then I would personally like to know that
> so that I can look at dumping and reloading the data with a database set
> to a higher blocksize...
>
> There *has* to be some overhead, performance wise, in the database
> having to keep track of row-spanning, and being able to reduce that, IMHO,
> is what I see being able to change the blocksize as doing...
Makes sense, though vacuum would presumably make all the blocks
contigious.
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-08-24 03:18:00 | RE: [HACKERS] What I'm working on |
Previous Message | Stupor Genius | 1998-08-24 03:01:08 | RE: [HACKERS] What I'm working on |