How to Get the Best Out of PostgreSQL Logs - 2ndQuadrant | PostgreSQL

https://www.2ndquadrant.com/en/blog/how-to-get-the-best-out-of-postgresql-logs/ 

Tweet from TweetCaster

@OracleDevs: 🎥 The top 12 new features in APEX 20.1, including faceted search enhancements & native interactive grid PDF printing. #orclapex

http://oracl.info/kDhO50BdPKl
Shared via TweetCaster 

Fwd: Parallelism, vacuuming, and trusted extensions

Plus more news, tutorials, and tips from the Postgres world this week.

#371 — September 2, 2020 Web Version Postgres Weekly An Overview of Trusted Extensions in PostgreSQL 13 — Postgres supports extensions as a way to easily introduce new features and functions dynamically, but in Postgres 13 there'll be the concept of a trusted extension which will allow any user with CREATE privileges on the current database to bring in an extension without superuser privileges. Nidhi Bansal Tuning Autovacuum for Postgres Databases — Most of the time you don't need to tweak the settings for autovacuum as Postgres will generally do the right thing, but sometimes the default configuration just isn't enough and this article will help you with some approaches for tuning things. Laurenz Albe Best-Practices on How to Speed Up Your Postgres Queries. Free eBook — Companies like Robinhood and Atlassian are able to speed up their queries by orders of magnitude. This eBook shares our best practices for optimizing Postgres performance. pganalyze sponsor Three Easy Things To Remember About Postgres Indexes — Basic ideas, but worth reviewing if you're not an index expert. Indexes can speed things up beyond simple queries, indexes aren't always used even if you think they should be, and indexes add maintenance and storage overhead you need to be prepared to manage. Kat Batuigas Parallelism Comes to VACUUM in Postgres 13 — One of the noteworthy new features in Postgres 13 will be the ability to speed up the execution time of index vacuuming. Masahiko provides a quick example of the benefits. Masahiko Sawada How JSON Aggregate Functions Are Pretty Cool — Rather than extract data with SQL queries and then convert it into JSON, you could get Postgres to do the heavy lifting instead and here's how. Knut Hühne The Need for External Compression Methods in Postgres — If you could specify different compression systems for different tables or columns, based upon the most appropriate one for the type of data stored, that would be pretty neat.. and it seems the Postgres team are beginning to discuss such a potential feature in Postgres. Amit Khandekar Using Envoy Proxy's New PostgreSQL & TCP Filters to Collect SQL Statistics — The new PostgreSQL filter from Envoy Proxy makes it easy for developers and ops engineers to collect SQL statistics. YugabyteDB sponsor Benchmarking Checkpointing in Postgres — Evaluating checkpointing with varying log sizes from 1GB to 100GB. Vadim Tkachenko Full-Text Search Battle: Postgres vs Elasticsearch — Less a battle and more a basic comparison of techniques with a simple benchmark, but may be of interest. Rocky Warren Pitfalls and Quirks of Logical Replication in Postgres 12 — "I'd like to share some thoughts after setting up a logical replication in a large-ish (one terabyte) production database." Elephant Tamer

Curated by Cooperpress, Peter Cooper, and Craig Kerstiens. Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom

[UPDATE] Clipdiary v5.5

Tom Breed shared this article with you from Inoreader [UPDATE] Clipdiary v5.5 Via The Portable Freeware Collection Clipdiary is a clipboard manager that records all data that is copied, making it easy to retrieve any piece of information previously on the Windows clipboard, even after system reboots. The customizable interface and hotkeys make it easy to reference a history of clipboard elements. The program includes database encryption, application blocklist (both to avoid conflicts with games and security programs) and much more. View on the web Inoreader. Take back control of your news feed. Follow us on Twitter and Facebook.