---
title: "#211: PG-Strom: SSD-To-GPU Direct SQL Execution for Postgres "
publication: "Postgres Weekly"
issue: 211
published_at: "2017-06-14"
canonical_url: "https://postgresweekly.com/issues/211"
---

Postgres Weekly 211   . 

[Read this on the Web](http://postgresweekly.com/issues/211) 

[Postgres Weekly](http://postgresweekly.com) Issue 211 — June 14, 2017     

[Citus 6.2: A Multi-Tenant Database Built on Postgres](https://www.citusdata.com/blog/2017/06/07/announcing-citus62-multi-tenant-database/?utm_source=postgresweekly&utm_medium=email)Citus is an open source database built on top of Postgres, ideal for app devs building multi-tenant B2B applications & real-time analytics. Its latest release includes a number of improvements including pg_stat_statement and concurrent index support. citusdata#tools [PGDay UK 2017 (London, July 4)](http://www.pgconf.uk/?utm_source=postgresweekly&utm_medium=email)The UK’s only dedicated PostgresSQL annual user conference returns next month. PostgreSQL UK Usergroup#news [PG-Strom: SSD-To-GPU Direct SQL Execution for Postgres](https://github.com/pg-strom/devel?utm_source=postgresweekly&utm_medium=email)Use GPUs to accelarate sequential scan and join/aggregate functions in Postgres. [Slidedeck with more info.](https://www.slideshare.net/kaigai/20170602ossummitanintelligentstorage) PG-Strom Project#code [2ndQuadrant Performance Tuning helps maximize ROI for your PostgreSQL Database](https://2ndquadrant.com/en/services/postgresql-performance-tuning/)As primary contributors to PostgreSQL, our expert consultants provide a personalized service for tuning your database based on your organizational workloads. We help you deliver outstanding performance to your customers while ensuring data integrity. 2ndQuadrant PostgreSQL Services#sponsored[![\](https://copm.s3.amazonaws.com/50ff8916.jpg)](https://2ndquadrant.com/en/services/postgresql-performance-tuning/) [PGConf.EU 2017 Call for Papers and Sponsors](https://www.postgresql.org/about/news/1754/?utm_source=postgresweekly&utm_medium=email)PGConf EU, one of the largest Postgres conferences is happening again–this year in Warsaw. The call for papers and sponsors is now open, if you’ve got something interesting to say about Postgres consider submitting. postgresql.​org#news [Running 10 Million PostgreSQL Indexes In Production](http://heap.engineering/running-10-million-postgresql-indexes-in-production/?utm_source=postgresweekly&utm_medium=email)Heap is an analytics company with unusual database requirements. Postgres handles it well, though, even when there are over 10 million indexes in their database. Heap Blog [Working with Time in Postgres](http://www.craigkerstiens.com/2017/06/08/working-with-time-in-postgres/?utm_source=postgresweekly&utm_medium=email)Postgres is a great database for working with time, even when you compare it to other “time-series” databases. Here’s a look at some functions, datatypes, and tips for working with time in Postgres. Craig Kerstiens [Migrating Procedural SQL Code with AWS Schema Conversion Tool](https://aws.amazon.com/blogs/database/migrate-your-procedural-sql-code-with-the-aws-schema-conversion-tool/?utm_source=postgresweekly&utm_medium=email)See how easy it is to migrate procedural code from Oracle to PostgreSQL using AWS SCT. Amazon Web Services [The Easy Way to Setup PostgreSQL 10 Logical Replication](https://www.openscg.com/2017/06/the-easy-way-to-setup-postgresql-10-logical-replication/?utm_source=postgresweekly&utm_medium=email)Logical replication with Postgres 10 seems ready for prime time. If you’re looking to get started with it here’s an early guide for getting things setup. Holly Orr [Using EXPLAIN ANALYZE](http://malisper.me/using-explain-analyze-in-postgres/?utm_source=postgresweekly&utm_medium=email)Each time Postgres runs a query, it does a lot of work to figure out an efficient path. You can get the insights of what Postgres will do with EXPLAIN and EXPLAIN ANALYZE, and here’s your initial guide on how to use each. Michael Malis [Linux cloud hosting starting at 1GB of RAM for $5/mo.](http://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account. linode#sponsored [Stolon: A Cloud-Native HA Replication Manager for Postgres](https://github.com/sorintlab/stolon?utm_source=postgresweekly&utm_medium=email)Adding to the options of Postgres replication managers, here’s a cloud native manager for PostgreSQL high availability. Sorint.​lab#tools    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/211) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK