Anayrat links

Advisory Locks and How to Use Them - Shiroyasha

PostgreSQL · lock · advisory_locks

November 16, 2017 at 4:45:28 PM GMT+1 * · permalink

http://shiroyasha.io/advisory-locks-and-how-to-use-them.html

The Mode Ordered-Set Aggregate Function

SQL · PostgreSQL

November 16, 2017 at 4:44:48 PM GMT+1 * · permalink

http://tapoueh.org/blog/2017/11/the-mode-ordered-set-aggregate-function/

Large objects ou bytea?

PostgreSQL · Internal

November 16, 2017 at 4:44:04 PM GMT+1 * · permalink

http://blog-postgresql.verite.pro/2017/11/15/large-objects-bytea.html

select * from depesz; » Blog Archive » Waiting for PostgreSQL 11 – Add hash partitioning.

PostgreSQL · Hash · partionning

November 11, 2017 at 11:54:07 AM GMT+1 * · permalink

https://www.depesz.com/2017/11/10/waiting-for-postgresql-11-add-hash-partitioning/

Advanced SQL - window functions – Michał Konarski

PostgreSQL · SQL · Window_function

November 11, 2017 at 11:52:53 AM GMT+1 * · permalink

http://mjk.space/advanced-sql-window-functions/

How do UPSERT and MERGE work in Oracle, SQL Server, PostgreSQL and MySQL | Vlad Mihalcea's Blog

PostgreSQL · SQL · Oracle

November 9, 2017 at 4:12:51 PM GMT+1 * · permalink

https://vladmihalcea.com/2017/11/06/how-do-upsert-and-merge-work-in-oracle-sql-server-postgresql-and-mysql/

Your options for partitioning in PostgreSQL 10, explained

PostgreSQL · partionning

November 9, 2017 at 12:17:59 PM GMT+1 * · permalink

https://blog.timescale.com/scaling-partitioning-data-postgresql-10-explained-cd48a712a9a1

Parallel PostGIS IIA · Paul Ramsey

PostgreSQL · Postgis

November 9, 2017 at 12:17:08 PM GMT+1 * · permalink

http://blog.cleverelephant.ca/2017/11/parallel-postgis-2A.html

How to Avoid Excessive Sorts in Window Functions – Java, SQL and jOOQ.

PostgreSQL · SQL · Window_function

November 9, 2017 at 12:13:27 PM GMT+1 * · permalink

https://blog.jooq.org/2017/11/06/how-to-avoid-excessive-sorts-in-window-functions/

Faster bulk loading in Postgres with copy

PostgreSQL · SQL · Performance

November 9, 2017 at 12:12:14 PM GMT+1 * · permalink

https://www.citusdata.com/blog/2017/11/08/faster-bulk-loading-in-postgresql-with-copy/

Data Egret: Deep dive into Postgres stats: pg_stat_progress_vacuum

PostgreSQL · pg_stat_progress_vacuum · Statistics

November 1, 2017 at 9:26:03 PM GMT+1 * · permalink

http://blog.postgresql-consulting.com/2017/10/deep-dive-into-postgres-stats_31.html

Parallel PostGIS II · Paul Ramsey

Postgis

November 1, 2017 at 9:25:37 PM GMT+1 * · permalink

http://blog.cleverelephant.ca/2017/10/parallel-postgis-2.html

Commitment Issues

PostgreSQL

November 1, 2017 at 9:24:56 PM GMT+1 * · permalink

http://thebuild.com/blog/2017/10/30/commitment-issues/

Postgres - the non-code bits - Craig Kerstiens

PostgreSQL

November 1, 2017 at 9:24:43 PM GMT+1 * · permalink

http://www.craigkerstiens.com/2017/10/31/postgres-the-non-code-bits/

Débugger avec Git | Blog Eleven Labs

git

October 26, 2017 at 7:42:54 PM GMT+2 * · permalink

https://blog.eleven-labs.com/fr/debugging-with-git/

Peter Geoghegan's blog: amcheck “table-matches-index” enhancement now available, detects "freeze-the-dead" corruption

PostgreSQL · Internal · index · amcheck

October 26, 2017 at 7:20:37 PM GMT+2 * · permalink

http://pgeoghegan.blogspot.fr/2017/10/amcheck-table-matches-index-enhancement.html

Sql Antipatterns Strike Back

SQL

October 25, 2017 at 8:04:58 PM GMT+2 * · permalink

https://www.slideshare.net/billkarwin/sql-antipatterns-strike-back

Learning w/ Diagrams: Handling Contention with PostgreSQL

PostgreSQL · Isolation

October 23, 2017 at 8:31:48 AM GMT+2 * · permalink

https://medium.com/@dianahsieh323/learning-w-diagrams-handling-contention-with-postgresql-109798b8ad54

PostgreSQL Domain Integrity In Depth

PostgreSQL · SQL

October 22, 2017 at 9:19:18 AM GMT+2 * · permalink

https://begriffs.com/posts/2017-10-21-sql-domain-integrity.html

ZNC

Irc

October 20, 2017 at 3:21:06 PM GMT+2 * · permalink

https://wiki.znc.in/ZNC