Serpent7776

joined 1 year ago
 

I'm doing an extension that creates a pool of named background workers. Happy to hear any feedback on this.

CREATE EXTENSION pg_worker_pool;
CALL worker_pool.submit('foo', 'create index myindex_1 on my_big_table (id)');
CALL worker_pool.submit('foo', 'create index myindex_1 on my_big_table (name)');
CALL worker_pool.submit('bar', 'create index otherindex_2 on other_big_table (author)');
CALL worker_pool.submit('bar', 'create index otherindex_2 on other_big_table (title)');

This will start two background workers, foo and bar. foo will create an indices on table my_big_table and bar on table other_big_table. foo and bar will run independently of each other, but all indices submitted to the same worker will be created in order.

 

A blog post shows an example usage of hyperfine CLI tool to measure and plot time of startup and shutdown of several code interpreters.

 

I created a very simple script that shows the history usage of your shell. Should work with bash and fish shells.

This basically goes through the history and counts the command names. So all of git push, git pull, etc will count as just git.

Example output:

    847 pacman
    296 cd
    206 git
    203 time
    180 vim
    172 awk
    166 aur
    142 strace
    141 cat
    125 ls
Total commands:  7008
Unique commands: 753