I just ran a vacuum verbose on the entire DB and this came out.
number of page slots needed (274144) exceeds max_fsm_pages (153600)
Hence, I've changed the max to 400,000 (pulled it straight out of the
air). How does one calculate what's the number needed anyway?
Another question is, based on w
Ow Mun Heng <[EMAIL PROTECTED]> writes:
> OK.. Vacuum verbose took 2 hours.. Vacuum full will likely take 2x that
> I presume.
Probably a lot more, and it'll bloat your indexes while it's at it.
Do you have a *reason* to run a vacuum full?
I'd suggest using contrib/pgstattuple to get a fix on how
On Thu, 2007-11-01 at 20:56 -0400, Bill Moran wrote:
> Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> >
> > I just ran a vacuum verbose on the entire DB and this came out.
> >
> > number of page slots needed (274144) exceeds max_fsm_pages (153600)
> >
> > Hence, I've changed the max to 400,000 (pulle
Ow Mun Heng <[EMAIL PROTECTED]> wrote:
>
> I just ran a vacuum verbose on the entire DB and this came out.
>
> number of page slots needed (274144) exceeds max_fsm_pages (153600)
>
> Hence, I've changed the max to 400,000 (pulled it straight out of the
> air). How does one calculate what's the n
On Thu, 2007-11-01 at 21:22 -0400, Tom Lane wrote:
> Ow Mun Heng <[EMAIL PROTECTED]> writes:
> > OK.. Vacuum verbose took 2 hours.. Vacuum full will likely take 2x that
> > I presume.
>
> Probably a lot more, and it'll bloat your indexes while it's at it.
> Do you have a *reason* to run a vacuum
2007/11/2, Ow Mun Heng <[EMAIL PROTECTED]>:
> pgstattuple.. Okay.. anyone have a centos rpm for it? Don't really have
> access to a compiler on the (server) machine.
don't you have postgresql-contrib package for centos?
--
Filip RembiaĆkowski
---(end of broadcast)--
In response to Vivek Khera <[EMAIL PROTECTED]>:
>
> On Nov 1, 2007, at 8:51 PM, Ow Mun Heng wrote:
>
> > Another question is, based on what I've read in the archives (in my
> > laptop.. No-Inet conn @ work) Since I've overran my max_FSM, I'm
> > basically screwed and will have to do a vacuum ver
On Nov 1, 2007, at 8:51 PM, Ow Mun Heng wrote:
Another question is, based on what I've read in the archives (in my
laptop.. No-Inet conn @ work) Since I've overran my max_FSM, I'm
basically screwed and will have to do a vacuum verbose FULL on the
entire DB. Crap..
I've seen this repeated many
On Thu, 2007-11-08 at 12:02 -0500, Bill Moran wrote:
> Frequently, when people ask for help because they've exceed max_fsm*,
> it's because they're not paying attention to their systems, and therefore
> the problem has been occurring for a while before it got so bad that
> they couldn't ignore it.
In response to Ow Mun Heng <[EMAIL PROTECTED]>:
>
> On Thu, 2007-11-08 at 12:02 -0500, Bill Moran wrote:
> > Frequently, when people ask for help because they've exceed max_fsm*,
> > it's because they're not paying attention to their systems, and therefore
> > the problem has been occurring for a
On Tue, 2007-11-13 at 09:49 -0500, Bill Moran wrote:
> In response to Ow Mun Heng <[EMAIL PROTECTED]>:
> > How does one monitor it closely anyway? the warning comes when one does
> > a vacuum verbose and with autovacuum turned on, I don't even see it
> > anywhere.
>
> 1) Run vacuum verbose from c
In response to Ow Mun Heng <[EMAIL PROTECTED]>:
>
> Even with the regular vacuuming and even a vacuum full ( on my test DB)
> I still see that perhaps something is wrong (from the below)
>
> (I got this gem from the mailling list archives)
> hmxmms=> SELECT
> c.relname,
> c.reltuples::big
On Mon, 2007-11-19 at 08:24 -0500, Bill Moran wrote:
> In response to Ow Mun Heng <[EMAIL PROTECTED]>:
> >
> > Even with the regular vacuuming and even a vacuum full ( on my test DB)
> > I still see that perhaps something is wrong (from the below)
> >
> > (I got this gem from the mailling list a
On Nov 20, 2007, at 6:14 PM, Ow Mun Heng wrote:
On Mon, 2007-11-19 at 08:24 -0500, Bill Moran wrote:
In response to Ow Mun Heng <[EMAIL PROTECTED]>:
Even with the regular vacuuming and even a vacuum full ( on my
test DB)
I still see that perhaps something is wrong (from the below)
(I got t
14 matches
Mail list logo