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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Bambi Bellows <bbellows@xxxxxxxxxx>
Subject: Re: [ADMIN] Postgres log(pg_logs) have lots of message
From: Nik Tek <niktek2005@xxxxxxxxx>
Date: Wed, 10 Apr 2013 15:05:55 -0700
Cc: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <476A789550F3704390F8B2B95D246402048549@ORD-EXDB102.corp.valueclick.com>
References: <CAHySzWXT5RF30cFOARSq1HqNxO7v0TBuigWaV4NedEtwWrda=Q@mail.gmail.com> <476A789550F3704390F8B2B95D246402048549@ORD-EXDB102.corp.valueclick.com>

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

Follow-Ups:
- Re: Postgres log(pg_logs) have lots of message
  - From: Jeff Janes

References:
- Postgres log(pg_logs) have lots of message
  - From: Nik Tek

Prev by Date: Postgres log(pg_logs) have lots of message
Next by Date: Re: slow bitmap heap scans on pg 9.2
Previous by thread: Postgres log(pg_logs) have lots of message
Next by thread: Re: Postgres log(pg_logs) have lots of message
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux