Anayrat links

Data Egret: PostgreSQL workings in one picture.

PostgreSQL · monitoring

September 7, 2017 at 11:08:51 PM GMT+2 * · permalink

http://blog.postgresql-consulting.com/2017/09/postgresql-workings-in-one-picture.html

Compare Postgres speed within Docker and without – Max Prokopov – Medium

PostgreSQL · Docker · Performance

September 7, 2017 at 11:08:28 PM GMT+2 * · permalink

https://medium.com/@mprokopov/compare-postgres-speed-within-docker-and-without-be8d87b5b10c

Citus 7: Transactions, Framework Integration, and Postgres 10

PostgreSQL · citus

September 7, 2017 at 11:07:51 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2017/09/07/citus-7-distributed-transactions-frameworks-and-pg10/

Optimizing web servers for high throughput and low latency – Dropbox Tech Blog

linux · Performance

September 7, 2017 at 2:44:28 PM GMT+2 * · permalink

https://blogs.dropbox.com/tech/2017/09/optimizing-web-servers-for-high-throughput-and-low-latency/amp/

Postgres Pro Standard : Documentation: 9.6: Appendix L. Demo Database “Airlines” : Postgres Professional

PostgreSQL · Opendata

September 6, 2017 at 4:09:01 PM GMT+2 * · permalink

https://postgrespro.com/docs/postgrespro/9.6/demodb-bookings.html

SNCF Open Data — Explore

Opendata

September 6, 2017 at 4:01:07 PM GMT+2 * · permalink

https://ressources.data.sncf.com/explore/?sort=modified

Learn Perl in about 2 hours 30 minutes

perl

September 5, 2017 at 11:12:10 AM GMT+2 * · permalink

https://qntm.org/files/perl/perl.html

Graph Algorithms in a Database: Recursive CTEs and Topological Sort with Postgres

PostgreSQL · SQL · CTE

September 4, 2017 at 4:06:40 PM GMT+2 * · permalink

https://www.fusionbox.com/blog/detail/graph-algorithms-in-a-database-recursive-ctes-and-topological-sort-with-postgres/620/

Visualizing data in PostgreSQL with R Shiny

PostgreSQL · R

September 4, 2017 at 11:06:04 AM GMT+2 * · permalink

http://www.cybertec.at/visualizing-data-in-postgresql-with-r-shiny/

Du nouveau dans les triggers avec PostgreSQL 10

PostgreSQL · Trigger · SQL

September 1, 2017 at 5:07:27 PM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2017/09/01/triggers-postgresql-10.html

JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage – Java, SQL and jOOQ.

SQL · MySQL · Oracle · MSQLServer · DB2 · PostgreSQL · Performance

September 1, 2017 at 5:00:25 PM GMT+2 * · permalink

https://blog.jooq.org/2017/09/01/join-elimination-an-essential-optimiser-feature-for-advanced-sql-usage/

Databases and Distributed Deadlocks: A FAQ

PostgreSQL · lock

September 1, 2017 at 9:02:42 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2017/08/31/databases-and-distributed-deadlocks-a-faq/

SQL Code Smells - Simple Talk

SQL · tuning · Tricks

August 31, 2017 at 7:11:27 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-code-smells/

Hacking PostgreSQL: Data Access Methods | edX

PostgreSQL · Hack · Internal

August 31, 2017 at 11:18:14 AM GMT+2 * · permalink

https://www.edx.org/course/hacking-postgresql-data-access-methods-urfux-pgam31337x

Nordeus Blog - Dev & Ops - Partitioning existing tables in PostgreSQL

PostgreSQL · partionning

August 30, 2017 at 11:10:03 PM GMT+2 * · permalink

http://blog.nordeus.com/dev-ops/partitioning-existing-tables-in-postgresql.htm

Traqueur : verrouillage et transactions préparées

PostgreSQL

August 30, 2017 at 11:09:07 PM GMT+2 * · permalink

http://pgphil.ovh/traqueur_10_10.php

Deferrable SQL Constraints in Depth

PostgreSQL · SQL · constraint · deferrable

August 27, 2017 at 6:20:28 PM GMT+2 * · permalink

https://begriffs.com/posts/2017-08-27-deferrable-sql-constraints.html

ORACLE-BASE - Optimizer Statistics Advisor in Oracle Database 12c Release 2 (12.2)

Oracle · Statistics

August 27, 2017 at 3:10:58 PM GMT+2 * · permalink

https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2

Postgres vs. Oracle access paths XI - Sample Scan - Blog dbi services

Oracle · PostgreSQL · Tablesample

August 27, 2017 at 2:57:49 PM GMT+2 * · permalink

https://blog.dbi-services.com/postgres-vs-oracle-access-paths-xi/

Why is My Database Application so Slow? - Simple Talk

database · Performance

August 25, 2017 at 7:00:58 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/dotnet/net-performance/database-application-slow/