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

Re: sort_mem affect on inserts?

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: josh(at)agliodbs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org,David Parker <dparker(at)tazznetworks(dot)com>
Subject: Re: sort_mem affect on inserts?
Date: 2004-11-19 14:34:14
Message-ID: 419E0466.9090409@Yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 11/17/2004 5:07 PM, Josh Berkus wrote:

> David,
> 
>> I understand that the sort_mem conf setting affects queries with order by,
>> etc., and the doc mentions that it is used in create index. Does sort_mem
>> affect the updating of indexes, i.e., can the sort_mem setting affect the
>> performance of inserts?
> 
> Only if the table has Foriegn Keys whose lookup might require a large sort.   
> Otherwise, no.
> 

Hmmm ... what type of foreign key lookup would that be? None of the RI 
generated queries has any order by clause.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

pgsql-performance by date

Next:From: Arshavir GrigorianDate: 2004-11-19 19:18:55
Subject: index use
Previous:From: Dawid KuroczkoDate: 2004-11-19 13:59:48
Subject: When to bump up statistics?

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