Anayrat links

PostgreSQL 11 : Procedures are coming - Blog dbi services

June 4, 2018 at 9:40:37 AM GMT+2 * · permalink

https://blog.dbi-services.com/postgresql-11-procedures-are-coming/

Postgres 11 highlight - More Partition Pruning

PostgreSQL · partition_pruning

June 4, 2018 at 9:40:07 AM GMT+2 * · permalink

https://paquier.xyz/postgresql-2/postgres-11-partition-pruning/

Fun with SQL: Window functions in Postgres

PostgreSQL · Window_function · sql

June 4, 2018 at 9:39:51 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/01/fun-with-sql-window-functions-in-postgresql/

State of JIT – 2018 Edition

PostgreSQL · JIT · pgcon2018

June 4, 2018 at 9:39:11 AM GMT+2 * · permalink

http://anarazel.de/talks/2018-06-01-pgcon-state-of-jit/state-of-jit.pdf

Data Egret: Autovacuum slides from PgCon 2018 Ottawa

Vacuum · PostgreSQL

June 4, 2018 at 9:38:56 AM GMT+2 * · permalink

http://blog.dataegret.com/2018/06/autovacuum-slides-from-pgcon-2018-ottawa.html

Index of /2018/schedule/attachments

PostgreSQL · pgcon2018

June 4, 2018 at 9:38:20 AM GMT+2 * · permalink

http://www.pgcon.org/2018/schedule/attachments/

JIT

PostgreSQL · JIT

June 4, 2018 at 9:37:18 AM GMT+2 * · permalink

http://pgphil.ovh/jit_11_beta_01.php

Volatilité - partie 2

PostgreSQL · sql

June 4, 2018 at 9:36:30 AM GMT+2 * · permalink

http://pgphil.ovh/volatility_11_beta_02.php

Volatilité - partie 1

PostgreSQL · sql

June 4, 2018 at 9:36:12 AM GMT+2 * · permalink

http://pgphil.ovh/volatility_10_01.php

Index skip scan | Oracle Scratchpad

Oracle · sql · skip · not_read

June 4, 2018 at 9:35:41 AM GMT+2 * · permalink

https://jonathanlewis.wordpress.com/category/oracle/indexing/index-skip-scan/

PostgreSQL 11 New Features

PostgreSQL · pg11

June 1, 2018 at 5:34:42 PM GMT+2 * · permalink

http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_11_New_Features_beta1_en_20180525-1.pdf

Corruptions!

PostgreSQL · corruption

June 1, 2018 at 3:41:58 PM GMT+2 * · permalink

https://paquier.xyz/content/materials/20180531_pgcon_corruptions.pdf

Authentication in PostgreSQL

PostgreSQL · authentication

June 1, 2018 at 3:41:35 PM GMT+2 * · permalink

https://paquier.xyz/content/materials/20180531_pgcon_auth.pdf

CREATE VIEW vs. ALTER TABLE in PostgreSQL - Cybertec

PostgreSQL · sql · view

June 1, 2018 at 10:35:21 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/create-view-vs-alter-table-in-postgresql/

TAP tests and external modules

Postgis · tests · pgTAP

June 1, 2018 at 10:34:38 AM GMT+2 * · permalink

https://paquier.xyz/postgresql-2/tap-test-modules/

GIT tip : Keep your branch clean with fixup and autosquash - Florent Lebreton

git

June 1, 2018 at 10:34:00 AM GMT+2 * · permalink

https://fle.github.io/git-tip-keep-your-branch-clean-with-fixup-and-autosquash.html

PostgreSQL and Databases in general: Parallel Index Scans In PostgreSQL

PostgreSQL · Parallel · index

May 31, 2018 at 4:15:00 PM GMT+2 * · permalink

http://amitkapila16.blogspot.com/2018/05/parallel-index-scans-in-postgresql.html

GitHub - yandex/odyssey: Scalable PostgreSQL connection pooler

PostgreSQL · pooler · odyssey

May 30, 2018 at 6:09:17 PM GMT+2 * · permalink

https://github.com/yandex/odyssey

PostgreSQL: Detecting periods of activity in a timeseries - Cybertec

Window_function · PostgreSQL · sql · TimeSeries

May 30, 2018 at 10:11:00 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-detecting-periods-of-activity-in-a-timeseries/

PostgreSQL Data Types

PostgreSQL · sql · types

May 24, 2018 at 11:01:21 PM GMT+2 * · permalink

https://tapoueh.org/blog/2018/05/postgresql-data-types/