PostgreSQL MVCC and alternative REDO implementation - my thoughts
Hello, I just read that blog article and I think switching to REDO logic is not a good idea. REDO has the following disadvantages, think of the following scenario: Delete a lot of rows having 1 petabyte of data. 1.) PostgreSQL: has just do mark the rows as deleted, afterwards they have to be cleaned up by (auto)vacuum. No data has to be written! Will be quite fast. 2.) REDO logic: The deleted 1 petabyte of data (!) has to written for crash consistency reasons at least into REDO files. And that might take time, hours, days, weeks, month. So please don't give up the implementation of PostgreSQL MVCC. https://wiki.postgresql.org/wiki/MVCC What's the plan? Thank you. Ciao, Gerhard
Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts
On 18.11.2018 12:14, Martín Marqués wrote: El 18/11/18 a las 04:49, Gerhard Wiesinger escribió: Hello, I just read that blog article and I think switching to REDO logic is not a good idea. I think you got it the other way around. Postgres implementes REDO, that is, move forward by REDOing the changes which are stored in WAL files BTW, could you point us to the blog you read this? Maybe you got REDO and UNDO mixed up. Yes, I ment UNDO ... Link is here: https://severalnines.com/blog/five-cool-things-i-learned-postgresql-conference-europe-2018 sunday morning, too early :-) Ciao, Gerhard
Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo
Hello, Any chance to get Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo quickly? Thnx. Ciao, Gerhard
Re: Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo
Hello, I'm talking about PGDG maintained repository (and not Fedora maintained) where pgpool is located: https://download.postgresql.org/pub/repos/yum/common/fedora/fedora-40-x86_64/ https://download.postgresql.org/pub/repos/yum/common/fedora/fedora-41-x86_64/ Currently installed package: pgpool-II-4.5.4-1PGDG.f40.x86_64 Thnx. Ciao, Gerhard On 05.12.2024 08:43, Christiano Anderson wrote: Hi, I'm Fedora package maintainer (but not of the pgpool package). It's the package maintainer's responsibility to update the package in different Fedora versions (40, 41 and Rawhide). There is already a ticket for this update: https://bugzilla.redhat.com/show_bug.cgi?id=2305049 Maybe it's a matter of time until the new version is available, but you can also contact the developer directly: https://src.fedoraproject.org/rpms/postgresql-pgpool-II Best, Christiano On 05/12/2024 07:16, Gerhard Wiesinger wrote: Hello, Any chance to get Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo quickly? Thnx. Ciao, Gerhard
Re: Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo
On 28.12.2024 18:49, Devrim Gündüz wrote: Hi, On Thu, 2024-12-05 at 07:16 +0100, Gerhard Wiesinger wrote: Any chance to get Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo quickly? FWIW I updated the packages in PGDG repo a couple of weeks back. Regards, Yes, thnk. Works well. Ciao, Gerhard
