Re: LDAP authorization with postgresql

2021-10-08 Thread Keith Brown
Yes, authentication with gss is great. Just authorization story with postgresql is much harder. Should I even bother with LDAP? instead just do it manually? I want to avoid another component like pg-ldap-sync On Fri, Oct 8, 2021 at 3:08 PM Stephen Frost wrote: > > Greetings, > > * Keith Brown (ke

Re: LDAP authorization with postgresql

2021-10-08 Thread Stephen Frost
Greetings, * Keith Brown (keith6...@gmail.com) wrote: > I use GSS for authentication. But I would like to setup LDAP based > authorization, so a user can have access to a particular > database/role/etc...I found documentation on how to setup LDAP but > don't really see any examples for what I am t

Re: Gist fastbuild and performances

2021-10-08 Thread talk to ben
On Fri, Oct 8, 2021 at 4:33 PM Francisco Olarte wrote: > If you do not run the same sequences, you do not know. Note I do not > know what exact sequences you have tested, I write with only what I > have read as as input. > I ran this on both versions on fresh instances / clusters with the data f

Re: Gist fastbuild and performances

2021-10-08 Thread Francisco Olarte
Ben: On Fri, 8 Oct 2021 at 15:52, talk to ben wrote: > I ran the same scipt on both sides at first. > Then I switched to a COPY because the CREATE TABLE generates random data. Logical, just pointing that you missed one side is generating, the other is copying. Since I read a lot of things about

Re: Gist fastbuild and performances

2021-10-08 Thread talk to ben
Hi, thanks for the answer. I ran the same scipt on both sides at first. Then I switched to a COPY because the CREATE TABLE generates random data. Since I got weird results, I wanted to be sure I had the same data on both versions. I ran the tests several times (and even asked a collegue to do it

LDAP authorization with postgresql

2021-10-08 Thread Keith Brown
I use GSS for authentication. But I would like to setup LDAP based authorization, so a user can have access to a particular database/role/etc...I found documentation on how to setup LDAP but don't really see any examples for what I am trying to do. Any suggestions?

Re: Gist fastbuild and performances

2021-10-08 Thread Francisco Olarte
Ben: On Fri, 8 Oct 2021 at 13:14, talk to ben wrote: > I am playing around with the gist fast build and comparing the result between > v13 and v14. ... > When I compare the performance with the following script, I get a lot more > data read into the buffers in v14 and a little slower query. ...

Gist fastbuild and performances

2021-10-08 Thread talk to ben
Hi, I am playing around with the gist fast build and comparing the result between v13 and v14. The space gain and speed increase are really awesome. When I compare the performance with the following script, I get a lot more data read into the buffers in v14 and a little slower query. Is it expec