Sat, 10 Feb 2024 00:33:52 +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/understand-your-postgresql-workloads-better-with-pg_stat_monitor/ https://www.percona.com/blog/understand-your-postgresql-workloads-better-with-pg_stat_monitor/#comments Thu, 05 May 2022 15:49:39 +0000 https://www.percona.com/blog/?p=80890 Awesome news, pg_stat_monitor has reached a GA STATUS!  Percona has long been associated with pushing the limits and understanding the nuances involved in running database systems at scale, so building a tool that helps get us there brings a bit more insight and details around query performance and scale on PostgreSQL systems fits with our […]]]> https://www.percona.com/blog/understand-your-postgresql-workloads-better-with-pg_stat_monitor/feed/ 5 80890 https://www.percona.com/blog/poweron-your-voice-at-percona-live-2022/ https://www.percona.com/blog/poweron-your-voice-at-percona-live-2022/#respond Thu, 10 Mar 2022 12:58:53 +0000 https://www.percona.com/blog/?p=80329 Percona Live 2022 is comin’ in hot as May 16-18 draws near. This year, we will be supercharging open source conversations, community, and expertise by welcoming the best and brightest open source database users to Austin, Texas for three days of knowledge sharing.Have a unique perspective on open source database tech? Percona Live attendees would […]]]> https://www.percona.com/blog/poweron-your-voice-at-percona-live-2022/feed/ 0 80329 https://www.percona.com/blog/ideas-topics-and-suggested-topics-for-percona-live-2022/ https://www.percona.com/blog/ideas-topics-and-suggested-topics-for-percona-live-2022/#respond Tue, 08 Mar 2022 12:04:34 +0000 https://www.percona.com/blog/?p=80299 I have had a lot of conversations with people interested in participating in Percona Live this year, but are looking for ideas on what talks or tutorials to submit.  I decided to put together a list of topics I think would make great sessions and topics I have heard you in the community ask about.  Generally […]]]> https://www.percona.com/blog/ideas-topics-and-suggested-topics-for-percona-live-2022/feed/ 0 80299 https://www.percona.com/blog/help-percona-make-better-databases/ https://www.percona.com/blog/help-percona-make-better-databases/#respond Fri, 14 Jan 2022 13:10:44 +0000 https://www.percona.com/blog/?p=79811 Hello everyone!  The new year is upon us and we are looking at planning some awesome new features, enhancements, and ideas in 2022.  One of the things we could really use your help on, however, is providing us with feedback on how we are doing and what we can do to improve our database products.  […]]]> https://www.percona.com/blog/help-percona-make-better-databases/feed/ 0 79811 https://www.percona.com/blog/application-and-database-design-small-things-can-have-a-big-impact/ https://www.percona.com/blog/application-and-database-design-small-things-can-have-a-big-impact/#comments Wed, 05 Jan 2022 14:27:28 +0000 https://www.percona.com/blog/?p=79653 With modern application design, systems are becoming more diverse, varied and have more components than ever before. Developers are often forced to become master chefs adding the ingredients from dozens of different technologies and blending them together to create something tasty and amazing. But with so many different ingredients, it is often difficult to understand […]]]> https://www.percona.com/blog/application-and-database-design-small-things-can-have-a-big-impact/feed/ 3 79653 https://www.percona.com/blog/custom-percona-monitoring-and-management-metrics-in-mysql-and-postgresql/ https://www.percona.com/blog/custom-percona-monitoring-and-management-metrics-in-mysql-and-postgresql/#comments Thu, 14 Oct 2021 11:50:04 +0000 https://www.percona.com/blog/?p=78706 A few weeks ago we did a live stream talking about Percona Monitoring and Management (PMM) and showcased some of the fun things we were doing at the OSS Summit.  During the live stream, we tried to enable some custom queries to track the number of comments being added to our movie database example.  We […]]]> https://www.percona.com/blog/custom-percona-monitoring-and-management-metrics-in-mysql-and-postgresql/feed/ 1 78706 https://www.percona.com/blog/using-the-multirange-data-type-in-postgresql-14/ https://www.percona.com/blog/using-the-multirange-data-type-in-postgresql-14/#respond Thu, 07 Oct 2021 13:46:11 +0000 https://www.percona.com/blog/?p=78501 Don’t miss the great overview of PostgreSQL 14 that Umair Shahid recently put together, PostgreSQL 14 – Performance, Security, Usability, and Observability!Range data types have been in Postgresql for some time now, however, as of PostgreSQL 14, we have seen the introduction of multi-range data types.  Before we cover that, let’s cover the basics of […]]]> https://www.percona.com/blog/using-the-multirange-data-type-in-postgresql-14/feed/ 0 78501 https://www.percona.com/blog/using-new-json-syntax-in-postgresql-14-update/ https://www.percona.com/blog/using-new-json-syntax-in-postgresql-14-update/#respond Tue, 05 Oct 2021 12:55:07 +0000 https://www.percona.com/blog/?p=78504 As previously mentioned here on the blog, PostgreSQL 14 was just released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability.I recently did a deep-dive into using JSON from within PostgreSQL in a two blog post series titled Storing and using JSON within PostgreSQL, While […]]]> https://www.percona.com/blog/using-new-json-syntax-in-postgresql-14-update/feed/ 0 78504 https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-two https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-two#respond Wed, 08 Sep 2021 12:21:32 +0000 https://www.percona.com/blog/?p=78018 We explored the basic functionality of JSON within PostgreSQL in Part One of this series. Now we will look a little deeper into some things we may want to use regularly.  Most of the functionality we talked about in part one works well when you have a simple JSON format.  However, in real life, our […]]]> https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-two/feed/ 0 78018 https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-one/ https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-one/#comments Fri, 03 Sep 2021 11:32:21 +0000 https://www.percona.com/blog/?p=77983 Continuing our series on storing JSON directly within your database, we are now looking at the JSON functionality built into PostgreSQL.  You can see the first two posts in this series exploring MySQL’s JSON functionality with Storing JSON in Your Databases: Tips and Tricks For MySQL Part One and Storing JSON in Your Databases: Tips […]]]> https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-one/feed/ 1 77983 https://www.percona.com/blog/storing-json-in-your-databases-tips-and-tricks-for-mysql-part-two/ https://www.percona.com/blog/storing-json-in-your-databases-tips-and-tricks-for-mysql-part-two/#comments Fri, 20 Aug 2021 12:50:56 +0000 https://www.percona.com/blog/?p=77838 JSON Structure, The Next Generation (Performance, Scale, and Fun)Now you know the basic JSON functionality available to you, as covered in part one of this series.  Let’s look deeper into performance, scale, and oddities that may occur.You can do almost anything you could do in SQL with standard data types and objects, but you may […]]]> https://www.percona.com/blog/storing-json-in-your-databases-tips-and-tricks-for-mysql-part-two/feed/ 1 77838 https://www.percona.com/blog/storing-json-in-your-databases-tips-mysql/ https://www.percona.com/blog/storing-json-in-your-databases-tips-mysql/#respond Thu, 19 Aug 2021 12:47:07 +0000 https://www.percona.com/blog/?p=77805 Database architecture and design are becoming an increasingly lost art. With new technologies and the push towards faster development cycles, people continue to take shortcuts, often to the detriment of long-term performance, scalability, and security. Designing how your application stores, accesses, and processes data is so fundamentally important, it can not be overlooked. I want […]]]> https://www.percona.com/blog/storing-json-in-your-databases-tips-mysql/feed/ 0 77805 https://www.percona.com/blog/war-stories-and-learning-from-others-percona-live/ Mon, 10 May 2021 13:00:29 +0000 https://www.percona.com/blog/?p=75966 Lessons Learned – Learning from those who blazed the trail!Another cool thing I like about attending conferences is learning from how other companies and people overcame problems, how they run their systems, and figure out problems that I may run into in the future. Secretly I also want to validate how I have done things […]]]> 75966 https://www.percona.com/blog/cool-new-projects-technology-and-broadening-my-horizons-at-percona-live/ Fri, 07 May 2021 15:28:00 +0000 https://www.percona.com/blog/?p=75937 I love learning from others and exploring the implementation details other database engines provide. Percona Live has no shortage of new databases, tools, and discussions on interesting new features or ways of tackling old problems. I went through the agenda and wanted to highlight a few new databases and tools (new to me or new […]]]> 75937 https://www.percona.com/blog/percona-live-sessions-for-engineers-working-on-building-and-developing-databases/ Thu, 06 May 2021 15:13:18 +0000 https://www.percona.com/blog/?p=75927 We are in the “home stretch” for Percona Live and I am continuing to highlight some of the great content out there!  Today I would like to focus on content I think will be very interesting to the developers and contributors who are working on the core elements of open source database projects.  We have […]]]> 75927 https://www.percona.com/blog/hoss-talks-foss-the-podcast-is-now-available/ Wed, 24 Feb 2021 14:41:35 +0000 https://www.percona.com/blog/?p=74571 Great news!  Percona’s Community-focused podcast, hosted by none other than the HOSS (Head of Open Source Software) himself (yeah, that is me), is now available on almost all podcast platforms.What? You didn’t know we had a podcast?We do, and we’ve had some great episodes since we started in January. In fact, we just published our […]]]> 74571 https://www.percona.com/blog/the-most-important-skills-for-an-sre-dbre-or-dba/ Wed, 17 Feb 2021 19:59:15 +0000 https://www.percona.com/blog/?p=74520 I have talked extensively about the DBA’s evolving role and how many DBA’s and operations professionals are now becoming SRE’s (site reliability engineers) or DBRE’s (database reliability engineers). Often, databases get blamed as the bottleneck for application slowdowns and issues, so DBAs have had to develop the skills needed to chase problems up and down […]]]> 74520 https://www.percona.com/blog/mongodb-sharding-replication-101-the-communitys-questions-answered/ Tue, 09 Feb 2021 13:56:11 +0000 https://www.percona.com/blog/?p=74372 A few weeks ago I sat down and talked about tuning MongoDB memory settings with Mike Grayson, one of our MongoDB Database Engineers here at Percona. If you have not seen the video I would recommend it.  Since then I have heard from people in the community about other topics they would like to see.  […]]]> 74372 https://www.percona.com/blog/fosdem-is-this-weekend-matt-yonkovits-must-see-sessions/ Fri, 05 Feb 2021 13:00:40 +0000 https://www.percona.com/blog/?p=74292 If you have not heard, this weekend is FOSDEM.  FOSDEM this year is virtual (and open to all), and it looks like it is going to be an absolutely stellar lineup of open source content.  The details:  February 6-7th, 2021, with over 600 speakers, over 700 sessions, and 113 tracks!  So much to see.   […]]]> 74292 https://www.percona.com/blog/introducing-percona-live-community-rooms/ Wed, 03 Feb 2021 15:13:36 +0000 https://www.percona.com/blog/?p=74255 Something new and exciting this year for Percona Live ONLINE is the inclusion of “Community Rooms”.  Every year we struggle with fitting in as many sessions as we can into Percona Live.  As the largest open-source database conference, we want to be inclusive of as many different projects and database technologies as possible.  We recognize […]]]> 74255