template0 | _postgres | UTF8 | C | C | =c/_postgres +
| | | | | _postgres=CTc/_postgres
template1 | _postgres | UTF8 | C | C | =c/_postgres +
| | | | | _postgres=CTc/_postgres
(8 rows)
The difference between the "C" and the "en_US" collation is entirely sufficient to explain the difference in performance. "C" is the fastest possible collation as it never needs to look ahead or consult tables, it just compares raw bytes.
Cheers,
Jeff
Hi Jeff,
is there a way to set a default collection during compiling or in the configuration file? I have never specified one, so I suppose that somewhere on MacMini “C” collation type is set as the default one.