Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: sort_mem affect on inserts?
Date
Msg-id 200411191225.45936.josh@agliodbs.com
Whole thread Raw
In response to Re: sort_mem affect on inserts?  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: sort_mem affect on inserts?
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Frank Wiles
Date:
Subject: Re: Query Performance and IOWait
Next
From: Stephan Szabo
Date:
Subject: Re: index use