Re: Adding foreign key performance

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Adding foreign key performance
Date: 2003-10-28 16:33:59
Message-ID: 20031028113359.3932438f.threshar@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 28 Oct 2003 09:16:45 -0500
Jeff <threshar(at)torgo(dot)978(dot)org> wrote:

> 7.3.4: 328912ms [cpu pegged]
> 7.4b4: 298383ms [cpu pegged]
>

Just loaded up delicious 7.4b5 and wow...

sort_mem 8192: 137038ms [lots of tmp file activity]
sort_mem 256000: 83109ms

That's some good work there Lou, You'll make sargent for that someday.

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-10-28 17:36:02 Re: Guesses on what this NestLoop is for?
Previous Message Christopher Browne 2003-10-28 15:59:37 Re: Optimizing Performance