Re: Default fill factor for tables?
От
Richard Broersma
Тема
Re: Default fill factor for tables?
Дата
Msg-id
396486430807111112s1d6f5e74ueb664d6b272079f8@mail.gmail.com
Ответ на
Re: Default fill factor for tables? (Scott Marlowe)
Список
Дерево обсуждения
Default fill factor for tables? "Francisco Reyes" <lists@stringsutils.com>
Re: Default fill factor for tables? Tom Lane <tgl@sss.pgh.pa.us>
Re: Default fill factor for tables? "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Default fill factor for tables? "Richard Broersma" <richard.broersma@gmail.com>
Re: Default fill factor for tables? "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Default fill factor for tables? Simon Riggs <simon@2ndquadrant.com>
Re: Default fill factor for tables? "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Default fill factor for tables? Simon Riggs <simon@2ndquadrant.com>
Re: Default fill factor for tables? "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Default fill factor for tables? Simon Riggs <simon@2ndquadrant.com>
Re: Default fill factor for tables? "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Default fill factor for tables? "Roberts, Jon" <Jon.Roberts@asurion.com>
Re: Default fill factor for tables? Alvaro Herrera <alvherre@commandprompt.com>
Re: Default fill factor for tables? "Roberts, Jon" <Jon.Roberts@asurion.com>
Re: Default fill factor for tables? "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Default fill factor for tables? "Roberts, Jon" <Jon.Roberts@asurion.com>
Re: Default fill factor for tables? Chris <dmagick@gmail.com>
On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe 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
В списке pgsql-general по дате отправления
