Re: [ADMIN] Postgres log(pg_logs) have lots of message

From: Nik Tek <niktek2005(at)gmail(dot)com>
To: Bambi Bellows <bbellows(at)dotomi(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] Postgres log(pg_logs) have lots of message
Date: 2013-04-10 22:05:55
Message-ID: CAHySzWWhRYh+jqBU3wONHvygcr-RuFRrxLHz8VNnwCeyLXesJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Hi Bambi,

Thank you the prompt reply.

This table is very volatile, lot of inserts/updates happen on this
tables(atleast 20~30 inserts/min).
When auto vacuum tries to run on this table, I get this warning.

Is there a way, I force it to happen, because the table/indexes statistics
are becoming stale very quickly.

Thank you
Nik

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Armin Resch 2013-04-10 23:59:29 regexp_replace grief
Previous Message Bambi Bellows 2013-04-10 22:00:13 Re: Postgres log(pg_logs) have lots of message

Browse pgsql-performance by date

  From Date Subject
Next Message Steve Singer 2013-04-10 23:54:09 Re: slow bitmap heap scans on pg 9.2
Previous Message Bambi Bellows 2013-04-10 22:00:13 Re: Postgres log(pg_logs) have lots of message