Skip to content

Instantly share code, notes, and snippets.

Jukka Raimovaara xvaara

Block or report user

Report or block xvaara

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@xvaara
xvaara / bencmark.sql
Created Sep 19, 2018
Benchmark PL/pgSQL, PL/v8, PL/lua-ng
View bencmark.sql
DROP TABLE IF EXISTS accumulator_lua;
CREATE TABLE accumulator_lua (id BIGSERIAL PRIMARY KEY, new_value INT, sum_previous INT);
DROP TABLE IF EXISTS accumulator_lua_pre;
CREATE TABLE accumulator_lua_pre (id BIGSERIAL PRIMARY KEY, new_value INT, sum_previous INT);
DROP TABLE IF EXISTS accumulator_v8;
CREATE TABLE accumulator_v8 (id BIGSERIAL PRIMARY KEY, new_value INT, sum_previous INT);
DROP TABLE IF EXISTS accumulator_plpgsql;
@xvaara
xvaara / index_stats.sql
Last active Oct 14, 2017
TimescaleDB index stats
View index_stats.sql
SELECT
p.parent,
con.consrc as chunk_constraint,
t.tablename,
indexname,
c.reltuples AS num_rows,
pg_size_pretty(pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(t.tablename)::text)) AS table_size,
pg_size_pretty(pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(indexrelname)::text)) AS index_size,
CASE WHEN indisunique THEN 'Y'
ELSE 'N'
View keybase.md

Keybase proof

I hereby claim:

  • I am xvaara on github.
  • I am xvaara (https://keybase.io/xvaara) on keybase.
  • I have a public key ASDqYcEr-yFp4UUtT9Uo_oBL7UHluZSaFJduF0VKPa_wLwo

To claim this, I am signing this object:

@xvaara
xvaara / output.txt
Created Apr 8, 2012
my output from wg8 install
View output.txt
Linux debian 2.6.32-5-amd64 #1 SMP Thu Mar 22 17:26:33 UTC 2012 x86_64
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Sun Apr 8 10:27:03 2012
@xvaara
xvaara / install.xdanger.sh
Created Apr 6, 2012
install webgui 8 on debian stable
View install.xdanger.sh
#!/bin/sh
# run on a clean debian stable
# install webgui 8, using my little tweaks to get things going.
# xdanger
#percona mysql 5.5
gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
gpg -a --export CD2EFD2A | apt-key add -
echo "deb http://repo.percona.com/apt squeeze main" >> /etc/apt/sources.list
View gist:2159091
Internal Server Error: /
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py", line 111, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python2.6/dist-packages/django/utils/decorators.py", line 93, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.6/dist-packages/django/views/decorators/vary.py", line 22, in inner_func
response = func(*args, **kwargs)
File "/home/webdev/bongaus/qr-spotter/qr/spotter/views.py", line 148, in index
return _base(request, 'index', c)
View gist:2063588
/usr/local/lib/python2.6/dist-packages/djangoratings/fields.py:316: DeprecationWarning: A Field class whose get_db_prep_save method hasn't been updated to take a `connection` argument.
class RatingField(IntegerField):
/usr/local/lib/python2.6/dist-packages/djangoratings/fields.py:316: DeprecationWarning: A Field class whose get_db_prep_lookup method hasn't been updated to take `connection` and `prepared` arguments.
class RatingField(IntegerField):
Syncing...
Creating tables ...
Installing custom SQL ...
Installing indexes ...
No fixtures found.
You can’t perform that action at this time.