http://search.osakos.com/rss.php http://search.osakos.com/rss.php en-us Thu, 21 Nov 2024 06:57:43 GMT Thu, 21 Nov 2024 06:57:43 GMT http://search.osakos.com/cache.php?key=43086f80927ad690d63ff38977ccea2a&uri=https%3A%2F%2Fmsutic.blogspot.com%2F2021%2F11%2Fdeploying-postgresql-140-for-high.html http://search.osakos.com/cache.php?key=43086f80927ad690d63ff38977ccea2a Wed, 20 Nov 2024 00:51:18 GMT http://search.osakos.com/cache.php?key=8f753e5be84dbc51ef04b8c3366f9265&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F35842600%2Ftee-resets-exit-status-is-always-0 http://search.osakos.com/cache.php?key=8f753e5be84dbc51ef04b8c3366f9265 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]]> Thu, 14 Nov 2024 02:19:42 GMT http://search.osakos.com/cache.php?key=c9aad1cfe624e98b44df4786197f1816&uri=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fsql-selectinto.html http://search.osakos.com/cache.php?key=c9aad1cfe624e98b44df4786197f1816 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;

]]> Tue, 12 Nov 2024 23:18:41 GMT http://search.osakos.com/cache.php?key=d8954f22c2221471745a527356a8db64&uri=https%3A%2F%2Fmedium.com%2F%40wasiualhasib%2Foptimizing-postgresql-performance-how-the-fill-factor-setting-improve-i-o-performance-00091e5c951c http://search.osakos.com/cache.php?key=d8954f22c2221471745a527356a8db64
# 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';]]> Tue, 12 Nov 2024 06:29:47 GMT http://search.osakos.com/cache.php?key=4b6dcb03088204337196bc4052f38647&uri=https%3A%2F%2Fmedium.com%2Ftom-tech%2Fkeep-your-postgres-stable-vacuum-e27e671a6e68 http://search.osakos.com/cache.php?key=4b6dcb03088204337196bc4052f38647 Sun, 03 Nov 2024 00:30:15 GMT http://search.osakos.com/cache.php?key=dbbb22873819212a48af35bb062d6ab0&uri=https%3A%2F%2Fmohyusufz.medium.com%2Funderstanding-and-monitoring-pg-stat-user-indexes-in-postgresql-when-to-drop-unused-indexes-fe2fc15f0786 http://search.osakos.com/cache.php?key=dbbb22873819212a48af35bb062d6ab0 Sun, 03 Nov 2024 00:27:50 GMT http://search.osakos.com/cache.php?key=2e27861bc61e92de0344e7b98922c72a&uri=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fsql-analyze.html http://search.osakos.com/cache.php?key=2e27861bc61e92de0344e7b98922c72a Tue, 29 Oct 2024 02:30:28 GMT http://search.osakos.com/cache.php?key=660212e380b0729d4be9942c70c9e3a0&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F52930914%2Finstalling-local-plugin-via-jenkins-cli http://search.osakos.com/cache.php?key=660212e380b0729d4be9942c70c9e3a0 Tue, 29 Oct 2024 01:17:38 GMT http://search.osakos.com/cache.php?key=f9b873959c2f2840acf8403397e9cf04&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F71941020%2Fcredential-manager-is-not-a-git-command http://search.osakos.com/cache.php?key=f9b873959c2f2840acf8403397e9cf04 /System/Volumes/Data/Users/$USER/.gitconfig]]> Sun, 27 Oct 2024 23:13:58 GMT http://search.osakos.com/cache.php?key=225480c23b0d69c723d4555f22240657&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F66475833%2Fhow-to-re-authorize-the-oauth-application-git-credential-manager http://search.osakos.com/cache.php?key=225480c23b0d69c723d4555f22240657 Sun, 27 Oct 2024 23:03:46 GMT http://search.osakos.com/cache.php?key=cb9fc241c58805032fc9537677646d7d&uri=https%3A%2F%2Faskubuntu.com%2Fquestions%2F425809%2Fwhere-are-the-logs-for-apt-get http://search.osakos.com/cache.php?key=cb9fc241c58805032fc9537677646d7d Thu, 24 Oct 2024 06:07:31 GMT http://search.osakos.com/cache.php?key=38e88b36f4975080fd2fd018077ebe57&uri=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F9.1%2Fsql-grant.html http://search.osakos.com/cache.php?key=38e88b36f4975080fd2fd018077ebe57 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]]> Thu, 24 Oct 2024 01:32:52 GMT