sort_mem affect on inserts?

From: "David Parker" <dparker(at)tazznetworks(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: sort_mem affect on inserts?
Date: 2004-11-17 21:31:31
Message-ID: 07FDEE0ED7455A48AC42AC2070EDFF7C26BA3D@corpsrv2.tazznetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

- DAP
----------------------------------------------------------------------------------
David Parker Tazz Networks (401) 709-5130
 

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-11-17 22:07:30 Re: sort_mem affect on inserts?
Previous Message Josh Berkus 2004-11-17 21:07:06 Re: memcached and PostgreSQL