| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Darren King <DarrenK(at)Routescape(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Minor TODO list changes |
| Date: | 2004-11-04 18:31:53 |
| Message-ID: | 1099593113.4320.601.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 2004-11-04 at 17:59, Darren King wrote:
> In my data warehousing situation, I'd like to be able to specify that
> the indexes be as compact as possible (fillfactor = 100%) in order to
> hit as few index pages as necessary.
>
Yes, that's my intent.
> At some point it would also be nice to be able to mark tables as
> read-only and then any indexes created on that table after that would
> have a fillfactor of 100%. Then I'd be able to load the table, alter it
> to be read-only, then add the appropriate indexes that are automatically
> compacted.
>
Sounds cool. Good idea,
--
Best Regards, Simon Riggs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-11-04 18:34:39 | CVS should die (was: Possible make_oidjoins_check ...) |
| Previous Message | Rod Taylor | 2004-11-04 18:15:10 | Re: Minor TODO list changes |