| From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, lists(at)stringsutils(dot)com, "Pgsql General list" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Default fill factor for tables? |
| Date: | 2008-07-11 18:12:01 |
| Message-ID: | 396486430807111112s1d6f5e74ueb664d6b272079f8@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> Is there any way to set a different default fill factor?
ALTER TABLE Yourtable
SET ( FILLFACTOR = 50 );
It take a bit of back tracking on the storage_parameter section:
http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html <-
see storage_parameter
http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html <-
see storage_parameter
http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
<- see FILLFACTOR
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hoover, Jeffrey | 2008-07-11 18:50:57 | Re: Complicated GROUP BY |
| Previous Message | Scott Marlowe | 2008-07-11 17:27:51 | Re: Default fill factor for tables? |