Re: sort_mem affect on inserts?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: josh@xxxxxxxxxxxx
Subject: Re: sort_mem affect on inserts?
From: Neil Conway <neilc@xxxxxxxxxxx>
Date: Mon, 22 Nov 2004 01:51:58 +1100
Cc: pgsql-performance@xxxxxxxxxxxxxx, Jan Wieck <JanWieck@xxxxxxxxx>, David Parker <dparker@xxxxxxxxxxxxxxxx>
In-reply-to: <200411191225.45936.josh@xxxxxxxxxxxx>
References: <07FDEE0ED7455A48AC42AC2070EDFF7C26BA3D@xxxxxxxxxxxxxxxxxxxxxxxxx> <200411171407.30795.josh@xxxxxxxxxxxx> <419E0466.9090409@xxxxxxxxx> <200411191225.45936.josh@xxxxxxxxxxxx>
User-agent: Mozilla Thunderbird 0.9 (Macintosh/20041103)

Josh Berkus wrote:

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

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


-Neil

References:
- sort_mem affect on inserts?
  - From: David Parker
- Re: sort_mem affect on inserts?
  - From: Josh Berkus
- Re: sort_mem affect on inserts?
  - From: Jan Wieck
- Re: sort_mem affect on inserts?
  - From: Josh Berkus

Prev by Date: Re: tablespace + RAM disk?
Next by Date: Re: memcached and PostgreSQL
Previous by thread: Re: sort_mem affect on inserts?
Next by thread: postgres eating CPU
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux