Re: PgbackRest PointTIme Recovery : server unable to start back

tion privilege. > local replication all peer > hostreplication all 10.10.20.7/32 > scram-sha-256 > hostreplication all 127.0.0.1/32ident > hostreplication all ::1/128

Re: Slow performance

. Regards, Ikram On Fri, Jul 26, 2024 at 11:05 AM sivapostg...@yahoo.com < sivapostg...@yahoo.com> wrote: > I've only one instance of PG in that server. Means only one > postgresql.conf for both databases. > > > On Friday, 26 July, 2024 at 11:12:34 am IST, Muhammad Ikram < &g

Re: Slow performance

t; NULL) OR (examstudentstatus = ANY ('{R,S,W}'::bpchar[])))" > " -> Index Scan using cl_subject_ix3 on > cl_subject c (cost=0.28..0.32 rows=1 width=53) (actual time=0.006..0.006 > rows=1 loops=326)" > "Index Cond: (((companycode)::text = > '100'::text) AND ((subjectcode)::text = (a.subjectcode)::text))" > "-> Index Scan using ""cl_student_internal_mark_IX"" > on cl_student_internal_mark m (cost=0.42..2.94 rows=1 width=97) (actual > time=0.010..0.010 rows=1 loops=326)" > " Index Cond: (((companycode)::text = > (a.companycode)::text) AND ((companycode)::text = '100'::text) AND > ((subjectcode)::text = (a.subjectcode)::text) AND > ((registrationnumber)::text = (a.registrationnumber)::text))" > " Filter: (((departmentheaderfk)::text = > '04DF8BD89D0844DD4D8AA151EFB28657'::text) AND ((levelfk)::text = > '37A9BEC2638844FFD5B1422D83E70EF3'::text))" > " -> Index Scan using ""cl_student_semester_subject_IX1"" on > cl_student_semester_subject p (cost=0.42..3.09 rows=1 width=60) (actual > time=0.010..0.010 rows=1 loops=326)" > "Index Cond: (((companycode)::text = '100'::text) AND > ((subjectcode)::text = (a.subjectcode)::text) AND > ((registrationnumber)::text = (a.registrationnumber)::text) AND (semester = > a.semester))" > "Filter: ((examheaderfk)::text = > 'BA80952CFF8F4E1C3F9F44B62ED9BF37'::text)" > "-> Seq Scan on co_company_branch q (cost=0.00..1.01 rows=1 > width=276) (actual time=0.000..0.000 rows=1 loops=326)" > "Planning Time: 15.581 ms" > "Execution Time: 19.546 ms" > > > The query when run against DB1 takes around 7 min 32 seconds. > The same query when run against DB2 takes around 124 msec. > > Same computer, same PG cluster, same query. > Why it takes so much time when run against DB1 (client_db)? > > Already executed vacuum against client_db database. > > Any help is really appreciated. > > Happiness Always > BKR Sivaprakash > > -- Muhammad Ikram

Re: PgbackRest PointTIme Recovery : server unable to start back

0719-123408D, 20240719-122703F_20240723-110212I > > incr backup: 20240719-122703F_20240724-094727I > timestamp start/stop: 2024-07-24 09:47:27+05:30 / 2024-07-24 > 09:47:30+05:30 > wal start/stop: 0009003D / > 0009003D > database size: 62MB, database backup size: 11.5MB > repo1: backup size: 72KB > backup reference list: 20240719-122703F, > 20240719-122703F_20240719-123408D, 20240719-122703F_20240723-110212I, > 20240719-122703F_20240723-141818 > > > > -- Muhammad Ikram

Re: autovacuum_vacuum_cost_delay

if operations are more update/delete intensive. Dead tuples and bloat will take longer to be cleaned up. It can be beneficial for performance of other database operations, especially if your system is I/O-bound. Can also be helpful when system resources are less Regards, Muhammad Ikram Bitnine Global

Re: Load a csv or a avro?

, Muhammad Ikram On Fri, Jul 5, 2024 at 3:03 PM Josef Šimánek wrote: > pá 5. 7. 2024 v 11:08 odesílatel sud napsal: > > > > Hello all, > > > > Its postgres database. We have option of getting files in csv and/or in > avro format messages from another system to load i

