Re: autovacuum blues

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Anton Melser <melser(dot)anton(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum blues
Date: 2006-11-09 21:04:28
Message-ID: 20061109210428.GN26818@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 number
> of tuples in the table? The total modified/deleted?

pg_class.reltuples

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rick Schumeyer 2006-11-09 21:04:33 Can non-superuser install c functions ?
Previous Message sumit kumar 2006-11-09 20:59:31 LIKE OPERATOR cardinality estimation