some confusion about parallel insert select in postgres parallel dml develop

2024-04-10 Thread jiye
jobs, should we skip any parallel safty check about target relation and build parallel query plan directly ? could anyone give me some suggestion about this confusions. Best Regards Tomas Ji | | jiye | | jiye...@126.com |

confusion about Re: Write operations in parallel mode's update part.

2023-11-23 Thread jiye
tself combo cid mapping, and only other workers can not learn about that, so why those workers must know leader's combo cids? why those worker need see leader's updated tuples, could you give me some example cases or Unusual scenes for for this parallel update? | | jiye | | jiye...@126.com |

Is there any plan to support online schem change in postgresql?

2022-10-11 Thread jiye
Hi, As we know postgres using high level lock when do alter table or other ddl commands, It will block any dml operation, while it also will block by long term dml operation. Like what discuss as follow : https://dba.stackexchange.com/questions/293992/make-alter-table-wait-for-lock-without-bl

Re:Re: Is there any plan to support online schem change in postgresql?

2022-10-11 Thread jiye
11 18:05:01, "hubert depesz lubaczewski" wrote: >On Tue, Oct 11, 2022 at 05:43:03PM +0800, jiye wrote: >> As we know postgres using high level lock when do alter table or other ddl >> commands, >> It will block any dml operation, while it also will block by long te

confusion about this commit "Revert "Skip redundant anti-wraparound vacuums""

2023-06-04 Thread jiye
own", this lock down implict that autovacuum can make a dead lock problem ? 3. how to reproduce this lock down or autovacuum invalid issue, must be cluster enviroment ? so is there any body know these issuse or commits can give me some suggestion about my confusion. | | jiye | | jiye...@126.com |

Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums""

2023-06-07 Thread jiye
actually out test instance include 2aa6e331ead7f3ad080561495ad4bd3bc7cd8913 this commit, not yet reverted this commit. | | jiye | | jiye...@126.com | Replied Message | From | Julien Rouhaud | | Date | 6/7/2023 14:00 | | To | Robert Haas | | Cc | jiye , t...@sss.pgh.pa.us , pgsql

Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums""

2023-06-07 Thread jiye
down or does not work. | | jiye | | jiye...@126.com | Replied Message | From | Julien Rouhaud | | Date | 6/7/2023 15:36 | | To | jiye | | Cc | robertmh...@gmail.com , t...@sss.pgh.pa.us , pgsql-hackers@lists.postgresql.org | | Subject | Re: confusion about this commit "Revert