Re: How to get the selectStatement parse tree info?

Hi, On Tue, Oct 25, 2022 at 01:38:09PM +0800, jack...@gmail.com wrote: > I'm reading this book https://www.interdb.jp/pg/pgsql03.html? I'm debugging > pg, but I can't get the parse tree like this: > https://files.slack.com/files-pri/T0FS7GCKS-F047H5R2UKH/1.png, can you give > me some ways to get t

How to get the selectStatement parse tree info?

I'm reading this book https://www.interdb.jp/pg/pgsql03.html? I'm debugging pg, but I can't get the parse tree like this: https://files.slack.com/files-pri/T0FS7GCKS-F047H5R2UKH/1.png, can you give me some ways to get that? I'm using vscode to debug, the watch info doesn't interest me, it gives

Re: possible bug

On 2022-Oct-21, Tom Lane wrote: > "David G. Johnston" writes: > > On Fri, Oct 21, 2022 at 4:52 PM Ravi Krishna wrote: > >> on a diff note, is the word memoize inspired from Perl Module memoize > >> which use to do the same thing. > > > It is a general functional programming concept - not sure o

Re: Explain returns different number of rows

Thanks for the clarification, Peter. On Sat, Oct 22, 2022, 05:32 Peter J. Holzer wrote: > On 2022-10-20 09:56:23 -0700, Christophe Pettus wrote: > > On Oct 20, 2022, at 09:52, Vince McMahon > wrote: > > > The number of rows are different. > > > > This isn't unexpected. EXPLAIN does not actua

Re: PostgreSql Service different path

On 2022-10-24 15:51:30 +0800, chris navarroza wrote: > sudo yum install postgresql14-server postgresql14-contrib [...] > /usr/pgsql-14/bin/initdb -D /home/dmartuser/pgsql/14/data > > and update the postgresql.conf to the new path, now when I start the service, > it has an error and when I check it

Re: PostgreSql Service different path

On Mon, Oct 24, 2022 at 6:38 AM chris navarroza wrote: > > I install postgresql14.5 with the following commands > > sudo yum install postgresql14-server postgresql14-contrib > > > sudo su postgres > > cd /tmp > > /usr/pgsql-14/bin/initdb -D /home/dmartuser/pgsql/14/data > > and update the postgres

GIN Index use statistic information?

Hi: I create a new type for myself and create a gin index for its array type. I want to know : 1. how to use statistic info in build index for a table? 2. how to use analyze to generate statistic information?

PostgreSql Service different path

Hi, I install postgresql14.5 with the following commands sudo yum install postgresql14-server postgresql14-contrib sudo su postgres cd /tmp /usr/pgsql-14/bin/initdb -D /home/dmartuser/pgsql/14/data and update the postgresql.conf to the new path, now when I start the service, it has an error

Re: Upgrading error

This is the log I got. - pg_upgrade run on Mon Oct 24 07:41:13 2022 - command: "/usr/pgsql-12/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/home/dmartuser/pgdata/data"

Re: Upgrading error

Hi, Thanks for the reply! Sorry I missed that line, but now I'm having new error. [root@datamartds tmp]# sudo su postgres bash-4.4$ cd /tmp bash-4.4$ /usr/pgsql-14/bin/pg_upgrade --old-datadir=/home/dmartuser/pgdata/data/ --new-datadir=/home/dmartuser/pgsql/14/data/ --old-bindir=/usr/pgsql-12/bi