pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joe Conway <mail@joeconway.com>
To: Matthew T. O'Connor <matthew@zeut.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Cc: Josh Berkus <josh@agliodbs.com>
Subject: Re: rapid degradation after postmaster restart
Date: Mon, 15 Mar 2004 21:48:05 -0800
Message-ID: <40569515.70902@joeconway.com> (raw)
In-Reply-To: <4056916B.5090204@zeut.net>
References: <4052661D.5060505@joeconway.com>
	<14884.1079150555@sss.pgh.pa.us>
	<4055F343.6070600@joeconway.com>
	<405614CA.5030101@zeut.net>
	<405689A4.4080406@joeconway.com>
	<4056916B.5090204@zeut.net>

Matthew T. O'Connor wrote:
> Strange... I wonder if this is some integer overflow problem.  There was 
> one reported recently and fixed as of CVS head yesterday, you might try 
> that, however without the -d2 output I'm only guessing at why 
> pg_autovacuum is vacuuming so much / so often.

I'll see what I can do tomorrow to track it down.

I have already recommended to the program manager that they switch to 
7.4.2 plus the autovacuum patch. Not sure they will be willing to make 
any changes at this stage in their release process though.

> If we can't find one, any chance you can 
> do some testing with CVS HEAD just to see if that works any better.  I 
> know there has been a fair amount of work done to improve this situation 
> (not just vacuum delay, but ARC etc...)

I might do that, but not likely on Solaris. I can probably get a copy of 
the current database and testing scripts, and give it a try on one of my 
own machines (all Linux, either RHAS3, RH9, or Fedora).

Joe




view thread (26+ messages)  latest in thread

Message-ID: <40569515.70902@joeconway.com>
Permalink:  ../40569515.70902@joeconway.com/
Also on:    postgresql.org/message-id/40569515.70902@joeconway.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mail@joeconway.com, matthew@zeut.net, tgl@sss.pgh.pa.us, josh@agliodbs.com
  Subject: Re: rapid degradation after postmaster restart
  In-Reply-To: <40569515.70902@joeconway.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox