Re: Adding foreign key performance

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
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 18:32:36
Message-ID: 20031028101820.T64490@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 28 Oct 2003, Jeff wrote:

> 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

Hmm, 298383 -> 83109 (since those are the 256k numbers). Not as
much as I'd have hoped, but I'll take a factor of 3.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2003-10-28 18:34:15 Re: Adding foreign key performance
Previous Message markw 2003-10-28 18:08:33 Re: analyzing postgresql performance for dbt-2