Postgres Pro
Downloads
Home   >   mailing lists

Re: Hash indexes and effective_cache_size in CREATE INDEX documentation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hash indexes and effective_cache_size in CREATE INDEX documentation
Date
Msg-id 21293.1469981930@sss.pgh.pa.us
Whole thread Raw
In response to Hash indexes and effective_cache_size in CREATE INDEX documentation  (Peter Geoghegan <pg@heroku.com>)
Responses Re: Hash indexes and effective_cache_size in CREATE INDEX documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Peter Geoghegan <pg@heroku.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

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [Patch] Temporary tables that do not bloat pg_catalog (a.k.a fast temp tables)
Next
From: Tom Lane
Date:
Subject: Re: Combining hash values