Search: [PostgreSQL] - Anayrat links

plprofiler - Getting a Handy Tool for Profiling Your PL/pgSQL Code - Percona Database Performance Blog

PostgreSQL · flamegraph · plpgsql

February 17, 2019 at 3:26:07 PM GMT+1 * · permalink

https://www.percona.com/blog/2019/02/13/plprofiler-getting-a-handy-tool-for-profiling-your-pl-pgsql-code/

PostgreSQL 11 Reestablishes Window Functions Leadership

PostgreSQL · Window_function

February 15, 2019 at 11:25:52 AM GMT+1 * · permalink

https://modern-sql.com/blog/2019-02/postgresql-11

How to Calculate a Cumulative Percentage in SQL – Java, SQL and jOOQ.

PostgreSQL · Window_function

February 14, 2019 at 6:45:05 PM GMT+1 * · permalink

https://blog.jooq.org/2019/02/14/how-to-calculate-a-cumulative-percentage-in-sql/

Introduction to Hacking PostgreSQL

PostgreSQL · hack · Internal

February 14, 2019 at 12:38:00 PM GMT+1 * · permalink

http://www.neilconway.org/talks/hacking/ottawa/ottawa_slides.pdf

Inside the PostgreSQL Query Optimizer

PostgreSQL · Internal · hack · planner · optimizer

February 14, 2019 at 12:37:20 PM GMT+1 * · permalink

http://www.neilconway.org/talks/optimizer/optimizer.pdf

PostgreSQL Deep Dive: How Your Data Model Affects Storage

PostgreSQL · SQL · Performance

February 13, 2019 at 9:52:33 PM GMT+1 * · permalink

https://info.crunchydata.com/blog/how-your-postgresql-data-model-affects-storage

What’s up with SET TRANSACTION SNAPSHOT?

PostgreSQL · MVCC

February 12, 2019 at 12:56:38 PM GMT+1 * · permalink

https://thebuild.com/blog/2019/02/11/whats-up-with-set-transaction-snapshot/

Security Best Practices Deep Dive

PostgreSQL · Security

February 9, 2019 at 3:33:22 PM GMT+1 * · permalink

https://joeconway.com/presentations/SecurePGDeepDive-FOSDEM-2019.pdf

Queues in PostgreSQL

PostgreSQL · queues

February 7, 2019 at 3:41:40 PM GMT+1 * · permalink

http://2017.pgday.com.au/assets/queues-pgday-au-2017.pdf

PostgreSQL: [PATCH] Equivalence Class Filters

PostgreSQL · planner · Equivalence_Classes

February 7, 2019 at 2:53:55 PM GMT+1 * · permalink

https://www.postgresql.org/message-id/flat/CAKJS1f9FK_X_5HKcPcSeimy16Owe3EmPmmGsGWLcKkj_rW9s6A%40mail.gmail.com

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/