Nikolay Samokhvalov

Results 43 comments of Nikolay Samokhvalov

In Postgres, you can significantly speed it up just with 2 trivial steps: 1) Use `SELECT ... FOR UPDATE SKIP LOCKED` instead of just `SELECT ... FOR UPDATE` (the code...

@albus522 thank you for your response, but it was not a change request, it was advice for those who uses DJ with Postgres (I hope with 9.6 or at least...

@albus522 isn't it time to reconsider it? > SKIP LOCKED was introduced in postgres 9.5, so that feature requires a relatively new postgres install Less than in one year, 9.5...

> optional timeout argument which disconnects database on timeout and prevents new connections from being established It would be great to see as well a few params that would allow...

– not critical in our case since DBLab Engine doesn't use authorization plugins (per @agneum)

@rjuju thank you for your very quick response! > ...You will only see the data when everything runs smoothly and ignore data during the incident, leading to totally unreliable metrics....

Here is reliable reproduction: > "\l+" is valid sql in postgres; execute it using functions.executeSql. (just in case: this was crafted to break things, Postgres' SQL doesn't support `\l+` of...

@yuriyriznyk can you describe what do you have during the attempts of `backup-push` (and `wal-push`, separately)? What do you see in the logs?

@x4m I've noticed, of course :) Still, would be good to have the details.

> Why do the macOS installation instructions recommend ImHex, which AFAICT also doesn't know anything about the XML format generated by pg_hexedit? I would quite like to be able to...