---
title: "Architecture and Tuning of Memory in Postgres Databases"
publication: "Postgres Weekly"
issue: 262
published_at: "2018-06-27"
canonical_url: "https://postgresweekly.com/issues/262"
---

The latest Postgres news, articles, tools, and projects.       

#262 — June 27, 2018 

[Read on the Web](https://postgresweekly.com/issues/262)   

Postgres Weekly  

[Architecture and Tuning of Memory in Postgres Databases](https://severalnines.com/blog/architecture-and-tuning-memory-postgresql-databases) — An overview of Postgres memory management, the configuration parameters available, and tips on how to optimize them. 

Severalnines   

[Why is Postgres Running Slow? Tips and Tricks to Get to the Source](https://severalnines.com/blog/why-postgresql-running-slow-tips-tricks-get-source) — Tips and tricks for identifying issues in your PostgreSQL setup and how to tune it to drive performance. 

Brian Fehrle   [![\](https://copm.s3.amazonaws.com/2b90084b.png)](https://www.percona.com/blog/2018/06/15/tuning-postgresql-for-sysbench-tpcc/) 

[Tuning PostgreSQL for sysbench-tpcc](https://www.percona.com/blog/2018/06/15/tuning-postgresql-for-sysbench-tpcc/) — [Did you know sysbench-tpcc also works with PostgreSQL](https://www.percona.com/blog/2018/04/19/sysbench-tpcc-supports-postgresql-no-really-this-time/)? This post evaluates sysbench-tpcc in PostgreSQL. Read to find out if performance was increased. 

Percona sponsor   

[Static and Dynamic Pivots](https://postgresql.verite.pro/blog/2018/06/19/crosstab-pivot.html) — Postgres’s SQL dialect doesn’t have a `PIVOT` feature like Oracle or SQL Server but it’s still possible to pivot data. 

Daniel Vérité   

[Parallel Index Scans in Postgres](http://amitkapila16.blogspot.co.uk/2018/05/parallel-index-scans-in-postgresql.html) — Parallelism started landing in Postgres 2 releases ago, and in the forthcoming Postgres 11 there’s additional support for parallelism with index scans. 

Amit Kapila   

[Fun with SQL: Functions in Postgres](https://www.citusdata.com/blog/2018/06/21/fun-with-sql-functions/) — A look at a few handy functions available in Postgres including `array_agg`, `array_to_string`, `date_trunc` and some JSON operators. 

Craig Kerstiens   

[Using pg_dump and pg_dumpall to Backup PostgreSQL](https://severalnines.com/blog/using-pgdump-and-pgdumpall-backup-postgresql) — pg_dump and pg_dumpall are popular tools used to backup PostgreSQL. Here’s how to use them, with some tips for ensuring you have a proper backup strategy. 

Joshua Otwell    

[Upgrade Your Partitioning From Inheritance to Declarative](http://ashutoshpg.blogspot.com/2018/06/upgrade-your-partitioning-from.html) — Moving from the pre-Postgres 10 way of thinking to the more modern, lower maintenance approach. 

Ashutosh Bapat   

[How Postgres Plans Queries Involving Foreign Tables](http://ashutoshpg.blogspot.com/2018/06/planning-queries-involving-foreign.html) 

Ashutosh Bapat   

[A Pentester's Basic Guide to PostgreSQL Hacking](https://medium.com/@netscylla/pentesters-guide-to-postgresql-hacking-59895f4f007) — If you need to secure a Postgres install, it’s handy to see what the basic approaches being used by the hackers are. 

Netscylla Cyber Security   

[Learn How to Manage and Automate PostgreSQL](https://severalnines.com/resources/whitepapers/postgresql-management-and-automation-clustercontrol?utm_campaign=Performance_Tuning_Campaign_JUNE_2018&utm_content=pg_wp&utm_medium=Paid_Search&utm_source=banner) 

Severalnines sponsor   

[Better Date Manipulation in Postgres Queries](https://robots.thoughtbot.com/better-date-manipulation-in-postgres-queries) 

Derrick Carr  

Events  

[PGConf UK 2018](http://www.pgconf.uk/) — **July 2 - 3 (London, UK)** Will be held on July 3, with an optional training day on July 2, and will be hosted at 30 Euston Square.    

[PGDay.Amsterdam](http://pgday.amsterdam/) — **July 12 (Amsterdam, Netherlands)** Meet & learn from other PostgreSQL users, developers and anyone who’s interested in the most advanced open source database.    

[PGConf Brazil 2018](http://www.pgconf.com.br/2018_en/) — **August 3 - 4 (São Paulo, SP, Brazil)** Two day conference with talks, tutorials, Couch Clinic, FishBowl and Lightning Talks.          

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom