On Mon, Jan 18, 2010 at 12:43 PM, Vick Khera wrote:
> On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson wrote:
>> Does this max_fsm_pages value seem OK for a 46GB database?
>> I've clustered all the tables that seemed to be exhibiting large amounts
>> of bloat.
>
> My big DB is about 70 on disk. I
On Mon, Jan 18, 2010 at 02:43:11PM -0500, Vick Khera wrote:
> On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson wrote:
> > Does this max_fsm_pages value seem OK for a 46GB database?
> > I've clustered all the tables that seemed to be exhibiting large amounts
> > of bloat.
>
>
> One more thing you m
On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson wrote:
> Does this max_fsm_pages value seem OK for a 46GB database?
> I've clustered all the tables that seemed to be exhibiting large amounts
> of bloat.
My big DB is about 70 on disk. I have fsm pages set to 3.4 million,
and occasionally that gets
Does this max_fsm_pages value seem OK for a 46GB database?
I've clustered all the tables that seemed to be exhibiting large amounts
of bloat.
reporting=# SELECT pg_size_pretty(pg_database_size('reporting'));
pg_size_pretty
46 GB
(1 row)
NOTICE: number of page slots needed