Anayrat links

1788 shaares

1788 shaares

Filters

75 / 90

Links per page

20 50 100

When To Avoid JSONB In A PostgreSQL Schema - Heap Blog

PostgreSQL · JSON

August 1, 2017 at 2:14:25 PM GMT+2 * · permalink

https://blog.heapanalytics.com/when-to-avoid-jsonb-in-a-postgresql-schema/

CiteSeerX — Design and evaluation of main memory hash join algorithms for multi-core CPUs

Research · not_read · Hash · Join

August 1, 2017 at 12:34:03 PM GMT+2 * · permalink

http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.225.3495

12 Things Developers Will Love About Oracle Database 12c Release 2 | Oracle All Things SQL Blog

Oracle · 12.2

July 31, 2017 at 9:20:59 PM GMT+2 * · permalink

https://blogs.oracle.com/sql/12-things-developers-will-love-about-oracle-database-12c-release-2

https://www.slideshare.net/morgo/mysql-80-optimizer-guide

MySQL · Performance

July 31, 2017 at 9:13:45 PM GMT+2 * · permalink

https://www.slideshare.net/morgo/mysql-80-optimizer-guide

Average response time with Postgres’ Window Functions and CTEs

PostgreSQL · CTE · SQL

July 31, 2017 at 2:16:09 PM GMT+2 * · permalink

https://medium.com/@chamini2/average-response-time-with-postgres-window-functions-and-ctes-a19adb7ed4f7

1.1 Billion Taxi Rides with BrytlytDB & 2 GPU-Powered p2.16xlarge EC2 Instances

GPU · Performance · PostgreSQL

July 31, 2017 at 2:15:52 PM GMT+2 * · permalink

http://tech.marksblogg.com/billion-nyc-taxi-rides-aws-ec2-p2-16xlarge-brytlytdb.html

GitHub - martingms/vipsql: A vim-frontend for interacting with psql

PostgreSQL · psql

July 31, 2017 at 2:15:10 PM GMT+2 * · permalink

https://github.com/martingms/vipsql

18+ Best Online Resources for Learning SQL and Database Concepts

SQL

July 29, 2017 at 3:56:16 PM GMT+2 * · permalink

https://academy.vertabelo.com/blog/18-best-online-resources-for-learning-sql-and-database-concepts/

Optimizer with Oracle Database 12c Release 2

Oracle

July 29, 2017 at 3:51:41 PM GMT+2 * · permalink

http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-optimizer-with-oracledb-12c-1963236.pdf

Data in Motion and Data at Rest - Simple Talk - Joe Celko

SQL

July 28, 2017 at 9:33:11 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/t-sql-programming/data-motion-data-rest/

Writing your own aggregation functions

PostgreSQL · SQL

July 28, 2017 at 9:07:46 PM GMT+2 * · permalink

http://www.cybertec.at/writing-your-own-aggregation-functions/

Implementing State Machines in PostgreSQL - Felix Geisendörfer

PostgreSQL · Aggregate · SQL · Trigger

July 28, 2017 at 9:06:36 PM GMT+2 * · permalink

http://felixge.de/2017/07/27/implementing-state-machines-in-postgresql.html

PG Phriday: Smooth Operator | Having Fun with CREATE OPERATOR

PostgreSQL · SQL

July 28, 2017 at 9:02:16 PM GMT+2 * · permalink

https://blog.2ndquadrant.com/pg-phriday-smooth-operator/

Cool Stuff in PostgreSQL 10: Auto-logging

PostgreSQL · Trigger

July 28, 2017 at 8:53:48 PM GMT+2 * · permalink

http://databasedoings.blogspot.fr/2017/07/cool-stuff-in-postgresql-10-auto-logging.html

Postgres autovacuum, bloat and tpc-c style workloads – Command Prompt, Inc.

PostgreSQL · Vacuum

July 28, 2017 at 1:46:26 PM GMT+2 * · permalink

https://www.commandprompt.com/blog/postgres_autovacuum_bloat_tpc-c/

pg_dirtyread: Read dead but unvacuumed tuples from a PostgreSQL relation

PostgreSQL · Internal · Hack

July 23, 2017 at 1:36:32 PM GMT+2 * · permalink

https://github.com/ChristophBerg/pg_dirtyread

PostgreSQL: Indexes and foreign keys

Postgis · SQL

July 21, 2017 at 12:47:16 AM GMT+2 * · permalink

http://www.cybertec.at/postgresql-indexes-and-foreign-keys/

Scalable MVCC Solution for Many Core Machines - CSN

PostgreSQL · Hack · Internal

July 19, 2017 at 9:23:51 AM GMT+2 * · permalink

http://www.pgcon.org/2015/schedule/attachments/339_Scalable_MVCC_Solution_ManyCore_Machines.pdf

Peter Geoghegan's blog: PostgreSQL Index bloat under a microscope

PostgreSQL · Internal · index · Hack

July 19, 2017 at 8:50:10 AM GMT+2 * · permalink

http://pgeoghegan.blogspot.fr/2017/07/postgresql-index-bloat-microscope.html

Analytics Playbook: Log Tables – Fishtown Analytics

PostgreSQL · SQL

July 18, 2017 at 9:32:45 PM GMT+2 * · permalink

https://blog.fishtownanalytics.com/analytics-playbook-log-tables-7df0e6aacb42

Filters

75 / 90

Links per page

20 50 100