micktwomey + postgresql + sql   10

PostgreSQL, Aggregates and Histograms
Generating a histogram in the psql console using width_bucket.
postgresql  sql  statistics 
august 2017 by micktwomey
The big old reliable elephant: talking about Postgres with Craig Kerstiens

In this opportunity I interviewed Craig Kerstiens. Craig works for citusdata, a company that helps customers scale databases beyond a single node.
postgres  postgresql  citusdata  sql  dbs 
april 2017 by micktwomey
PGCon2016: Index Internals
PostgreSQL includes several index types: GiST, SP-GiST, GIN, and of course, the regular B-tree. DBAs are familiar with using each of these for specific use cases, GIN for full-text search, GiST for geometrical data, and so on, but how do they work internally? What makes them suitable for the cases they're typically used for?

In this presentation, I will walk through the internal structure of each of these index types, explaining what strengths and weaknesses each one of them have.
database  postgres  postgresql  sql 
august 2016 by micktwomey
UUID vs BIGSERIAL for Primary Keys
At a glance at this article it seems UUIDs work just fine as primary keys in psql :)
postgresql  database  sql 
october 2015 by micktwomey
"Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting."
cli  database  postgresql  sql 
september 2015 by micktwomey
Postgres: The Bits You Haven't Found
Collection of nice tips and features in PostgresSQL. Useful for folks coming from other databases.
via:hackernews  postgresql  tips  database  sql 
march 2013 by micktwomey

Copy this bookmark: