Re: Setting effective_cache size

Nandakumar M wrote: > According to https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server : > > > effective_cache_size should be set to an estimate of how much memory is > > available for disk caching by the operating system and within the database > > itself, after taking into account

Re: How can sort performance be so different

Hi Peter I did check out using ICU and the performance does indeed seem comparable with C locale: EXPLAIN ANALYZE select * from chart order by name COLLATE "lo-x-icu"; QUERY PLAN