| BML-S | Help Login

Last entries

    20241120.0951

  1. postgres|postgresql|patroni - [s]

    2. 20241114.1119

  2. bash - Tee resets exit status is always 0 - [s]

    # Example: wrap git command to add trace logging cat << 'EOF' > ./git #!/usr/bin/env bash echo "# $(date --rfc-3339=seconds) Executing git" >> /tmp/git_trace.out export GIT_TRACE=2 GIT_CURL_VERBOSE=2 GIT_TRACE_SETUP=2 /usr/bin/git "$@" 2>/tmp/git_trace.out | tee -a /tmp/git_trace.out exit ${PIPESTATUS[0]} EOF chmod a+x ./git

    3. 20241113.0818

  3. postgres|PostgreSQL > assign variables with SELECT column INTO TEMP variable_tbl - [s]

    select role_id into TEMP role_ids from role order by random() limit 11; select member_name into TEMP member_names from membership_mapping where member_type = 'USER' order by random() limit 1; EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM membership_mapping t0 WHERE (((t0.member_name = (select member_name from member_names) OR LOWER(t0.member_name) = LOWER((select member_name from member_names)) OR UPPER(t0.member_name) = UPPER((select member_name from member_names))) AND t0.member_type = 'USER' OR t0.member_name IN ('(all-authenticated-users)') AND t0.member_type = 'GROUP') AND t0.role_id IN (select role_id from role_ids)) ORDER BY t0.context_id ASC, t0.role_id ASC LIMIT 500000;

    4. 20241112.1529

  4. postgres > Optimizing PostgreSQL Performance: How the Fill Factor Setting improve I/O performance - [s]

    ALTER TABLE customer_orders SET (fillfactor = 75); # https://www.cybertec-postgresql.com/en/estimating-table-bloat/ CREATE EXTENSION IF NOT EXISTS pgstattuple; # https://www.postgresql.org/docs/14/pgstattuple.html # the last two values are approx_free_space and approx_free_percent SELECT relnamespace::regnamespace::text as ns, relname AS table_name, pgstattuple_approx(oid) AS table_stats FROM pg_class WHERE relkind = 'r';

    5. 20241103.0930

  5. Keep Your postgres|postgresql Stable — Vacuum - [s]

    6. 20241103.0927

  6. postgres|postgresql > Understanding and Monitoring pg_stat_user_indexes - [s]

    7. 20241029.1130

  7. postgresPostgreSQL: Documentation: 17: ANALYZE - [s]

    8. 20241029.1017

  8. Installing local plugin via jenkins-cli - Stack Overflow - [s]

    9. 20241028.0813

  9. git|github > 'credential-manager' is not a git command - [s]

    # Mac|MacOS /System/Volumes/Data/Users/$USER/.gitconfig

    10. 20241028.0803

  10. git|github - How to re-authorize the OAuth Application 'Git Credential Manager' - [s]

    gh auth login

    11. 20241024.1507

  11. ubuntu|apt > apt-get update log /var/log/apt/term.log - [s]

    12. 20241024.1032

  12. postgres|postgresql > all permissions|privileges - [s]

    ---- nxrm=# \dn+ List of schemas Name | Owner | Access privileges | Description --------+-------+-------------------+------------- public | nexus | nexus=UC/nexus | (1 row) nxrm=# \dp mytable Access privileges Schema | Name | Type | Access privileges | Column access privileges --------+---------+-------+-----------------------+-------------------------- public | mytable | table | miriam=arwdDxt/miriam | col1: : =r/miriam : miriam_rw=rw/miriam : admin=arw/miriam (1 row) ---- rolename=xxxx -- privileges granted to a role =xxxx -- privileges granted to PUBLIC r -- SELECT ("read") w -- UPDATE ("write") a -- INSERT ("append") d -- DELETE D -- TRUNCATE x -- REFERENCES t -- TRIGGER X -- EXECUTE U -- USAGE C -- CREATE c -- CONNECT T -- TEMPORARY arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects) * -- grant option for preceding privilege /yyyy -- role that granted this privilege

[s] public (12)