Re: Hash indexes and effective_cache_size in CREATE INDEX documentation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hash indexes and effective_cache_size in CREATE INDEX documentation
Date: 2016-07-31 16:18:50
Message-ID: 21293.1469981930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Geoghegan <pg(at)heroku(dot)com> writes:
> The CREATE INDEX documentation states:
> "For hash indexes, the value of effective_cache_size is also relevant
> to index creation time: PostgreSQL will use one of two different hash
> index creation methods depending on whether the estimated index size
> is more or less than effective_cache_size.

Oooh. That should've been changed by 4adc2f72, and then again in
9563d5b5. Will fix.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-07-31 16:34:12 Re: Combining hash values
Previous Message Tomas Vondra 2016-07-31 16:02:44 Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)