Skip site navigation (1) Skip section navigation (2)

Re: Adding foreign key performance

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Adding foreign key performance
Date: 2003-10-28 18:34:31
Message-ID: 20031028133431.0bf17ce4.threshar@torgo.978.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, 28 Oct 2003 10:32:36 -0800 (PST)
Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:

> 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.

Yes. those are the numbers for 256MB of sort_mem.

It seemed to saturate the IO so once I get more disks in here it should
hopefully speed up.

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

In response to

pgsql-performance by date

Next:From: John K. HerreshoffDate: 2003-10-28 18:38:43
Subject: Re: Adding foreign key performance
Previous:From: Bruce MomjianDate: 2003-10-28 18:34:15
Subject: Re: Adding foreign key performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group