Re: sort_mem affect on inserts?

From: Neil Conway <neilc(at)samurai(dot)com>
To: josh(at)agliodbs(dot)com
Cc: pgsql-performance(at)postgresql(dot)org, Jan Wieck <JanWieck(at)Yahoo(dot)com>, David Parker <dparker(at)tazznetworks(dot)com>
Subject: Re: sort_mem affect on inserts?
Date: 2004-11-21 14:51:58
Message-ID: 41A0AB8E.4040301@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus wrote:
> I was under the impression that work_mem would be used for the index if there
> was an index for the RI lookup. Wrong?

Yes -- work_mem is not used for doing index scans, whether for RI
lookups or otherwise.

-Neil

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2004-11-22 04:15:43 Re: memcached and PostgreSQL
Previous Message Neil Conway 2004-11-21 14:48:05 Re: tablespace + RAM disk?