xluffy

https://docs.redhat.com/en/documentation/red_hat_enterprise_linux/9/html/monitoring_and_managing_system_status_and_performance/tuning-the-network-performance_monitoring-and-managing-system-status-and-performance

``` SELECT date_trunc('minute', TO_TIMESTAMP(created_at)) AS minute, COUNT(DISTINCT player_id) AS CCU FROM raw_events GROUP BY 1 ORDER BY COUNT(DISTINCT player_id) DESC LIMIT 10; ``` - `date_trunc` sẽ "làm tròn" dữ liệu...

``` SELECT relname, n_dead_tup, n_live_tup, (NULLIF(n_dead_tup, 0) / n_live_tup) AS ratio FROM \ pg_stat_all_tables WHERE relname NOT LIKE '%pg_%' ORDER BY n_dead_tup DESC LIMIT 10; relname | n_dead_tup | n_live_tup...

https://gotemplate.io/

Decompile APK and add `network-security-config` We go into the Manifest.xml file & scroll down to the `` tag & we are going to add the following line if it isn't...

In most cases, all a COMMIT has to do is - set the two bits for the transaction in the commit log to TRANSACTION_STATUS_COMMITTED (0b01) (persisted in pg_xact) - if...

- https://pranitha.rs/posts/rust-ipc-ping-pong/ - https://3tilley.github.io/posts/simple-ipc-ping-pong/

``` do $do$ declare i int; begin for i in 0..99 loop execute format( $sql$ create table partitioned_table_%s partition of partitioned_table for values from (%s) to (%s) $sql$, i, i...

It is possible to configure streaming replication with a delay using`recovery_min_apply_delay`. **However, there are a few pitfalls regarding replication slots, hot standby feedback, and others that one needs to be...

[Better Encrypted Group Chat](https://blog.trailofbits.com/2019/08/06/better-encrypted-group-chat/)