Re: Default fill factor for tables?
От | Simon Riggs |
---|---|
Тема | Re: Default fill factor for tables? |
Дата | |
Msg-id | 1215807001.4051.1632.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Re: Default fill factor for tables? ("Scott Marlowe" <scott.marlowe@gmail.com>) |
Ответы |
Re: Default fill factor for tables?
|
Список | pgsql-general |
On Fri, 2008-07-11 at 12:52 -0600, Scott Marlowe wrote: > On Fri, Jul 11, 2008 at 12:12 PM, Richard Broersma > <richard.broersma@gmail.com> wrote: > > On Fri, Jul 11, 2008 at 10:27 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote: > > > >> Is there any way to set a different default fill factor? > > > > ALTER TABLE Yourtable > > SET ( FILLFACTOR = 50 ); > > Hehe. I know how to do that. I mean the default fill factor for a > database / user for tables / indexes.. Like setting search_path for a > user. I think the reasoning was/is that setting it away from the default is only sensible in certain table-specific cases, so such a setting would more likely result in a general drop in performance. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support
В списке pgsql-general по дате отправления: