On 11/17/2004 5:07 PM, Josh Berkus wrote:
>> 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.
# 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
pgsql-performance by date
|Next:||From: Arshavir Grigorian||Date: 2004-11-19 19:18:55|
|Subject: index use|
|Previous:||From: Dawid Kuroczko||Date: 2004-11-19 13:59:48|
|Subject: When to bump up statistics?|