Re: sort_mem affect on inserts?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, David Parker <dparker(at)tazznetworks(dot)com>
Subject: Re: sort_mem affect on inserts?
Date: 2004-11-19 20:25:45
Message-ID: 200411191225.45936.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jan,

> Hmmm ... what type of foreign key lookup would that be? None of the RI
> generated queries has any order by clause.

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

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-11-19 20:27:39 Re: index use
Previous Message Chris Browne 2004-11-19 20:23:15 Re: When to bump up statistics?