I hereby claim:
- I am dbness on github.
- I am dbness (https://keybase.io/dbness) on keybase.
- I have a public key whose fingerprint is 660E B59D 0B1E 88E3 37E4 5BE8 F7C3 0F4E 1E3B B078
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
Are you good at organizing life? Then do I ever have a challenge for you. I'm looking for a part-time personal assistant. Here are some things I need:
Because my work, speaking and side projects tend to revolve around software design/development, technology education and diversity within the industry, having an interest and/or experience in these areas would be beneficial. I'm also more than willing to offer mentorship.
def child? | |
self.connection.select_value("SELECT CASE WHEN tableoid::regclass::text = 'child_table' THEN 'true' ELSE 'false' END as child FROM parent_table WHERE id = #{self.id};") | |
end |
kern.sysv.shmmax=974172160 | |
kern.sysv.shmmin=1 | |
kern.sysv.shmmni=256 | |
kern.sysv.shmseg=64 | |
kern.sysv.shmall=974172160 |
# ----------------------------- | |
# PostgreSQL configuration file | |
# ----------------------------- | |
# | |
# This file consists of lines of the form: | |
# | |
# name = value | |
# | |
# (The "=" is optional.) Whitespace may be used. Comments are introduced with | |
# "#" anywhere on a line. The complete list of parameter names and allowed |
--Updates all serial sequences for ID columns only | |
CREATE OR REPLACE FUNCTION update_id_sequences() | |
RETURNS boolean AS | |
$BODY$ | |
DECLARE table_record record; | |
DECLARE table_name text; | |
DECLARE update_sql text; | |
BEGIN | |
FOR table_record IN SELECT pc.relname FROM pg_class pc WHERE pc.relkind = 'r' AND EXISTS (SELECT 1 FROM pg_attribute pa WHERE pa.attname = 'id' AND pa.attrelid = pc.oid) LOOP |
SELECT datname as database | |
, procpid as process_id | |
, current_query | |
, (current_timestamp - query_start) as duration | |
FROM pg_stat_activity | |
ORDER BY database, duration desc |