Re: Create Index Performance Issue - Mailing list pgsql-admin

From Tom Lane
Subject Re: Create Index Performance Issue
Date
Msg-id 24530.1212590735@sss.pgh.pa.us
Whole thread Raw
In response to Create Index Performance Issue  (Rudolf van der Leeden <vanderleeden@logicunited.com>)
Responses Re: Create Index Performance Issue  (Rudolf van der Leeden <vanderleeden@logicunited.com>)
List pgsql-admin
Rudolf van der Leeden <vanderleeden@logicunited.com> writes:
> [ different times to build a varchar index on allegedly identical
>   installations ]

Perhaps one is using C locale and the other is not?  strcmp() vs
strcoll() is a pretty big hit.  In general it'd be worth dumping
out the whole contents of pg_settings and diffing those two files
to see if you missed any configuration differences.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: unrecognized configuration parameter "synchronize_seqscans"
Next
From: zferentz@gmail.com
Date:
Subject: Postgres security issue - protecting datafiles