Re:Re: equivalent thing of mtr in mysql

2022-07-15 Thread merryok
I'm sorry, first time to post a thread. mtr is short for mini-transaction. About mtr in mysql, we can refer to https://dev.mysql.com/doc/refman/8.0/en/glossary.html or https://dev.mysql.com/blog-archive/mysql-8-0-new-lock-free-scalable-wal-design/ So an insert in mysql, wrapped in a user t

could not link file in wal restore lines

2022-07-15 Thread Zsolt Ero
Hi, I'm testing pgbackrest restore. It works well, but in the pg logs I get the following lines: could not link file "pg_wal/000101560098" to "pg_wal/00010157006E": File exists In total, I get 18 lines of "could not link file" and 932 lines of "restored log file" lines.

Re: About revoking large number of privileges; And the PUBLIC role.

2022-07-15 Thread Stephen Frost
Greetings, * Dominique Devienne (ddevie...@gmail.com) wrote: > So my goal is to delete all those "db specific" ROLEs, then the DB > with all its schemas. If you want to drop the database anyway.. then why not simply do that first? Nothing can be connected to a DB that's being dropped and we don'

Proposal to introduce a shuffle function to intarray extension

2022-07-15 Thread Martin Kalcher
Dear list, i am dealing with an application that processes fairly large arrays of integers. It makes heavy use of the intarray extension, which works great in most cases. However, there are two requirements that cannot be addressed by the extension and are rather slow with plain SQL. Both can