Re: [GENERAL] BDR, limit number of groups in a cluster

2017-09-10 Thread Craig Ringer
On 11 September 2017 at 09:32, milist ujang wrote: > Hi all, > > Based on the docs and look at the processes, it seems 1 wal sender on each > node per group. > > If there is scenario of consolidating many databases (say hundreds) into 1 > database (in this central cluster there are hundreds wal s

[GENERAL] BDR, limit number of groups in a cluster

2017-09-10 Thread milist ujang
Hi all, Based on the docs and look at the processes, it seems 1 wal sender on each node per group. If there is scenario of consolidating many databases (say hundreds) into 1 database (in this central cluster there are hundreds wal sender), what is the limit number of groups? I wonder if anyone h

Re: [GENERAL] pg_ident mapping Kerberos Usernames

2017-09-10 Thread techmail+pgsql
On 09/10/2017 04:27 PM, Jeff Janes wrote: On Sun, Sep 10, 2017 at 11:25 AM, > wrote: On 09/10/2017 02:39 AM, Magnus Hagander wrote: On Sat, Sep 9, 2017 at 6:44 PM, mailto:techmail%2bpg...@dangertoaster.com>

Re: [GENERAL] pg_ident mapping Kerberos Usernames

2017-09-10 Thread Jeff Janes
On Sun, Sep 10, 2017 at 11:25 AM, wrote: > On 09/10/2017 02:39 AM, Magnus Hagander wrote: > >> On Sat, Sep 9, 2017 at 6:44 PM, > > wrote: >> >> Hi, >> >> I'm trying to get pg_ident to map "user1" and "us...@a.domain.tld" >> to "user1" in postgres,

Re: [GENERAL] pg_ident mapping Kerberos Usernames

2017-09-10 Thread techmail+pgsql
On 09/09/2017 09:28 PM, rob stone wrote: On Sat, 2017-09-09 at 20:44 -0500, techmail+pg...@dangertoaster.com wrote: Hi, I'm trying to get pg_ident to map "user1" and "us...@a.domain.tld" to "user1" in postgres, or vice versa. I'm not picky about which way works. Kerberos authentication works

Re: [GENERAL] B-tree index on a VARCHAR(4000) column

2017-09-10 Thread John Turner
On Sun, Sep 10, 2017 at 1:24 PM Tom Lane wrote: > > For every other purpose, PG just pays attention to the actual column > values' lengths. > > Thanks for elaborating, Tom. This would appear to be a(nother) case where PG represents the voice of sanity as compared with 'the other guys' : ) John

Re: [GENERAL] pg_ident mapping Kerberos Usernames

2017-09-10 Thread techmail+pgsql
On 09/10/2017 02:39 AM, Magnus Hagander wrote: On Sat, Sep 9, 2017 at 6:44 PM, > wrote: Hi, I'm trying to get pg_ident to map "user1" and "us...@a.domain.tld" to "user1" in postgres, or vice versa. I'm not picky about which way works. K

Re: [GENERAL] B-tree index on a VARCHAR(4000) column

2017-09-10 Thread Tom Lane
John Turner writes: > On Sun, Sep 10, 2017 at 10:42 AM Merlin Moncure wrote: >> Nope. Memory usage is proportional to the size of the string, not the >> maximum length for varchar. Maximum length is a constraint. > Ok, thanks for verifying. I was curious since other platforms seem to > handle

Re: [GENERAL] B-tree index on a VARCHAR(4000) column

2017-09-10 Thread John Turner
On Sun, Sep 10, 2017 at 10:42 AM Merlin Moncure wrote: > On Friday, September 8, 2017, John Turner wrote: > >> >> >> On Fri, Sep 8, 2017 at 6:57 AM Tom Lane wrote: >> >>> Ron Johnson writes: >>> > Based on LENGTH(offending_column), none of the values are more than 144 >>> > bytes in this 44.2M

Re: [GENERAL] B-tree index on a VARCHAR(4000) column

2017-09-10 Thread Merlin Moncure
On Friday, September 8, 2017, John Turner wrote: > > > On Fri, Sep 8, 2017 at 6:57 AM Tom Lane > wrote: > >> Ron Johnson > > writes: >> > Based on LENGTH(offending_column), none of the values are more than 144 >> > bytes in this 44.2M row table. Even though VARCHAR is, by definition, >> > varia

Re: [GENERAL] pg_ident mapping Kerberos Usernames

2017-09-10 Thread Magnus Hagander
On Sat, Sep 9, 2017 at 6:44 PM, wrote: > Hi, > > I'm trying to get pg_ident to map "user1" and "us...@a.domain.tld" to > "user1" in postgres, or vice versa. I'm not picky about which way works. > > Kerberos authentication works. I've gotten "user1" to login successfully > with a Kerberos ticket,