Last entries
-
postgres|postgresql|patroni - [s]
-
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
-
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;
-
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';
-
Keep Your postgres|postgresql Stable — Vacuum - [s]
-
postgres|postgresql > Understanding and Monitoring pg_stat_user_indexes - [s]
-
postgresPostgreSQL: Documentation: 17: ANALYZE - [s]
-
Installing local plugin via jenkins-cli - Stack Overflow - [s]
-
git|github > 'credential-manager' is not a git command - [s]
# Mac|MacOS /System/Volumes/Data/Users/$USER/.gitconfig
-
git|github - How to re-authorize the OAuth Application 'Git Credential Manager' - [s]
gh auth login
-
ubuntu|apt > apt-get update log /var/log/apt/term.log - [s]
-
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