[GENERAL] DB encoding, locale and indexes

Hi everyone, I'm a sysadmin working for an application that stores all its data in a PG database. Currently, the cluster has its encoding set to UTF-8, and the locale (both LC_COLLATE and LC_CTYPE) is set to 'en_US.UTF-8'. I discovered recently that the indexes created on varchar fields are not w

Re: [GENERAL] DB encoding, locale and indexes

2015-02-05 15:56 GMT+01:00 Tom Lane : > Sterfield writes: > > I'm a sysadmin working for an application that stores all its data in a > PG > > database. > > Currently, the cluster has its encoding set to UTF-8, and the locale > (both > > LC_COLLATE and LC_C

Re: [GENERAL] parallel dump fails to dump large tables

2015-02-20 14:26 GMT-08:00 Shanker Singh : > I tried turning off ssl renegotiation by setting "ssl_renegotiation_limit > = 0" in postgresql.conf but it had no effect. The parallel dump still fails > on large tables consistently. > > Thanks > Shanker > > HI, Maybe you could try to setup an SSH con