Skip to content

Instantly share code, notes, and snippets.

View lalitkapoor's full-sized avatar

Lalit Kapoor lalitkapoor

View GitHub Profile
@lalitkapoor
lalitkapoor / CHANGELOG.md
Created April 18, 2016 13:35
request changelog.md

Change Log

v2.72.0 (2016/04/17)

  • #2176 Do not try to pipe Gzip responses with no body (@simov)
  • #2175 Add 'delete' alias for the 'del' API method (@simov, @MuhanZou)
  • #2172 Add support for deflate content encoding (@czardoz)
  • #2169 Add callback option (@simov)
  • #2165 Check for self.req existence inside the write method (@simov)
  • #2167 Fix TravisCI badge reference master branch (@a0viedo)
# global settings
[global]
newrelic_license_key=YOUR_LICENSE_KEY_HERE
poll_interval=60
# logging settings
[loggers]
keys=root
@lalitkapoor
lalitkapoor / doggy.sql
Created May 23, 2019 19:57
dog gif SQL
This file has been truncated, but you can view the full file.
SELECT decode(
"AAAAIGZ0eXBpc29tAAACAGlzb21pc28yYXZjMW1wNDEAAAs7bW9vdgAAAGxtdmhkAAAAAAAAAAAAAAAAAAAD6AAAQ1IAAQAAAQAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAACmV0cmFrAAAAXHRraGQAAAADAAAAAAAAAAAAAAABAAAAAAAAQ1IAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAABAAAAAAqwAAANWAAAAAAAkZWR0cwAAABxlbHN0AAAAAAAAAAEAAENSAAAAAAABAAAAAAndbWRpYQAAACBtZGhkAAAAAAAAAAAAAAAAAAA8AAAECgBVxAAAAAAALWhkbHIAAAAAAAAAAHZpZGUAAAAAAAAAAAAAAABWaWRlb0hhbmRsZXIAAAAJiG1pbmYAAAAUdm1oZAAAAAEAAAAAAAAAAAAAACRkaW5mAAAAHGRyZWYAAAAAAAAAAQAAAAx1cmwgAAAAAQAACUhzdGJsAAAAlHN0c2QAAAAAAAAAAQAAAIRhdmMxAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAqwDVgBIAAAASAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGP//AAAALmF2Y0MBQsAf/+EAF2dCwB/bArBt7mhAAAADAEAAAA8Dxgy4AQAEaMqD8gAAABhzdHRzAAAAAAAAAAEAAAIFAAACAAAAABxzdHNzAAAAAAAAAAMAAAABAAAAqgAAAaQAAAA0c3RzYwAAAAAAAAADAAAAAQAAALUAAAABAAAAAgAAATsAAAABAAAAAwAAABUAAAABAAAIKHN0c3oAAAAAAAAAAAAAAgUAAHH/AAAW5gAAG9cAAAKEAAAnEQAAAxUAAB/4AAAkwAAAAzYAABDfAA
@lalitkapoor
lalitkapoor / recreate.sql
Last active February 18, 2023 03:23
TimescaleDB hierarchical continuous aggregate performance drop by ~20x for large datasets
DROP MATERIALIZED VIEW IF EXISTS hca_daily;
DROP MATERIALIZED VIEW IF EXISTS hca_hourly;
DROP MATERIALIZED VIEW IF EXISTS hca_minutely;
DROP TABLE IF EXISTS hca_test_events;
CREATE TABLE hca_test_events (
customer_id TEXT NOT NULL,
ts timestamptz NOT NULL,
measures JSONB
);