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

2015-02-22 Thread Sterfield
2015-02-20 14:26 GMT-08:00 Shanker Singh ssi...@iii.com: 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

[GENERAL] DB encoding, locale and indexes

2015-02-05 Thread Sterfield
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

Re: [GENERAL] DB encoding, locale and indexes

2015-02-05 Thread Sterfield
2015-02-05 15:56 GMT+01:00 Tom Lane t...@sss.pgh.pa.us: Sterfield sterfi...@gmail.com 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_CTYPE) is set