Search: [PostgreSQL] - Anayrat links

How to Write a Multiplication Aggregate Function in SQL – Java, SQL and jOOQ.

PostgreSQL · Aggregate · SQL

September 21, 2018 at 12:30:17 GMT+2 * · permalink

https://blog.jooq.org/2018/09/21/how-to-write-a-multiplication-aggregate-function-in-sql/

How to Reduce Syntactic Overhead Using the SQL WINDOW Clause – Java, SQL and jOOQ.

PostgreSQL · Window_function · SQL

September 20, 2018 at 17:43:08 GMT+2 * · permalink

https://blog.jooq.org/2018/09/20/how-to-reduce-syntactic-overhead-using-the-sql-window-clause/

Partitioning Improvements in PostgreSQL 11

PostgreSQL · partionning · partition_pruning

September 20, 2018 at 13:54:05 GMT+2 * · permalink

https://blog.2ndquadrant.com/partitioning-improvements-pg11/

Hypothetical Partitioning for PostgreSQL

PostgreSQL · partionning · hypopg

September 20, 2018 at 13:45:48 GMT+2 * · permalink

https://www.slideshare.net/YuzukoHosoya/hypothetical-partitioning-for-postgresql

Cost of a Join - Part 2: Enums, Wider Tables

PostgreSQL · Join · enum

September 19, 2018 at 21:17:12 GMT+2 * · permalink

https://www.brianlikespostgres.com/cost-of-a-join-part-2.html

Correlation of PostgreSQL columns explained - Cybertec

PostgreSQL · index · Correlation

September 19, 2018 at 12:33:35 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/column-correlation-explained/

Why Covering Indexes Are Incredibly Helpful

PostgreSQL · Performance · index · covering

September 17, 2018 at 14:19:53 GMT+2 * · permalink

https://info.crunchydata.com/blog/why-covering-indexes-are-incredibly-helpful

postgresql - pg_column_size reports different vastly sizes for table.* than specific columns - Stack Overflow

PostgreSQL · toast

September 17, 2018 at 10:26:36 GMT+2 * · permalink

https://stackoverflow.com/questions/44144089/pg-column-size-reports-different-vastly-sizes-for-table-than-specific-columns

Securing PostgreSQL

PostgreSQL · Security

September 13, 2018 at 19:49:46 GMT+2 * · permalink

https://thebuild.com/presentations/securing-postgresql-pgdaypdx-2018.pdf

A first look at Amazon Aurora with MySQL/PostgreSQL compatibility – Benefits and Drawbacks – Part I

PostgreSQL · Aurora · AWS

September 12, 2018 at 14:44:07 GMT+2 * · permalink

https://blog.toadworld.com/2017/02/13/a-first-look-at-amazon-aurora-with-mysql-postgresql-compatibility-benefits-and-drawbacks-part-i

PostgreSQL 11: something for everyone

PostgreSQL · pg11

September 12, 2018 at 10:25:19 GMT+2 * · permalink

https://lwn.net/Articles/764515/

PostgreSQL 11 and Just In Time Compilation of Queries

PostgreSQL · JIT

September 12, 2018 at 09:53:06 GMT+2 * · permalink

https://www.citusdata.com/blog/2018/09/11/postgresql-11-just-in-time/

Parallel PostGIS and PgSQL 11 · Paul Ramsey

PostgreSQL · Postgis · Parallel

September 11, 2018 at 18:04:34 GMT+2 * · permalink

http://blog.cleverelephant.ca/2018/09/parallel-postgis-3.html

Parallelism in PostgreSQL 11 - Speaker Deck

PostgreSQL · Parallel

September 11, 2018 at 17:59:33 GMT+2 * · permalink

https://speakerdeck.com/macdice/parallelism-in-postgresql-11

Just In Time Compilation in PostgreSQL 11 and onward

PostgreSQL · JIT

September 9, 2018 at 19:44:41 GMT+2 * · permalink

http://anarazel.de/talks/2018-09-07-pgopen-jit/jit.pdf

Bloat in PostgreSQL: A Taxonomy

PostgreSQL · bloat · index · Vacuum

September 9, 2018 at 19:29:09 GMT+2 * · permalink

https://speakerdeck.com/peterg/bloat-postgresql-pgopen

Introduction to PostgreSQL's indexes | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL · Btree · index

September 7, 2018 at 16:08:06 GMT+2 * · permalink

http://www.louisemeta.com/blog/intro-to-indexes/

PostgreSQL's indexes – BTrees internal data structure | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL · Btree · index

September 7, 2018 at 16:07:46 GMT+2 * · permalink

http://www.louisemeta.com/blog/indexes-btree/

PostgreSQL's indexes - BTrees algorithms | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL · Btree · index

September 7, 2018 at 16:07:29 GMT+2 * · permalink

http://www.louisemeta.com/blog/indexes-btree-algorithms/

PostgreSQL: Re: [PATCH] Incremental sort (was: PoC: Partial sort)

Tricks · sort · PostgreSQL · index

September 7, 2018 at 09:04:40 GMT+2 * · permalink

https://www.postgresql.org/message-id/153625271389.4078.18405235923135713189.pgcf%40coridan.postgresql.org