Re: Can I trigger an action from a coalesce ?

It could also be done by putting those values in square bracket, if substituted with default values.eg. [0]       4       45        [100]Values within square brackets are default values. On Sunday, 23 February, 2020, 04:52:11 pm IST, Peter J. Holzer wrote: On 2020-02-22 16:02:06 -05

RE: Replication: slave server has 3x size of production server?

De: Adrian Klaver Enviado: domingo, 23 de fevereiro de 2020 15:42 Para: Edson Richter ; pgsql-general Assunto: Re: Replication: slave server has 3x size of production server? On 2/23/20 8:04 AM, Edson Richter wrote: > ---

Re: Reset DB stats suggestion pg_stat_reset()

On 2/23/20 10:19 AM, Adrian Klaver wrote: On 2/22/20 6:40 PM, postggen2020 s wrote: Thanks Adrian. I am aware about the functions. Here need is, can we use this?.or is there any known effects after firing the functions?. Yes the stats counters will be reset to 0, which means the planner will

Re: How to get error message details from libpq based psqlODBC driver (regression)

Hi! I don't have an answer for you. There maybe someone else on this list that could help, though I think your best bet would be to ask the question again on the pgsql-odbc list. I posted it in pgsql-odbc list. In pgsql odbc source code file connection.c: line 866 contains: errprimary = PQr

Re: Replication: slave server has 3x size of production server?

On 2/23/20 8:04 AM, Edson Richter wrote: *De:* Adrian Klaver *Enviado:* sábado, 22 de fevereiro de 2020 20:34 *Para:* Edson Richter ; pgsql-general *Assunto:* Re: Replication: slave server has 3x s

Re: How to get error message details from libpq based psqlODBC driver (regression)

On 2/23/20 1:06 AM, Andrus wrote: Hi! What does the log_error_verbosity setting in postgresql.conf show? It is not set. postgresql.conf contains it default value from installation: #log_error_verbosity = default    # terse, default, or verbose messages I changed it to log_error_verbosi

Re: Reset DB stats suggestion pg_stat_reset()

On 2/22/20 6:40 PM, postggen2020 s wrote: Thanks Adrian. I am aware about the functions. Here need is, can we use this?.or is there any known effects after firing the functions?. Yes the stats counters will be reset to 0, which means the planner will not have accurate statistics to work with.

RE: Replication: slave server has 3x size of production server?

De: Adrian Klaver Enviado: sábado, 22 de fevereiro de 2020 20:34 Para: Edson Richter ; pgsql-general Assunto: Re: Replication: slave server has 3x size of production server? On 2/22/20 2:51 PM, Edson Richter wrote: > > Yes, it is working. Last X'log file is pr

Re: Is is safe to use SPI in multiple threads?

On 2020-02-18 19:07:44 +, Tom Mercha wrote: > On 23/12/2016 13:41, Peter J. Holzer wrote: > > On 2016-12-09 16:52:05 +0800, Qiu Xiafei wrote: > >> I'm new to PG and want to implement my domain-specific system based on PG. > >> I > >> wish to arrange my data as several tables in database and tr

Re: Can I trigger an action from a coalesce ?

On 2020-02-22 16:02:06 -0500, stan wrote: > I have a case where if a value does not exist, I am going to use a default, > which is easy with coalesce. But I would like to warn the user that a > default has been supplied. The default value is reasonable, and could > actually come from the source tab

Re: DB running out of memory issues after upgrade

On 2020-02-18 18:10:08 +, Nagaraj Raj wrote: > Below are the same configurations ins .conf file before and after updagrade > > show max_connections; = 1743 [...] > show work_mem = "4MB" This is an interesting combination: So you expect a large number of connections but each one should use ver

Re: How to get error message details from libpq based psqlODBC driver (regression)

Hi! What does the log_error_verbosity setting in postgresql.conf show? It is not set. postgresql.conf contains it default value from installation: #log_error_verbosity = default# terse, default, or verbose messages I changed it to log_error_verbosity = verbose but problem persists.