Re: Let's make PostgreSQL multi-threaded

2023-06-08 Thread Ilya Anfimov
On Wed, Jun 07, 2023 at 10:26:07AM +1200, Thomas Munro wrote: > On Tue, Jun 6, 2023 at 6:52???AM Andrew Dunstan wrote: > > If we were starting out today we would probably choose a threaded > > implementation. But moving to threaded now seems to me like a > > multi-year-multi-person project with

Re: PG11 to PG14 Migration Slowness

2023-01-12 Thread Ilya Anfimov
On Thu, Jan 12, 2023 at 02:45:41PM +0530, Vigneshk Kvignesh wrote: >Hi, > > I'm migrating our existing PG instances from PG11.4 to PG14.3. I >have around 5 Million Tables in a single database. When migrating using >pg_upgrade, its taking 3 hours for the process to

Re: Patch: Global Unique Index

2022-11-29 Thread Ilya Anfimov
On Fri, Nov 18, 2022 at 12:03:53PM +0300, Sergei Kornilov wrote: > Hello > Do we need new syntax actually? I think that a global unique index can be > created automatically instead of raising an error "unique constraint on > partitioned table must include all partitioning columns" I may

To add pg_temp schema description to schemas documentation

2022-05-11 Thread Ilya Anfimov
Good day. I've found that the pg_temp schema alias is mentioned in the description of the search_path variable, but is missing from the schemas documentation section. I think it would be good to have that there, as that section is mentioned as an extended reference for schemas.

Re: Add 64-bit XIDs into PostgreSQL 15

2022-01-16 Thread Ilya Anfimov
On Wed, Jan 05, 2022 at 06:51:37PM -0500, Bruce Momjian wrote: > On Tue, Jan 4, 2022 at 10:22:50PM +, Finnerty, Jim wrote: [skipped] > > with the "double-xmax" representation. This would eliminate a whole > > class of coding errors and would make the code dealing with 64-bit > > XIDs

Re: [RFC] ASOF Join

2021-11-22 Thread Ilya Anfimov
On Mon, Nov 22, 2021 at 03:44:37PM +0300, Alexander Kuzmenkov wrote: > On 21.11.2021 07:53, Ilya Anfimov wrote: > > DISCLAIMER: I am both seeing this first time and I don't have a > > good understanding of the PosgreSQL development practices. > > > pure evil >

Re: [RFC] ASOF Join

2021-11-20 Thread Ilya Anfimov
On Thu, Nov 18, 2021 at 05:11:16PM +0300, Alexander Kuzmenkov wrote: > Hi hackers, > > There was some interest in implementing ASOF joins in Postgres, see > e.g. this prototype patch by Konstantin Knizhnik: >

Re: Should AT TIME ZONE be volatile?

2021-11-12 Thread Ilya Anfimov
On Thu, Nov 11, 2021 at 09:52:52AM -0500, Tom Lane wrote: > Robert Haas writes: > > I'm not really convinced that ICU is better, either. I think it's more > > that it isn't used as much. > > Well, at least ICU has a notion of attaching versions to collations. > How mindful they are of bumping