Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout

Original Message Subject: Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout Local Time: 3 février 2017 1:15 AM UTC Time: 3 février 2017 00:15 From: adrian.kla...@aklaver.com To: JP Jacoupy , pgsql-general@postgresql.org

[GENERAL] Re: PSQL 9.5 select for update locks too many rows when using numeric instead of int

Looks to me the first plan was using seq scan not the index b/c the value had to be cast to numeric. In such case index is not used, as expected. Filter: ((true_data_id)::numeric = '209390104'::numeric) Thanks, Patricia From: Sfiligoi, Igor [mailto:igor.sfili...@ga.com] Sent:

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

On 2017-02-03 22:17:55 +0300, Nikolai Zhubr wrote: > 03.02.2017 20:29, Andres Freund: > [...] > > > > Could you use process monitor or such to see what the process is doing > > > > while using a lot of CPU? > > > > > > I'm not sure how to do this, especially considering that the process in > > >

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

03.02.2017 20:29, Andres Freund: [...] Could you use process monitor or such to see what the process is doing while using a lot of CPU? I'm not sure how to do this, especially considering that the process in question is running as a service? I don't think that stops you, if you have admin

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

On 2017-02-01 01:02:11 +0300, Nikolai Zhubr wrote: > 31.01.2017 19:51, Andres Freund: > [...] > > > Exactly same trouble with 9.4 (Specifically EDB 9.4.10-1 win32) > > > > That's good to know, less because of 519b0757, more because of the latch > > changes - but they also went in in 9.5... > > >

Re: [GENERAL] create trigger in postgres to check the password strength

2017-02-03 17:17 GMT+01:00 Pavel Stehule : > Hi > > 2017-02-03 16:14 GMT+01:00 PAWAN SHARMA : > >> Hi All, >> >> Is this possible to create trigger in postgres to check the password >> strength( like char should be min 8 character) while to

Re: [GENERAL] create trigger in postgres to check the password strength

Hi 2017-02-03 16:14 GMT+01:00 PAWAN SHARMA : > Hi All, > > Is this possible to create trigger in postgres to check the password > strength( like char should be min 8 character) while to creating user or > role with password. > > If it possible can you please share

Re: [GENERAL] create trigger in postgres to check the password strength

Oh sorry, I misunderstood. Didn't realize you meant database users an not an application user table implemented in Postgres. I'll let others answer that then because i'm not aware of a way to do that.

Re: [GENERAL] create trigger in postgres to check the password strength

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland Registered in Dublin, Ireland Registration Number: 368047 On Fri, Feb 3, 2017 at 3:55 PM, PAWAN SHARMA wrote: > > On Fri, Feb 3, 2017 at 9:11 PM, Adam Brusselback < > adambrusselb...@gmail.com> wrote:

Re: [GENERAL] create trigger in postgres to check the password strength

On Fri, Feb 3, 2017 at 9:11 PM, Adam Brusselback wrote: > Whoops, accidentally sent this to only Pawan instead of the list: >> >> > Hey there, so I would highly suggest you avoid arbitrary password strength > policies like that. I wrote a library for my company which

Re: [GENERAL] create trigger in postgres to check the password strength

Whoops, accidentally sent this to only Pawan instead of the list: > > Hey there, so I would highly suggest you avoid arbitrary password strength policies like that. I wrote a library for my company which we use for password strength estimation, but it is written in Java. I've been thinking about

Re: [GENERAL] create trigger in postgres to check the password strength

On Fri, Feb 3, 2017 at 8:44 PM, PAWAN SHARMA wrote: > Hi All, > > Is this possible to create trigger in postgres to check the password > strength( like char should be min 8 character) while to creating user or > role with password. > > If it possible can you please

[GENERAL] create trigger in postgres to check the password strength

Hi All, Is this possible to create trigger in postgres to check the password strength( like char should be min 8 character) while to creating user or role with password. If it possible can you please share the script with me.. -Pawan

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

03.02.2017 13:52, I wrote: [...] Adding this "Sleep(15)" before "goto retry" into secure_read() has apparently eliminated the effect at our production server too. That is, my load-bug-detector has been quiet for > 24hr or more. Now by adding more debigging stuff into secure_read() and

Re: [GENERAL] Row level security policy - calling function for right hand side value of 'in' in using_expression

Thanks Tom! I actually considered what you suggested earlier, but somehow I thought the function get called as many as number of rows, then guessed returning a list might be cached and used internally (but I confess that I do not know the internals of RLS). Anyway, I rewrote it as you

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

02.02.2017 2:14, I wrote: 01.02.2017 1:02, I wrote: [...] Could you use process monitor or such to see what the process is doing while using a lot of CPU? I'm not sure how to do this, especially considering that the process in question is running as a service? Now, some more input: * 9.5.2

Re: [GENERAL] pgbouncer increase pool_size, reload does not work

On Thu, 2 Feb 2017 16:12:06 -0800 Adrian Klaver wrote: > On 02/02/2017 03:27 AM, alexanderfelipewo wrote: > > hello! > > > > i have a question for pgbouncer in case someone has faced this and there is > > a solution available. > > > > i have a db with pgbouncer where

Re: [GENERAL] RUM-index and support for storing BIGINT as part of a tsvector+timestamp

Ping...   Any feedback is welcome, thanks.   På torsdag 12. januar 2017 kl. 13:13:34, skrev Andreas Joseph Krogh < andr...@visena.com >: Hi PostgresPro-guys.   I've asked this before but didn't get any response, so I'll try again. I know you have a lot on you plate...