Skip site navigation (1) Skip section navigation (2)

Re: table size growing out of control

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gregory Wood" <gregw(at)com-stock(dot)com>
Cc: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: table size growing out of control
Date: 2002-07-16 18:13:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
"Gregory Wood" <gregw(at)com-stock(dot)com> writes:
>> If your overall database is large then you might need to increase the
>> size of the free space map (see postgresql.conf).

> I haven't seen any good documentation on what exactly this does, how the
> settings affect performance, or recommended values.

> Does this information exist anywhere?

Nope.  Feel free to run some experiments and create some recommendations

			regards, tom lane

In response to

pgsql-general by date

Next:From: Andrew SullivanDate: 2002-07-16 18:39:17
Subject: Re: PostgreSQL in mission-critical system
Previous:From: Christoph DalitzDate: 2002-07-16 18:11:35

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group