Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause real problems when overused. A while ago, my colleague Jobin wrote a blog post exploring the negative side effects of over-indexing in PostgreSQL: PostgreSQL Indexes Can Hurt Performance: Exploring the Negative Effects and the Costs […]
30
2025
Benchmarking PostgreSQL: The Hidden Cost of Over-Indexing
28
2025
Talking Drupal #499 – Contact Form Initiative
Today we are talking about The Contact Form Initiative, What it is, and how it helped Drupal with guest J. Hogue. We’ll also cover Local Tasks More as our module of the week.
For show notes visit: https://www.talkingDrupal.com/499
Topics
- What is the Contact Form initiative
- What makes up the contact form recipe
- Why did you want to run this initiative
- What are the responsibilities of an initiative lead
- Were there any unexpected speed bumps
- Who was involved
- As a non-backend developer, any hesitation to lead this effort
- What was onboarding like
- What was the timeline
- Any tips for others thinking of leading an initiative
Guests
J. Hogue – oomphinc.com artinruins
Hosts
Nic Laflin – nLighteneddevelopment.com nicxvan John Picozzi – epam.com johnpicozzi Kathy Beck – kbeck303
MOTW Correspondent
Jacob Rockowitz – jrockowitz.com jrockowitz
- Brief description:
- Nodes can have too many local tasks. Only the first few, like View, Edit, Layout, Revisions, and Translate, are used daily. Would you like to hide or reorder less commonly used local tasks, which include Usage, Clone, Devel, and Convert. There is a module for that
- Local Tasks More (local_tasks_more)
- Brief history
- How old: created on November 6th, 2024
- Versions available: 1.0.0-beta2 r
- Maintainership
- Actively maintained
- No security coverage
- Has test coverage
- Does not require much documentation
- No issues
- Usage stats:
- 22 sites
- Maintainer(s):
- jrockowitz (me)
- Module features and usage
- Enter the base routes that support the show more/less task link and alterations.
- Enter the local task id and the altered title and weight. Set the local tasks to FALSE to remove it.
- Enter the number of links to trigger show more/less tasks link/icon from primary and secondary tasks (aka tabs).
25
2025
pgvector: The Critical PostgreSQL Component for Your Enterprise AI Strategy
You’re likely racing to enhance your applications with more intelligent, data-driven capabilities, whether through AI-powered models (which have moved into “must implement now!” territory), advanced search functions, real-time fraud detection, or geospatial analysis. As these demands grow, you face a significant challenge: efficiently storing, managing, and querying high-dimensional vector data within your existing database infrastructure. […]
23
2025
Does FCV Have Any Impact on MongoDB Performance?
It is generally known and established that different database versions provide different sets of features and performance rates. Along with the binary versions, MongoDB has a property called Feature Compatibility Value, which allows administrators to run a binary version without enabling any features that are incompatible with the previous one. This property is generally helpful […]
22
2025
Behind the Scenes: How Percona Support Diagnosed a MongoDB FTDC Freeze
One of our customers recently reported that MongoDB’s diagnostic metrics—collected via FTDC (Full-Time Diagnostic Data Capture)—had stopped updating. As a result, no metrics were being collected, either through diagnostic data files or the getDiagnosticData command. Key metrics such as uptime were no longer progressing. While the cluster remained fully operational, the lack of observability introduced a […]
21
2025
Talking Drupal #498 – DOJ Accessibility Ruling
In this episode of Talking Drupal, we discuss the latest DOJ accessibility ruling and its implications for Drupal with special guest Josh Mitchell. Josh, a seasoned expert who has led teams in digital agencies, governments, and non-profits, sheds light on what the ruling means for state and local governments, the importance of accessibility, and steps to achieve compliance. We also explore the Sa11y module, a powerful tool for enhancing website accessibility, and compare it with the Editorially module. Additionally, we touch on the upcoming MID Camp 2025. Tune in for an insightful discussion on making web content more accessible for all.
For show notes visit: https://www.talkingDrupal.com/498
Topics
- Can you give us an overview of the DOJ Accessibility Ruling
- Does this apply to federal websites
- When does this go into effect
- How does this affect current sites
- Hwo is Drupal positioned against this
- Does this rule apply to all content such as PDFs
- Any tips to organizations
- JS widgets
Resources
- Announcement of the rule
- Full text of the rule – PDF
- Fact sheet for meeting the requirements of the rule
- AXE Core
- Core issue to automate accessibility tests with Nightwatch.js
- Keyboard traps
- COTS – Commercial off the shelf software
- VPATS – Voluntary product accessibility template
- Accessibility Conformance Report (ACR)
- Monsido – Acquia optimize – PDF
- Josh’s blog post
Guests
Joshua “Josh” Mitchell – joshuami.com joshuami
Hosts
Nic Laflin – nLighteneddevelopment.com nicxvan John Picozzi – epam.com johnpicozzi Kathy Beck – kbeck303
MOTW Correspondent
Martin Anderson-Clutz – mandclu.com mandclu
- Brief description:
- Have you ever wanted your Drupal site to have a built-in accessibility tool that could identify things like potential color contrast issues? There’s a module for that
- Module name/project name:
- Brief history
- It’s worth mentioning that the name is a numeronym, so spelled s-a-1-1-y, which plays off of a common way the word “accessibility” is abbreviated
- How old: created in Jan 2018 by Bryan Sharpe (b_sharpe) but the namespace was taken over in Jun 2024 by Mark Conroy (markconroy) of LocalGov Drupal, so the current 3.0.1 release, which supports Drupal 10 and 11, is a completely different module than the original 8.x-1.x branch.
- Maintainership
- Actively maintained, in fact this module came out of the ongoing work being done on the LocalGov distribution and profile
- Security coverage
- Test coverage: no, but the module is effectively just a wrapper for the Sa11y library, which is CMS agnostic and used in the WordPress and Joomla communities as well
- The Sa11y library has its own website, which includes documentation
- Number of open issues: 1 open issues, which isn’t a bug
- Usage stats:
- 62 sites
- Module features and usage
- We did cover the Editoria11y accessibility checker as MOTW all the way back in episode #350, almost 3 years ago, and Sa11y was mentioned at that time. Both modules have had major releases since then, so I thought this week’s episode would be a chance to do an updated comparison
- Sa11y does include some checks that Editoria11y does not, such as color contrast checking and a readability score
- The Editoria11y module, on the other hand, includes site-wide reporting that would be helpful for site admins, as well as a wealth of configuration options including one or more DOM elements to use as the container to check within, a list of elements to exclude, and so on. Recent versions of Editoria11y also include an option for live feedback as you edit, which should work with CKEditor 5, Paragraphs 5 or newer, and Gutenberg
- At the end of the day, however, both projects are intended to provide your content editors with immediate feedback on the accessibility compliance of what they create. So, it’s worth looking at the feedback each tool provides and deciding which one is more useful for your team in particular
21
2025
Speeding Up Percona XtraDB Cluster State Transfers with Kubernetes Volume Snapshots
When using the Percona Operator for MySQL based on Percona XtraDB Cluster (PXC), it’s common to encounter scenarios where cluster nodes request a full State Snapshot Transfer (SST) when rejoining the cluster. One typical scenario where a State Snapshot Transfer (SST) is required is when a node has been offline long enough that the GCache […]
18
2025
Run PostgreSQL on Kubernetes: A Practical Guide with Benchmarks and Best Practices
Remember when running databases in Kubernetes felt like a gamble? When unpredictable storage performance and complex state management made stability a constant battle? Thankfully, those days are largely behind us. With better tools, smarter operators, and field-tested strategies, you can now confidently deploy PostgreSQL on Kubernetes, especially when you need scale, automation, and platform consistency. […]
17
2025
What’s New in MySQL 8.4 LTS: Key Enhancements Explained
MySQL has been evolving rapidly, and with the recent release of MySQL 8.4, there’s a lot to unpack. While MySQL 8.4 is officially dubbed a Long-Term Support (LTS) release, many features introduced between 8.0 and 8.4 have now matured into defaults or become deprecated/removed. This blog provides a comprehensive, side-by-side comparison of the key differences […]
16
2025
How to Extend Percona Monitoring and Management to Add Logging Functionality
Evolution is one of the inherent traits of modern software. Many people reach out to product teams daily, asking to add more functionality to the software products they use and love. This is understandable: there will always be ways to make a product better by adding more features to the users’ delight so they can […]