hanefi

t

pg_extension_name: citus pg_extension_version: 11.1-1 pg_readme_generated_at: 2023-01-30 17:35:52.80893+03 pg_readme_version: 0.5.5

Citus distributed database

hanefi

MIT License

Copyright (c) 2018 Noel Bundick

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

hanefi

-- when we have INSERT INTO dist SELECT stable_func() from dist; the function is evaluated on the coordinator
-- for  INSERT INTO local SELECT stable_function from dist; the function is evaluated on the workers.
-- it seems acceptable to me, check with the team



CREATE OR REPLACE FUNCTION evaluate_on_master()
RETURNS int LANGUAGE plpgsql STABLE
AS $function$
BEGIN

hanefi

Instructions to downgrade from v9.4.0 to 9.3.x:

1. Install Citus v9.3.x
2. Copy citus--9.4-1--9.3-2.sql to /share/extension/citus--9.4-1--9.3-2.sql
3. Restart PostgreSQL
4. Run: ALTER EXTENSION citus UPDATE;
5. Delete /share/extension/citus--9.4-1--9.3-2.sql

Instructions to downgrade from v9.4.0 to 9.2.4:

hanefi

SELECT count(*) FROM users_table;

SELECT pg_sleep((random() * 10)::int), count(*) from users_Table;

SELECT pg_sleep(2), count(*) from users_Table;

SET citus.force_max_query_parallelization TO ON;
SELECT count(*) FROM users_table;

SET citus.force_max_query_parallelization TO ON;

hanefi

### PowerShell template profile 
### Version 1.03 - Tim Sneath <[email protected]>
### From https://gist.github.com/timsneath/19867b12eee7fd5af2ba
###
### This file should be stored in $PROFILE.CurrentUserAllHosts
### If $PROFILE.CurrentUserAllHosts doesn't exist, you can make one with the following:
###    PS> New-Item $PROFILE.CurrentUserAllHosts -ItemType File -Force
### This will create the file and the containing subdirectory if it doesn't already 
###
### As a reminder, to enable unsigned script execution of local scripts on client Windows, 

hanefi

#!/bin/bash
sudo apt update

# Grub updates scare me, so i'll just keep outdated packages for now
# sudo apt upgrade -y

sudo apt install -y bison clang flex g++ gcc htop libreadline-dev \
                    llvm-6.0-dev make zlib1g-dev

curl -L https://iterm2.com/shell_integration/install_shell_integration_and_utilities.sh | bash

hanefi

# Make mouse useful in copy mode
setw -g mode-mouse on

# Allow mouse to select which pane to use
set -g mouse-select-pane on

# Allow mouse dragging to resize panes
set -g mouse-resize-pane on

# Allow mouse to select windows

hanefi

# Make mouse useful in copy mode
setw -g mode-mouse on

# Allow mouse to select which pane to use
set -g mouse-select-pane on

# Allow mouse dragging to resize panes
set -g mouse-resize-pane on

# Allow mouse to select windows