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. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
