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. -- --Josh Josh Berkus Aglio Database Solutions San Francisco
