Re: Postgres log(pg_logs) have lots of message

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

Subject: Re: 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>
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

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: [PERFORM] Postgres log(pg_logs) have lots of message
  - From: Jeff Janes

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

Prev by Date: Re: Postgres log(pg_logs) have lots of message
Next by Date: regexp_replace grief
Previous by thread: Re: Postgres log(pg_logs) have lots of message
Next by thread: Re: [PERFORM] Postgres log(pg_logs) have lots of message
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux