Re: 8.1 stats issues on Win32

From: Dave Page <dpage(at)postgresql(dot)org>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.1 stats issues on Win32
Date: 2007-02-14 11:29:58
Message-ID: 45D2F2B6.2040903@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Magnus Hagander wrote:
> I've been looking at backporting the stats fix committed to head and 8.2
> into 8.1, but realised that it's just not going to work. 8.1 still uses
> the dual stats processor stuff, which means that the simplification just
> is not possible.
>
> The most obvious result is that autovacuum is very likely to fail on 8.1
> if your system load is high enough. (all of stats fail of course, but
> autovac is a very common user of this)
>
> Should we note this somewhere?

Probably.

> Oh, and if we were "looking for reasons" to deprecate 8.1, this sounds
> like a pretty good one for me. I still think we should keep patchin it,
> but it is a very good reason to encourage our users to switch to 8.2.
>
> Now, we could try to fix it there, but we've seen a lot of issues since
> day one coming from the "inherit socket in two steps", so even if we can
> get this one fix, there could be more lurking around in the dual-process
> model. I personally don't think it's worth investing the required time
> into fixing that on 8.1.

I'm inclined to agree - time would be better spent improving current and
future versions than chasing stats issues which as we know can be a real
pita to find.

Regards, Dave

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2007-02-14 12:00:52 Re: Writing triggers in C++
Previous Message Magnus Hagander 2007-02-14 11:13:13 integer datetimes