Parallel Index Scan Implementation

Hi Postgresql Experts, We have a basic requirement where we need to implement the parallel index scan instead of parallel seq scan at table level. Please suggest the best way to do this. Postgresql DB Version : 12.6 Table size : 2-5 GB OS : Centos-7 RAM : 96 GB CPU : 32 shared_buffer=20GB Eff

XX001ERROR: found xmin from before relfrozenxid for pg_authid and pg_database

Hi, Good Morning... We are getting below issue on postgresql 9.6.8 version XX001ERROR: found xmin 3355284520 from before relfrozenxid 1097492040 XX001CONTEXT: automatic vacuum of table "xyz.pg_catalog.pg_authid" XX001ERROR: found xmin 3355284522 from before relfrozenxid 1097492055 XX001CONTEXT:

Pgbackrest version 2.28 Bug/Issue

Hi , We are getting the below issue while executing the backup through pgbackrest. 2021-03-02 02:10:01.620 P00 INFO: backup command begin 2.28: --archive-check --archive-copy --compress --db-timeout=7200 --log-level-console=detail --log-level-file=detail --log-level-stderr=detail --log-path=/ap

Re: Unable to execute Query in parallel for partitioned table

Hi Albe, We have checked as per your suggestion and we are good now. Thank you !!! On Thu, 11 Feb, 2021, 8:49 PM Brajendra Pratap, < brajendra.pratap...@gmail.com> wrote: > Hi Albe, > > Thank you so much for information, will check this and get back to you if > any help requ

Re: Unable to execute Query in parallel for partitioned table

09 +0530, Brajendra Pratap wrote: > > I am unable to execute the below in parallel plz suggest how can I > achieve parallelism here. > > > > select count(*) over () VIEWALLROWCOUNT,abc.*,ROW_NUMBER() OVER (order > by trn_transaction_date desc ) AS RowNumber from ( >

Unable to execute Query in parallel for partitioned table

Hi, I am unable to execute the below in parallel plz suggest how can I achieve parallelism here. select count(*) over () VIEWALLROWCOUNT,abc.*,ROW_NUMBER() OVER (order by trn_transaction_date desc ) AS RowNumber from ( select * from transactions where trn_store_date_id=20201202) abc; Query plan

Parallelism on Partitioning .

Hi , We are trying to assign the parallel worker or execute the query in parallel manner on partitioned Tables and partitioned master table but not able to do that ,could u plz suggest . Current Postgresql version :- 9.6 Fyi, We have tried with all parameters which can allow the parallel query e

Partitioned Table conversion to Non-Partition table in postgresql open source

Hi, Currently we are running on open-postgresql 9.6 version with some partitioned Table which we need to convert from Inheritance partitioning to declarative partitioning during migration to 12.3 open-postgresql version. Is there any safest and faster way to fulfill this requirement, Please sugge

Re: Profile Creation

Hi Adrian, Here the user profile means which contains the following functionality same as in EDB profile contains like password_verify_function, password_life_time, password_lock_time etc. Thanks, Singh On Sat, 3 Oct, 2020, 2:14 AM Adrian Klaver, wrote: > On 10/2/20 1:40 PM, Brajendra Pra

Profile Creation

Hi All, How can we create a user profile in open postgresql db? Thanks, Singh

DB upgrade version compatibility

Can we upgrade the 9.6version open source postgresql db directly to 12.3version ? Thanks and Regards, Singh

Re: Schema/ROLE Rename Issue

; On Wed, 2020-09-09 at 17:04 +0530, Brajendra Pratap Singh wrote: > > Recently we had renamed schema and role but it will not get reflect in > the object definitions ,plz suggest. > > > > OLD SCHEMA/ROLE - TEST11 > > NEW SCHEMA/ROLE - TEST > > > >

Schema/ROLE Rename Issue

Hi, Recently we had renamed schema and role but it will not get reflect in the object definitions ,plz suggest. OLD SCHEMA/ROLE - TEST11 NEW SCHEMA/ROLE - TEST But still we are that TEST11 is present in the definition of sone objects like procudure,functions,triggers etc, so how can we modify

Block Corruption Resolution

Hi , Is it possible to recover only corrupted blocks in postgresql versions 9.6/10/11/12? Is the pg_healer extension supported by postgresql or good for the corrupted block recovery? If yes then is this compatible with all postgresql versions 9.6/10/11/12? Thanks, Brajendra

Re: Wal_keep_segment value too high

. Third thing is the high value of wal_keep_segment anyhow affect the checkpoint operation ,dml operation,select query or data write operation from memory to disk? Thanks, Brajendra On Fri, 10 Jul, 2020, 5:44 PM Andreas Kretschmer, wrote: > On 10 July 2020 10:26:25 CEST, Brajendra Pratap Si

Wal_keep_segment value too high

Hi, What will happen if the wal_keep_segments value is too high ,is this affect the database performance anyhow like checkpoint and all or is there because of this any delay in the replication sync or wal records transfer from primary to replication postgresql db? Thanks, Brajendra

Postgresql Backup Encryption

Hi, Please let me know the way to encrypt/decrypt the postgresql backup uaing pg_dump and pgbackrest. Also let me know the other good possibility if any. Thanks, Singh

Re: Kerberos-Postgresql implementation for user authentication

: CentOS 6.9/7/8 Thanks, Brajendra On Thu, 9 Jul, 2020, 1:52 PM Niels Jespersen, wrote: > > > > > *Fra:* Brajendra Pratap Singh > *Sendt:* 9. juli 2020 09:05 > *Til:* pgsql-gene...@postgresql.org > *Emne:* Kerberos-Postgresql implementation for user authentication &g

Kerberos-Postgresql implementation for user authentication

Hi, Please share the steps to implement the Kerberos with postgresql for user authentication purpose. Also share the document if any. Thanks, Brajendra

restore_command for postgresql streaming replication

Hi, Please help us to configure the restore_command on postgresql replication server's recovery.conf file incase of ERROR: requested wal segment has already been removed on primary and when we have implemented pgbackrest on primary database. Primary database - archive_command = 'pgbackrest --sta

Check Replication lag status

Hi, If my primary postgresql database will crash and there will be some lag between primary and standby database then how to findout from standby side that till what duration data will be available on standby postgresql database? Thanks, Brajendra

Re: Postgresql HA Cluster

530, Brajendra Pratap Singh wrote: > > Is there any functionality present in postgresql for High Availability > Cluster where we can setup > > multiple nodes/instances in READ-WRITE mode for single database so that > incase of one node/instance > > failure it will automatically failo

Fwd: BUG #16513: Postgresql HA Cluster

Hi Team, Please help us on the below query . Thanks -- Forwarded message - From: Daniel Gustafsson Date: Sat, 27 Jun, 2020, 3:16 AM Subject: Re: BUG #16513: Postgresql HA Cluster To: , PostgreSQL mailing lists < pgsql-b...@lists.postgresql.org> > On 26 Jun 2020, at 16:10, PG B

Postgresql HA Cluster

Hi All, Is there any functionality present in postgresql for High Availability Cluster where we can setup multiple nodes/instances in READ-WRITE mode for single database so that incase of one node/instance failure it will automatically failover the traffic to 2nd node/instance (without failure or