Re: Question on partman extension while relation exist

Hi, Sorry for late reply, I think you will having some script that drops and creates daily partitions etc, command for disabling/removing any constraint can be placed before these statements so that when the script runs it does the needful. Regards, Muhammad Ikram Bitnine global On Tue, Jul 2

Re: Question on partman extension while relation exist

Hi Yudhi, I think disabling foreign keys before maintenance will help. Regards, Muhammad Ikram Bitnine global On Tue, Jul 2, 2024 at 11:41 AM yudhi s wrote: > Hello All, > In postgres we are seeing issues during automatic partition maintenance > using pg_partman extension. So

Re: Replication After manual Failover

Hi, Please reinitialize using pg_basebackup or use pg_rewind Muhammad Ikram Bitnine Global On Tue, 25 Jun 2024 at 22:20, Yongye Serkfem wrote: > Hello Engineer, > Below is the error message I am getting after failing over to the standby > and reconfiguring the former master a

Re: Re: Re: How to use createdb command with newly created user?

ing lower case won't cause any issue (IMO) as this is the default PG case. Regards, Muhammad Ikram, Bitnine Global On Mon, Jun 24, 2024 at 8:36 AM 毛毛 wrote: > > > Thank you for your advice. > > .pgpass file would help a lot. > > > I recently started to writing SQL on P

Re: Upgrade PG from 12 to latest

explained slowness, and performance issues were only > resolved via a downgrade. Do you have any upgrade docs or recommendations > you can share about the upgrade process before I try to go on the journey? > > > Thank you, > -Doron > > -- Muhammad Ikram

Re: pg_dump restores as expected on some machines and reports duplicate keys on others

and fails on another, if there were some locale difference then it must have failed with a different reason, not the duplicates Perform a clean up and try again. Hope it succeeds. Regards, Muhammad Ikram Bitnine Global. On Sun, Jun 23, 2024 at 2:59 AM Adrian Klaver wrote: > On 6/22/24 10:01, Shah

Re: TOAST Table / Dead Tuples / Free Pages

Hi Shenavai, Here are some more options.. VACUUM VACUUM FULL You may also reindex to reclaim space REINDEX TABLE REINDEX INDEX Regards, Muhammad Ikram Bitnine On Thu, Jun 13, 2024 at 1:09 PM Kashif Zeeshan wrote: > Hi > > You can use the CLUSTER command, which will p

Re: Oracle to Postgres - Transform Hash Partition

=# postgres=# postgres=# INSERT INTO idev.assessment_result_2023_dab_part SELECT * FROM idev.temp_assessment_result_2023_dab; INSERT 0 0 postgres=# postgres=# DROP TABLE idev.temp_assessment_result_2023_dab; DROP TABLE postgres=# postgres=# Regrads, Muhammad Ikram bitnine On Thu, Jun 6, 2024 at 11

Re: Updating 457 rows in a table

Hi Rich, Based on what I could understand is, here is an example UPDATE employees SET salary = salary + 500 WHERE department_id = 'Sales'; Sorry, if I misunderstood your question. Regards, Muhammad Ikram Bitnine On Sun, May 19, 2024 at 9:54 PM Rich Shepard wrote: > Searching the postgre

Re: Identity column data type difference in PostgreSQL and Oracle

Thanks for the advice. On Fri, 3 May 2024 at 16:09, Peter Eisentraut wrote: > On 03.05.24 12:57, Muhammad Ikram wrote: > > Tables which have an identity column in Oracle when migrated to > > PostgreSQL, the data type of Identity column is changed to bigint from > >

Identity column data type difference in PostgreSQL and Oracle

), transaction_date DATE, store_id NUMBER ); CREATE TABLE Sales_Details ( *transaction_id* NUMBER, item VARCHAR2(100), quantity NUMBER, price NUMBER, CONSTRAINT fk_transaction_id FOREIGN KEY (transaction_id) REFERENCES Sales(transaction_id) ); -- Regards, Muhammad Ikram

Re: Ora2pg Delta Migration: Oracle to PostgreSQL

e is > implemented? (It wasn't when I last used it in 2022.) > > -- Muhammad Ikram