Re: Hash Anti Join performance degradation

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: panam <panam(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hash Anti Join performance degradation
Date: 2011-05-26 02:40:22
Message-ID: 4DDDBD96.4010809@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On 05/26/2011 12:42 AM, panam wrote:

> So, would you like to further investigate my previous issue (I think it is
> still strange that performance suddenly dropped that dramatically)?

It's a bit beyond me, but I suspect that it'd be best if you could hang
onto the dump file in case someone has the time and enthusiasm to
investigate it. I take it you can't distribute the dump file, even
privately?

--
Craig Ringer

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-05-26 03:19:31 Re: SSI predicate locking on heap -- tuple or row?
Previous Message Fujii Masao 2011-05-26 02:09:45 Re: tackling full page writes

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2011-05-26 03:17:50 Re: "error with invalid page header" while vacuuming pgbench data
Previous Message Merlin Moncure 2011-05-26 01:20:23 Re: Speeding up loops in pl/pgsql function