Tag: PostgreSQL

Feed: Planet PostgreSQL. The following commit has happened in Postgres 12, adding a feature which allows to control and potentially enforce the protocol SSL connections can use when connecting to the server: commit: e73e67c719593c1c16139cc6c516d8379f22f182 author: Peter Eisentraut date: Tue, 20 Nov 2018 21:49:01 +0100 Add settings to control SSL/TLS protocol version For example: ssl_min_protocol_version = 'TLSv1.1' ssl_max_protocol_version = 'TLSv1.2' Reviewed-by: Steve Singer Discussion: https://www.postgresql.org/message-id/flat/1822da87-b862-041a-9fc2-d0310c3da173@2ndquadrant.com As mentioned in the commit message, this commit introduces two new GUC parameters: ssl_min_protocol_version, to control the minimal version used as communication protocol. ssl_max_protocol_version, to control the maximum version used as communication protocol. Those can also ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Micro-Optimizations Friday, December 14, 2018 This email thread discusses the tradeoffs of adding optimization improvements that affect only a small percentage of queries, i.e., micro-optimizations. The big sticking point is that we don't know if the time required to check for these optimizations is worth it. For short-running queries, it probably isn't, but for long-running queries, it probably is. The problem is that we don't know the final cost of the ... Read More

Feed: Planet PostgreSQL. PREVIOUS POST PostgreSQL streaming physical replication with slots simplifies setup and maintenance procedures. Usually, you should estimate disk usage for the Write Ahead Log (WAL) and provide appropriate limitation to the number of segments and setup of the WAL archive procedure. In this article, you will see how to use replication with slots and understand what problems it could solve. Introduction PostgreSQL physical replication is based on WAL. Th Write Ahead Log contains all database changes, saved in 16MB segment files. Normally postgres tries to keep segments between checkpoints. So with default settings, just 1GB of WAL segment files is ... Read More

Feed: R-bloggers. Author: John Mount. Pipelines in R are popular, the most popular one being magrittr as used by dplyr. This note will discuss the advanced re-usable piping systems: rquery/rqdatatable operator trees and wrapr function object pipelines. In each case we have a set of objects designed to extract extra power from the wrapr dot-arrow pipe %.>%. Piping Piping is not much more than having a system that lets one treat “x %.>% f(.)” as a near synonym for “f(x)”. For the wrapr dot arrow pipe the semantics are intentionally closer to (x %.>% f(.)) ~ {. . The pipe ... Read More

Feed: Planet PostgreSQL. Near the end of November, Packt published the book PostgreSQL 11 Server Side Programming Quick Start Guide, authored by me. *This post has the only aim of describing the book contents and the reason behind choices related to it.** Following a consolidated tradition, Packt is producing more and more books on PostgreSQL and related technologies, and this is the first one that covers aspects about the freshly released PostgreSQL 11 version. Nevertheless, this does not mean that the book is only for PostgreSQL 11 users and administrators: it covers topics, concepts and provide examples that can be ... Read More

Feed: Yellowbrick Data. Author: Stacy Miles; Yellowbrick Data Warehouse Offers the Most Compatible and Easiest Upgrade Path for Netezza Users PALO ALTO, Calif – Dec. 11, 2018 – In six months, IBM will end support for Netezza Twinfin and Striper data warehouse product lines, forcing enterprise customers to find new solutions for their business-critical analytics. With its hybrid cloud solution, Yellowbrick Data is the simplest, most compatible upgrade for Netezza customers. Many of the world’s largest companies have chosen the Yellowbrick Data Warehouse, including: one of the top five credit card companies, one of the world’s largest insurance companies, a ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Optimizer Hints Wednesday, December 12, 2018 You might know that Postgres has optimizer hints listed as a feature we do not want to implement. I have covered this topic in the past. This presentation from Tatsuro Yamada covers the trade-offs of optimizer hints in more detail than I have ever seen before. Starting on slide 29, Yamada-san explains the number-one reason to use optimizer hints — as a short-term fix for ... Read More

Feed: What's New. You can now publish logs from your RDS for PostgreSQL databases to Amazon CloudWatch Logs in Amazon RDS. Supported logs include PostgreSQL system logs and upgrade logs. Publishing these logs to CloudWatch Logs allows you to maintain continuous visibility into PostgreSQL system logs, and upgrade logs for your PostgreSQL databases. For example, you can set up Amazon CloudWatch Alarms to notify you on frequent restarts which are recorded in the PostgreSQL system log. Similarly, alarms for events recorded in PostgreSQL logs can be created to alert on unwanted changes made to your databases. You may also enable ... Read More

Feed: AWS Partner Network (APN) Blog. Author: AWS Admin. By Henry Axelrod, Partner Solutions Architect at AWSThe ability for modern organizations to share information and documents is more important than ever. In today’s global environment, having file sharing that is limited to a single datacenter is no longer sufficient for many companies. IT administrators need to provide business-efficient ways to share those documents. File sync and share platforms allow companies to share files within their organization, beyond the boundaries of their own datacenter. Instead of accessing all files from a single location, with sync and share the files can be ... Read More

Feed: What's New. In addition, you will now get an Amazon RDS event notification when a new minor version upgrade is available for your database instance or database cluster. This is useful when you are managing a large number of database instances and would like to be notified when engine version upgrades are available. You can consume Amazon RDS event notifications through the Amazon Simple Notification Service (Amazon SNS) or Amazon CloudWatch Events. These enhancements are available for the MySQL, MariaDB, Oracle, PostgreSQL and SQL Server database instances in all AWS Regions ... Read More