Search: [PostgreSQL] - Anayrat links

PostgreSQL: Equivalence Classes when using IN

PostgreSQL · planner · Equivalence_Classes

February 7, 2019 at 2:05:42 PM GMT+1 * · permalink

https://www.postgresql.org/message-id/VI1PR05MB1709E0E0ADE98AFC0D8D2177C7770%40VI1PR05MB1709.eurprd05.prod.outlook.com

What are custom and generic plans in PostgreSQL? - Blog dbi services

PostgreSQL · prepare · planner

February 6, 2019 at 9:21:14 AM GMT+1 * · permalink

https://blog.dbi-services.com/what-are-custom-and-generic-plans-in-postgresql/

SortSupport: Sorting in Postgres at Speed — Brandur Leach

PostgreSQL · Internal · hack · sort

February 4, 2019 at 6:27:50 PM GMT+1 * · permalink

https://brandur.org/sortsupport

Transparent Data Encryptoin in PostgreSQL and Integratino with Key Ma…

PostgreSQL · Security · Encryption

February 1, 2019 at 12:21:51 PM GMT+1 * · permalink

https://www.slideshare.net/masahikosawada98/transparent-data-encryptoin-in-postgresql-and-integratino-with-key-management-service

COUNT(*) vs COUNT(1) vs COUNT(id) – Alexey Bashtanov PostgreSQL Blog

SQL · PostgreSQL

January 25, 2019 at 9:09:50 AM GMT+1 * · permalink

https://pgblog.bashtanov.com/2019/01/24/count-vs-count1-vs-countid/

GitHub - petergeoghegan/benchmarksql: Unofficial mirror of BenchmarkSQL PostgreSQL TPC-C fair-use implementation

PostgreSQL · benchmark

January 24, 2019 at 10:43:24 AM GMT+1 * · permalink

https://github.com/petergeoghegan/benchmarksql

Tagging Trillions of Users in Milliseconds with varbitx on PostgreSQL

PostgreSQL · Extension

January 21, 2019 at 2:49:01 PM GMT+1 * · permalink

https://medium.com/@Alibaba_Cloud/tagging-trillions-of-users-in-milliseconds-with-varbitx-on-postgresql-1109c372d892

Maintaining feature branches and submitting patches with Git |

PostgreSQL · git

January 15, 2019 at 2:05:50 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/maintaining-feature-branches-submitting-patches-git/

PG Phriday: PgBouncer or Bust | The Importance of Proxies

PostgreSQL · PgBouncer

January 12, 2019 at 11:51:56 AM GMT+1 * · permalink

https://blog.2ndquadrant.com/pg-phriday-pgbouncer-bust/

Empty Thoughts: Working with NULL - Simple Talk

PostgreSQL · SQL · NULL · celko

January 11, 2019 at 9:50:15 AM GMT+1 * · permalink

https://www.red-gate.com/simple-talk/sql/sql-development/empty-thoughts-working-with-null/

PostgreSQL Updatable Views: Performing Schema Updates With Minimal Downtime - Percona Database Performance Blog

PostgreSQL · view

January 10, 2019 at 5:56:47 PM GMT+1 * · permalink

https://www.percona.com/blog/2019/01/10/postgresql-updatable-views-performing-schema-updates-with-minimal-downtime/

Bring native psql magic into Jupyter Notebook – Constantinos Antzakas – Medium

PostgreSQL · Jupyter

January 10, 2019 at 5:56:31 PM GMT+1 * · permalink

https://medium.com/@cantzakas/bring-native-psql-magic-into-jupyter-notebook-50b663d856b5

Looking Back at Postgres

PostgreSQL

January 10, 2019 at 4:32:18 PM GMT+1 * · permalink

http://www.morganclaypoolpublishers.com/stonebraker/5-Hellerstein.pdf

Looking Back at Postgres

PostgreSQL

January 10, 2019 at 4:25:10 PM GMT+1 * · permalink

https://arxiv.org/pdf/1901.01973.pdf

PG 11 Partitioning Optimization Features · GitHub

PostgreSQL · pg11 · partionning

January 10, 2019 at 4:23:46 PM GMT+1 * · permalink

https://gist.github.com/amitlan/cd13271142bb2d26ae46b69afb675a31

GitHub - erthalion/postgres-bcc

bcc · eBPF · Performance · PostgreSQL · Internal

January 9, 2019 at 3:30:22 PM GMT+1 * · permalink

https://github.com/erthalion/postgres-bcc

Inlining of SQL functions - PostgreSQL wiki

PostgreSQL · functions

January 8, 2019 at 4:43:19 PM GMT+1 * · permalink

https://wiki.postgresql.org/wiki/Inlining_of_SQL_functions

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage | Haki Benita

PostgreSQL · SQL · tuning

January 3, 2019 at 9:27:48 AM GMT+1 * · permalink

https://hakibenita.com/how-we-solved-a-storage-problem-in-postgre-sql-without-adding-a-single-bytes-of-storage

Subtleties of time zone calculations in Postgres // CY Tech

PostgreSQL · time · SQL

December 28, 2018 at 2:40:30 PM GMT+1 * · permalink

https://tech.codeyellow.nl/blog/pg-timezones/

Lies, damned lies, and statistics

PostgreSQL · Statistics

December 28, 2018 at 12:35:22 PM GMT+1 * · permalink

https://www.pgcon.org/2017/schedule/attachments/443_lies-damned-lies-and-statistics.pdf