Re: [Beginner Question]Is there way to test the postgres's kernel function?

On Mon, Jul 24, 2023 at 5:43 PM Wen Yi wrote: > > Hi community, > I am learning the kernel of the postgres, and I want to test the > make_relative_path function to know what it's operational principle.(I can > read it's code, and I want to actually run it) > But I really don't know how to do it,

Difference in the tablespace folders on primary and secondary nodes

I recently set up a Postgres15 master-slave (Primary-secondary) cluster on 2 nodes. At the time of starting, I ensured that data files are exactly the same on both the nodes. The size of the DB is 1.5TB. The directory structure on both nodes looks as follows: ``` - /PROD/datadg/ | |-> /PROD

Re: suggestion about time based partitioning and hibernate

On Tue, Jul 18, 2023 at 8:18 AM Luca Ferrari wrote: > Dear all, > I'm looking for ideas here, and it could be someone already stepped > into declarative partitioning of an existing database where Hibernate > (a Java ORM) handles the tables. > The situation is as follows: > > create table foo( id

Re: Difference in the tablespace folders on primary and secondary nodes

Greetings, * Abhishek Bhola (abhishek.bh...@japannext.co.jp) wrote: > I recently set up a Postgres15 master-slave (Primary-secondary) cluster on > 2 nodes. At the time of starting, I ensured that data files are exactly the > same on both the nodes. The size of the DB is 1.5TB. > The directory stru

Re: Re: How to improve the performance of my SQL query？

On Thu, 20 Jul 2023 at 23:36, gzh wrote: > > > Thank you very much for taking the time to reply to my question. > > > Sorry, I provided incorrect information. > > The index also does not work in the following query statement. > > > > select COUNT(ET_CD) > > from TBL_SHA > > WHERE MS_CD = '009' > >

Re: How to improve the performance of my SQL query？

On Fri, 21 Jul 2023 at 13:44, gzh wrote: > > The definitions of the columns used in SQL are as follows. > > TBL_SHA > ms_cd character(6) NOT NULL -- PRIMARY KEY > et_cd character(8) > etrys character(8) > explain analyze > select COUNT(ET_CD) > from TBL_SHA > WHERE TBL_SHA.MS_CD = 'MLD009'

Error 503 Backend fetch failed

I am interning at a company. I was using Python to download your mail lists, but it seems that there was an unwanted situation, and you have restricted access to log in. However, I read that you are not against the storage of emails on your website. Could you please explain why access was restri

Re: Error 503 Backend fetch failed

Greetings, * Sabri Taner Burak ALTINDAL (s...@protonmail.com) wrote: > I am interning at a company. I was using Python to download your mail lists, > but it seems that there was an unwanted situation, and you have restricted > access to log in. However, I read that you are not against the storag

Re: Nu-B here

Please note the following : /psql (12.15 (Debian 12.15-1.pgdg120+1 /Thanks in advance // On 7/20/23 10:41 a.m., Adrian Klaver wrote: On 7/19/23 23:32, Alban Hertroys wrote: On 20 Jul 2023, at 02:36, Amn Ojee Uw wrote: After this command 'sudo -u postgres psql' I get this message : could not

Re: Difference in the tablespace folders on primary and secondary nodes

Hi Stephen Thank you for your reply. Basically, this is not a valid way to perform a backup/restore of PG. Is it not valid only for PG 15 or even for earlier versions? I have always referred to this https://www.postgresql.org/docs/8.1/backup-online.html > better, use an existing well maintaine

Re: Difference in the tablespace folders on primary and secondary nodes

Hi Stephen I got the latest documentation and understood that I was supposed to run `select * from pg_backup_stop();` and store the labelfile output to a file in the data directory of the secondary node