The idea is that you _can_ do without a cronjob. You may need to do a
first ANALYZE just to get things warmed up, and then let autovacuum do
its job.
Thanks guys, I think I have it now!
Cheers
Antoine
---(end of broadcast)---
TIP 4: Have you sear
Anton Melser wrote:
> On 09/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >Anton Melser wrote:
> >
> >> Thanks for that. Just a clarification, can someone tell me what the
> >> "number of tuples" means in the context of the multipliers? I mean,
> >> when the vacuum min multiplier is at 0.4, we
On 09/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Anton Melser wrote:
> Thanks for that. Just a clarification, can someone tell me what the
> "number of tuples" means in the context of the multipliers? I mean,
> when the vacuum min multiplier is at 0.4, we multiply 0.4 by what? I
> get the
Anton Melser wrote:
> Thanks for that. Just a clarification, can someone tell me what the
> "number of tuples" means in the context of the multipliers? I mean,
> when the vacuum min multiplier is at 0.4, we multiply 0.4 by what? I
> get the min val, but what are we multiplying by 0.4? The total nu
On Thu, 2006-11-09 at 18:16 +0100, Anton Melser wrote:
> On 09/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> > Anton Melser wrote:
> > > Hi,
> > > I just can't understand why autovacuum is not working. I have a test
> > > db/table which I insert values into (by the thousands) and can't work
>
On 09/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Anton Melser wrote:
> Hi,
> I just can't understand why autovacuum is not working. I have a test
> db/table which I insert values into (by the thousands) and can't work
> out why my stats don't get updated. Could someone have a quick look at
Anton Melser wrote:
> Hi,
> I just can't understand why autovacuum is not working. I have a test
> db/table which I insert values into (by the thousands) and can't work
> out why my stats don't get updated. Could someone have a quick look at
> my attached .conf and tell me what I am doing?
> I am r
t; Sent: Thursday, November 09, 2006 1:12 PM
> To: Richard Huxton
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] autovacuum blues
> postgres 1300 0.0 1.1 20180 3048 ?S12:03 0:00
> /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
> postgres 130
On 09/11/06, Richard Huxton wrote:
Anton Melser wrote:
> Hi,
> I just can't understand why autovacuum is not working. I have a test
> db/table which I insert values into (by the thousands) and can't work
> out why my stats don't get updated. Could someone have a quick look at
> my attached .conf
Anton Melser wrote:
Hi,
I just can't understand why autovacuum is not working. I have a test
db/table which I insert values into (by the thousands) and can't work
out why my stats don't get updated. Could someone have a quick look at
my attached .conf and tell me what I am doing?
I am running it
Hi,
I just can't understand why autovacuum is not working. I have a test
db/table which I insert values into (by the thousands) and can't work
out why my stats don't get updated. Could someone have a quick look at
my attached .conf and tell me what I am doing?
I am running it on FC5 8.1.4.fc5.1.
C
11 matches
Mail list logo
