Re: Fwd: Disable autocommit inside dbeaver

On 12/6/23 20:45, arun chirappurath wrote: Hi All, Is there a way we can disable autocommit option inside query writing area? Not by choosing auto commit from drop down menu. Thanks, Arun maybe "begin; ; commit;"

Fwd: Disable autocommit inside dbeaver

Hi All, Is there a way we can disable autocommit option inside query writing area? Not by choosing auto commit from drop down menu. Thanks, Arun

Re: Trainning and Certification

On 12/5/23 09:19, roger popa wrote: Hello, You can tell if exists an oficial Postgresql Certification issued by postgresql.org ? Or others (like PearsonVue)? Training and Certification path, source doc ? See this thread from June 2023:

Re: Trainning and Certification

> On 6 Dec 2023, at 16:30, roger popa wrote: > > Exist a top of this issue, for this request? I'm not sure I understand what you are asking here. If you are asking for a postgres feature request or some form of prioritized roadmap then the answer is no. There is no such thing in the postgres

Re: Trainning and Certification

On Wed, Dec 6, 2023 at 3:39 PM roger popa wrote: > You can tell if exists an oficial Postgresql Certification issued by > postgresql.org ? > No. > Or others (like PearsonVue)? > EnterpriseDB has certifications. I think you can get some of them for free.

Re: Max effective number of CPUs that Postgresql can handle?

## Ron Johnson (ronljohnso...@gmail.com): > Like the Subject says, is there any point of diminishing returns at which > the Postmaster gets "too busy" to manage all the threads? It is possible to use 3-digit cores (i.e. 128, maybe more) quite efficiently. The rest of the system has to fit the

Re: Delete Account

On 12/6/23 08:16, Estevan Rech wrote: delete account, That is still unclear. If you mean unsubscribing from list then you need to follow the instructions here: https://lists.postgresql.org/unsubscribe/ If by removing data you mean your emails then read:

Re: PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res

On 12/6/23 04:21, Arne Henrik Segtnan wrote: Hi all, We are currently running Zabbix 5.0 with PostgreSQL 12, and history and trend data partitioning. History and trend data housekeeping has been disabled in Zabbix. In the PostgreSQL logs, we get the following error: 2023-12-06 09:12:47 CET

Re: Delete Account

delete account,

Re: Delete Account

On 12/6/23 02:45, Estevan Rech wrote: Hi, I want to delete my account (softr...@gmail.com ) and all data from https://www.postgresql.org/ Are you referring to this account: https://www.postgresql.org/account/login/?next=/account/ or

Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function

=?UTF-8?B?Um9tYW4gxaBpbmRlbMOhxZk=?= writes: > - ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function in all > PGSQL versions 14+, is it desired behavior? It's intentional to get some other benefits, if that's what you mean. See

Re: Trainning and Certification

There is no certification offered by the PostgreSQL Project, or PostgreSQL Global Development Group. ./daniel > On 5 Dec 2023, at 18:19, roger popa wrote: > > Hello, > > You can tell if exists an oficial Postgresql Certification issued by > postgresql.org ? > Or others (like

Re: GIN INdex is not used with && operator for a text array index

balasubramanian c r writes: > when Operator '@>' is used the index is used and the execution time is 60ms. Yeah ... note that it's predicted to return just one row, and that guess is correct: > Bitmap Heap Scan on public.address18 (cost=261.25..262.52 rows=1 width=4) > (actual

Max effective number of CPUs that Postgresql can handle?

PG 9.6.24 on an ESX VM with nproc=32 and RAM=132GB (We'll be on 14.latest hopefully by February.) Like the Subject says, is there any point of diminishing returns at which the Postmaster gets "too busy" to manage all the threads? (I'm not in control of the stack's architecture, so "change

Re: Store PDF files in PostgreDB

On Wed, Dec 6, 2023 at 9:39 AM Priyadharshini Vellaisamy < priya.cs...@gmail.com> wrote: > Hi Team, > > Please let m know can we store PDF files in PostgreDB ? > You can store *anything* up to 1GB in Postgresql using data type bytea. > If so, can we retrieve it effectively? > Effectively?

Store PDF files in PostgreDB

Hi Team, Please let m know can we store PDF files in PostgreDB ? If so, can we retrieve it effectively? Thanks, Priya

Trainning and Certification

Hello, You can tell if exists an oficial Postgresql Certification issued by postgresql.org ? Or others (like PearsonVue)? Training and Certification path, source doc ? Regards

GIN INdex is not used with && operator for a text array index

HI Team Sorry for the spam. We have Postgres DB where the list of addresses are stored and for a given complete address trigram of addresses are stored in a column which is a text array. after looking at the list of operators that are available for gin index I decided to use array_ops operator.

RE: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function

Hi Roman, We had the same problem and we had to create a SERVER (loopback) and use dblink in order to get in done within a Stored Procedure. I don’t know if this solution will work in your case but it could be something like this…. CREATE SERVER loopback_dblink FOREIGN DATA WRAPPER

PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res

Hi all, We are currently running Zabbix 5.0 with PostgreSQL 12, and history and trend data partitioning. History and trend data housekeeping has been disabled in Zabbix. In the PostgreSQL logs, we get the following error: 2023-12-06 09:12:47 CET [3509536-5] zabbix@postgres STATEMENT: select

Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function

Hello, we prepared a test case to demonstrate our case. TASK Update replicated db schema (add new table) without superuser privileges. PROBLEM Our steps work in PostgreSQL ver 12 but we get the following error in 15 --- ERROR: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function

Delete Account

Hi, I want to delete my account (softr...@gmail.com) and all data from https://www.postgresql.org/ Thanks