Re: What to do with tablespaces when upgrading to pg13 from pg1X?

2021-01-11 Thread James(王旭)
Got you, thanks a lot Bruce!     -- Original -- From:  "Bruce Momjian"https://momjian.us   EnterpriseDB https://enterprisedb.com   The usefulness of a cup is in its emptiness, Bruce Lee

Re: What to do with tablespaces when upgrading to pg13 from pg1X?

2021-01-11 Thread Bruce Momjian
On Tue, Jan 12, 2021 at 10:50:16AM +0800, James(王旭) wrote: > You mean PG_13_202007201 was created by PG 13 ? No, there isn't any other > clusters, maybe it was created by my previous failed attempts of upgrading. Yes, it had to be created by PG 13 --- it starts with PG_13, followed by the system c

Re: What to do with tablespaces when upgrading to pg13 from pg1X?

2021-01-11 Thread James(王旭)
You mean PG_13_202007201 was created by PG 13 ? No, there isn't any other clusters, maybe it was created by my previous failed attempts of upgrading. So it seems it should be ok that I issue a command like this  find . -name "PG_13*"|xargs rm -rf and then do upgrade again?   There should be a

Re: What to do with tablespaces when upgrading to pg13 from pg1X?

2021-01-11 Thread Bruce Momjian
On Tue, Jan 12, 2021 at 10:28:52AM +0800, James(王旭) wrote: > Hello, > I was planning to upgrade from 12 to 13 using this command: > > /usr/pgsql-13/bin/pg_upgrade -b /usr/pgsql-12/bin/ -B /usr/pgsql-13/bin/ > -d > /data/pg/ -D /pg/pgdata_13/ --jobs=10 > > > And I got this output: > >

What to do with tablespaces when upgrading to pg13 from pg1X?

2021-01-11 Thread James(王旭)
Hello, I was planning to upgrade from 12 to 13 using this command: /usr/pgsql-13/bin/pg_upgrade -b /usr/pgsql-12/bin/ -B /usr/pgsql-13/bin/ -d /data/pg/ -D /pg/pgdata_13/ --jobs=10 And I got this output: Checking for presence of required libraries                 ok Checking database user is the

Re: Static memory, shared memory

2021-01-11 Thread Jack Orenstein
 On Sat, Jan 9, 2021 at 12:18 PM Tom Lane wrote: > Jack Orenstein writes: > > I am writing a Postgres extension, and thought that I had memory > > corruption, (thanks for the --enable-cassert lead). I might, but It now > > looks like I need to understand the use of shared memory and locking in

Understanding GIN indexes

2021-01-11 Thread Jack Orenstein
I am building a new type, which will be indexed using a GIN index. Things are starting to work, and I am seeing queries use the index, call the partialMatch(), consistent(), and compare() functions, and return correct results. However, I am still unclear on some aspects of how partialMatch and con

Re: Define hash partition for certain column values

2021-01-11 Thread Ron
On 1/11/21 12:36 AM, Tom Lane wrote: =?utf-8?B?0JPQvtC70YPQsdC10LLQsCDQr9C90LA=?= writes: Hello, I've found in source code that there is a function satisfies_hash_partition(oid, modulus, remainder, column_values[]) which allows to check if the certain column value will be placed in the certa