Fri, 10 Feb 2023 12:37:27 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/postgresql-are-all-nulls-the-same/ https://www.percona.com/blog/postgresql-are-all-nulls-the-same/#respond Fri, 04 Nov 2022 12:07:54 +0000 https://www.percona.com/blog/?p=83414 I was recently reading the PostgreSQL 15 release notes and stopped at “Allow unique constraints and indexes to treat NULL values as not distinct”. At first glance, it seems to be a minor change, but this feature may change many designs and make many lives a lot easier.The first thing here is to understand what […]]]> https://www.percona.com/blog/postgresql-are-all-nulls-the-same/feed/ 0 83414 https://www.percona.com/blog/should-i-create-an-index-on-foreign-keys-in-postgresql/ https://www.percona.com/blog/should-i-create-an-index-on-foreign-keys-in-postgresql/#comments Thu, 18 Nov 2021 13:55:14 +0000 https://www.percona.com/blog/?p=79010 Welcome to a weekly blog where I get to answer (like, really answer) some of the questions I’ve seen in the webinars I’ve presented lately. If you missed the latest one, PostgreSQL Performance Tuning Secrets, it might be helpful to give some of it a listen before or after you read this post. Each week, […]]]> https://www.percona.com/blog/should-i-create-an-index-on-foreign-keys-in-postgresql/feed/ 5 79010 https://www.percona.com/blog/postgresql-pl-java-a-how-to-part-2-how-to-manipulate-and-return-tuples/ https://www.percona.com/blog/postgresql-pl-java-a-how-to-part-2-how-to-manipulate-and-return-tuples/#respond Tue, 10 Aug 2021 14:27:33 +0000 https://www.percona.com/blog/?p=77606 We discussed how to install and create a simple class in the first part of this series where we ran a SELECT and returned one row with one column with a formatted text. Now it’s time to expand and see how to return multiple tuples. A little disclaimer here; I’m not going to comment much […]]]> https://www.percona.com/blog/postgresql-pl-java-a-how-to-part-2-how-to-manipulate-and-return-tuples/feed/ 0 77606 https://www.percona.com/blog/postgresql-pl-java-how-to-part-1/ https://www.percona.com/blog/postgresql-pl-java-how-to-part-1/#respond Thu, 29 Jul 2021 12:00:54 +0000 https://www.percona.com/blog/?p=77428 We’ve recently received some questions regarding PL/Java and I found it hard to get clear instructions searching on the internet. It’s not that there is no good information out there, but most of it is either incomplete, outdated, or confusing and I decided to create this short “how-to” and show how to install it and […]]]> https://www.percona.com/blog/postgresql-pl-java-how-to-part-1/feed/ 0 77428 https://www.percona.com/blog/yearly-reminder-ddls-that-fail-to-propagate-may-cause-percona-xtradb-cluster-inconsistencies/ Fri, 23 Apr 2021 16:55:30 +0000 https://www.percona.com/blog/?p=75338 Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the cluster replicates the schema change query as a […]]]> 75338 https://www.percona.com/blog/how-to-configure-mysql-ssl-with-public-certificates/ https://www.percona.com/blog/how-to-configure-mysql-ssl-with-public-certificates/#comments Fri, 04 Dec 2020 20:17:41 +0000 https://www.percona.com/blog/?p=69584 Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make MySQL validate the certificate signature against the authority public […]]]> https://www.percona.com/blog/how-to-configure-mysql-ssl-with-public-certificates/feed/ 4 69584 https://www.percona.com/blog/postgresql-updatable-views-performing-schema-updates-with-minimal-downtime/ https://www.percona.com/blog/postgresql-updatable-views-performing-schema-updates-with-minimal-downtime/#comments Thu, 10 Jan 2019 09:35:33 +0000 https://www.percona.com/blog/?p=54565 Recently, one of our customers asked us how to minimize downtime when upgrading the database structure with changes that are not backwards-compatible. It’s an interesting question and I would like to visit some alternatives here. I will use PostgreSQL for this series of posts and walk through updatable views, INSTEAD OF Triggers, and the Rule […]]]> https://www.percona.com/blog/postgresql-updatable-views-performing-schema-updates-with-minimal-downtime/feed/ 1 54565