Re: [HACKERS] AutoVacuum Behaviour Question

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce McAlister <bruce(dot)mcalister(at)blueface(dot)ie>, General <pgsql-general(at)postgresql(dot)org>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] AutoVacuum Behaviour Question
Date: 2007-09-14 19:02:54
Message-ID: 200709141902.l8EJ2sB29973@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Andrew Hammond wrote:
> On 9/13/07, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> >
> > Alvaro Herrera wrote:
> > > Bruce Momjian wrote:
> > > >
> > > > Is this item closed?
> > >
> > > No, it isn't. Please add a TODO item about it:
> > > * Prevent long-lived temp tables from causing frozen-Xid advancement
> > > starvation
> >
> > Sorry, I don't understand this. Can you give me more text? Thanks.
> >
>
> s/long-lived/orphaned/ ? And possibly this means better orphan detection and
> removal.

Added:

o Prevent long-lived temporary tables from causing frozen-xid
advancement starvation

http://archives.postgresql.org/pgsql-general/2007-06/msg01645.php

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-09-14 19:18:21 Re: constrains on two tables
Previous Message Vivek Khera 2007-09-14 17:50:19 Re: importing pgsql schema into visio (for diagramming)

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-09-14 19:16:41 8.3 Open Items
Previous Message Joshua D. Drake 2007-09-14 18:59:40 Re: RETURNING and DO INSTEAD ... Intentional or not?