Postgres Pro
Downloads
Home   >   mailing lists

Re: sort_mem affect on inserts? - Mailing list pgsql-performance

From Neil Conway
Subject Re: sort_mem affect on inserts?
Date
Msg-id 41A0AB8E.4040301@samurai.com
Whole thread Raw
In response to Re: sort_mem affect on inserts?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: tablespace + RAM disk?
Next
From: Bruce Momjian
Date:
Subject: Re: memcached and PostgreSQL