Re: Hash Index on Partitioned Table

2023-06-01 Thread Marc Millas
t I'm ok now :-) > > > > Thanks again, > > Peter > > > > > > -Original Message- > From: "Tom Lane" > Sent: Wednesday, May 31, 2023 10:07am > To: "peter.boris...@kartographia.com" > Cc: pgsql-general@lists.postgresq

Re: Hash Index on Partitioned Table

2023-05-31 Thread peter.boris...@kartographia.com
day, May 31, 2023 10:07am To: "peter.boris...@kartographia.com" Cc: pgsql-general@lists.postgresql.org Subject: Re: Hash Index on Partitioned Table "peter.boris...@kartographia.com" writes: > I have a rather large database with ~250 billion records in a partitioned

Re: Hash Index on Partitioned Table

2023-05-31 Thread Tom Lane
"peter.boris...@kartographia.com" writes: > I have a rather large database with ~250 billion records in a partitioned > table. The database has been running and ingesting data continuously for > about 3 years. > I had a "regular" BTree index on one of the fields (a unique bigint column) > but