| From: | "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org> |
|---|---|
| To: | "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org> |
| Cc: | Jan Wieck <janwieck(at)yahoo(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: more about pg_toast growth |
| Date: | 2002-04-08 18:03:09 |
| Message-ID: | 1018288989.9032.10.camel@heat |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2002-03-15 at 10:35, Jeffrey W. Baker wrote:
> On Fri, 2002-03-15 at 06:47, Jan Wieck wrote:
>
> > > I have increased the free space map and will be able to restart the
> > > postmaster today at around midnight GMT.
> >
> > Any news?
>
> I couldn't work it in to the last maintenance window. I'll give it
> another run tonight.
I increased the FSM and restarted postgres several weeks ago, and the
toast tables continue to just grow and grow. I set it to:
max_fsm_relations = 1000 # min 10, fsm is free space map
max_fsm_pages = 100000 # min 1000, fsm is free space map
Now, my table with only 107490 rows takes 20GB on disk. I dumped and
reloaded the database and got 18.5GB free space back.
I really think this is a bug in the implementation.
-jwb
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-04-08 18:08:49 | Re: Seq. scan when using comparison operators, why? |
| Previous Message | Janine Sisk | 2002-04-08 18:02:10 | Re: Tcl_CreateSlave error (pg 7.1.2, RH 7.2) |