by Avinash Vallarapu | Jul 30, 2019 | PostgreSQL
There is always a need for profiling tools in databases for admins or developers. While it is easy to understand the point where an SQL is spending more time using EXPLAIN or EXPLAIN ANALYZE in PostgreSQL, the same would not work for functions. Recently, Jobin has...
by Ibrar Ahmed | Jul 30, 2019 | PostgreSQL
PostgreSQL is one of the finest object-relational databases, and its architecture is process-based instead of thread-based. While almost all the current database systems utilize threads for parallelism, PostgreSQL’s process-based architecture was implemented...
by Avinash Vallarapu | Jul 22, 2019 | PostgreSQL
In my previous blog post, we have seen how the extension hypopg can be helpful in creating hypothetical indexes in PostgreSQL. If you have read it already, you know that it is very useful in verifying whether an Index can improve the performance of an SQL without...
by Jobin Augustine | Jul 16, 2019 | PostgreSQL
BRIN Index was introduced in PostgreSQL 9.5, but many users postponed the usage of it in their design and development just because it was “new”. But now we understand that it has stood the test-of-time! It is time to reconsider BRIN if you have not done it yet. I...
by Jobin Augustine | Jul 10, 2019 | PostgreSQL
WAL retention is a very important topic for PostgreSQL database management. But very often we come across DBAs getting into surprise situations such as: 1. Several TBs of WALs piled up in archive destination 2. WALs filling up pg_wal/pg_xlog directory due to failing...
by Ibrar Ahmed | Jul 1, 2019 | PostgreSQL
I want to thank everybody who attended my session “Deep Dive in PostgreSQL Indexes” in Austin. It was quite a wonderful experience! To cover a bigger audience, I also did a webinar on the same topic. There were many questions in that webinar, but unfortunately, there...
by Jobin Augustine | Jun 24, 2019 | PostgreSQL
Introduction Those DBAs who are experts in one database system look for other database systems to have “similar features”. It is a human tendency to look at any new technology and compare it with a world they are familiar with. Most of the time, I keep...
by Avinash Vallarapu | Jun 21, 2019 | PostgreSQL
At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?”. The answer to that question is EXPLAIN <QUERY>. However, if you...
by Avinash Vallarapu | Jun 14, 2019 | PostgreSQL
There is a wide variety of indexes available in PostgreSQL. While most are common in almost all databases, there are some types of indexes that are more specific to PostgreSQL. For example, GIN indexes are helpful to speed up the search for element values within...
by Jobin Augustine | Nov 19, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
Just-in-time (JIT in PostgreSQL) compilation of SQL statements is one of the highlighted features in PostgreSQL 11. There is great excitement in the community because of the many claims of up to a 30% jump in performance. Not all queries and workloads get the benefit...
by Ibrar Ahmed | Oct 12, 2018 | PostgreSQL, Security
Authorisations and encryption/decryption within a database system establish the basic guidelines in protecting your database by guarding against malicious structural or data changes. What are authorisations? Authorisations are the access privileges that mainly control...
by Ibrar Ahmed | Aug 29, 2018 | Insight for DBAs, PostgreSQL
For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are...
by Avinash Vallarapu | Jun 15, 2018 | Benchmarks, PostgreSQL
Percona has a long tradition of performance investigation and benchmarking. Peter Zaitsev, CEO and Vadim Tkachenko, CTO, led their crew into a series of experiments with MySQL in this space. The discussion that always follows on the results achieved is well known and...
by Dave Avery | Mar 7, 2018 | Percona Live, PostgreSQL, Security
Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post...
by Borys Belinsky | Feb 12, 2018 | MariaDB, MongoDB, Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Dave Avery | Dec 29, 2017 | Benchmarks, MariaDB, MongoDB, MySQL
Let’s look at some of the most popular Percona Database Performance Blog posts in 2017. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open...
by Colin Charles | Nov 13, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
Announcing the opening of the Percona Live Open Source Database Conference 2018 in Santa Clara, CA, call for papers. It will be open from now until December 22, 2017. Our theme is “Championing Open Source Databases,” with topics of MySQL, MongoDB and other open...
by Lorraine Pocklington, Community Manager | Sep 29, 2017 | MongoDB, Percona Live, PostgreSQL
The Percona Live Europe 2017 conference has been going strong for two days, and I’ve been to a bunch of presentations. An excellent one was High-Performance JSON – PostgreSQL Vs. MongoDB with Wei Shan Ang and Dominic Dwyer of GlobalSign. This talk was very...
by Manjot Singh | Sep 7, 2017 | MySQL
In this blog post, I’ll look at a comparison of PostgreSQL and MySQL. I came across a post from Hans-Juergen Schoenig, a Postgres consultant at Cybertec. In it, he dismissed MySQL and showed Postgres as better. While his post ignores most of the reasons why...
by Dave Avery | Sep 7, 2017 | MySQL, Percona Live, PostgreSQL
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
