| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com>, 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 20:10:01 |
| Message-ID: | 1215807001.4051.1632.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)broersma(at)gmail(dot)com> wrote:
> > 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 );
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberts, Jon | 2008-07-11 20:10:37 | Re: Default fill factor for tables? |
| Previous Message | William Garrison | 2008-07-11 20:08:36 | How do I tell if a vacuum is currently running? |