#246: The Postgres 10 feature you didn’t know about

存储架构 Postgres Weekly (源链)

#246 — March 7, 2018

Read on the Web

Postgres Weekly

CREATE STATISTICS, The Postgres 10 Feature You Didn’t Know About — One key way Postgres’s planner chooses how to handle a query is through statistics it has collected. In some cases you could make things more efficient by telling Postgres to collect the right statistics, and this is where CREATE STATISTICS comes in.

Samay Sharma

PostgresConf US 2018: One Month Until National — PostgresConf US 2018 is around the corner. We are counting down the days until April 16 – 20 at the Westin Jersey City Newport, where hundreds of people from around the globe will be experiencing the largest Postgres conference event in North America.

PostgresConf.org sponsor

pgmetrics: Get Statistics from Live Postgres Servers — Aims to be “the simplest way to collect comprehensive information and statistics from a running PostgreSQL cluster” . It’s open source & available now.Homepage &GitHub repo.


PostgreSQL Meltdown Benchmarks — In January, people were worried about the performance effects of fixes for the Meltdown and Spectre vulnerabilities. Now, however, have come some deeper benchmarks for Postgres showing the impact isn’t as bad as first thought and is as potentially small as 5%.


zheap: A Storage Engine to Better Control Bloat? — zheap can prevent bloat by allowing in-place updates and reusing space as soon as a transaction that has performed a delete or non-in-place update has committed. It’s being proposed as a feature for Postgres 12 .

Amit Kapila

Postgres 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22 Released — Billed as the March Security Update Release , these releases mitigate CVE-2018-1058 , a vulnerability describing how a user can create like-named objects in different schemas that can change the behavior of other users’ queries and cause unexpected or malicious behavior.


Go Deep into Today’s Modern Data Tier to See the Root of the Problem Fast

SelectStar sponsor

PGDay UK 2018 (July 3, London) Call for Papers Open — The deadline for submissions is March 31 2018.


pgcli 1.9.0 Released — A command line interface for Postgres with auto-completion and syntax highlighting. This release adds pset pager and T to control output, as well as --list-dsn .

Irina Truong

Detecting Performance Problems with pg_stat_statements — An official PG module that can track execution statistics of all queries executed by a server.

Hans-Jürgen Schönig

Postgres 10: A Great New Version for a Great Database

Reuven M. Lerner


Setting up global replication of your Azure Cosmos... Azure Cosmos DBis a globally distributed, low-latency, high throughput databases services. Azure Cosmos DB provides global distribution, which means ...
How to enable trusted mode in HPUX What is Trusted mode in HPUX? In trusted mode HPUX OS will turned on the system auditing.With system auditing we can trace each and every sy...
如何用Python动手写一个NoSQL数据库? 本文完整的示例代码已经放到了GitHub上,这仅是一个极简的Demo,旨在动手了解概念。 (链接 https://github.com/liuchengxu/hands-on-learning/blob/master/nosql.py ) NoSQL 这个词在近些年正...
Class & amp; Method in C #&am... I am trying to build a class that interacts with the database in my asp.net web application. I need your opinion on how to design it, here's an exampl...
So You Want a Cheap Disaster Plan There’s a lot that goes into a Disaster Recovery plan. One of them is offsite backups. There are some businesses that don’t have backups going offsite...
Postgres Weekly责编内容来自:Postgres Weekly (源链) | 更多关于

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » #246: The Postgres 10 feature you didn’t know about

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录