Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-18 Thread Achilleas Mantzios
On 18/11/18 2:04 μ.μ., Gerhard Wiesinger wrote: 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

Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-18 Thread Gerhard Wiesinger
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

Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-18 Thread Martín Marqués
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

PostgreSQL MVCC and alternative REDO implementation - my thoughts

2018-11-17 Thread Gerhard Wiesinger
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