pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Neil Conway <neilc@samurai.com>
To: josh@agliodbs.com
Cc: pgsql-performance@postgresql.org, Jan Wieck <JanWieck@Yahoo.com>
Cc: David Parker <dparker@tazznetworks.com>
Subject: Re: sort_mem affect on inserts?
Date: Mon, 22 Nov 2004 01:51:58 +1100
Message-ID: <41A0AB8E.4040301@samurai.com> (raw)
In-Reply-To: <200411191225.45936.josh@agliodbs.com>
References: <07FDEE0ED7455A48AC42AC2070EDFF7C26BA3D@corpsrv2.tazznetworks.com>
	<200411171407.30795.josh@agliodbs.com>
	<419E0466.9090409@Yahoo.com>
	<200411191225.45936.josh@agliodbs.com>

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



view thread (5+ messages)

Message-ID: <41A0AB8E.4040301@samurai.com>
Permalink:  ../41A0AB8E.4040301@samurai.com/
Also on:    postgresql.org/message-id/41A0AB8E.4040301@samurai.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: neilc@samurai.com, josh@agliodbs.com, JanWieck@Yahoo.com, dparker@tazznetworks.com
  Subject: Re: sort_mem affect on inserts?
  In-Reply-To: <41A0AB8E.4040301@samurai.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox