Planet PostgreSQL – Deepak Mahto: PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease

May 102025
 

PostgreSQL 18 beta has been released, and it’s the perfect time to start exploring the new features we can expect in the General Availability (GA) release. One feature that particularly caught my attention relates to improvements in statistics collection and usage. Here’s an excerpt from the official PostgreSQL release notes:
Add functions to modify per-relation and per-column optimizer statistics (Corey Huinker) Add pg_dump, pg_dumpall, and pg_restore options –statistics-only, –no-statistics, –no-data, and –no-schema (Corey Huinker, Jeff Davis)
One of the key ingredients in performance analysis is understanding the underlying statistics of tables, columns, and indexes. Often, we encounter cases where queries behave differently in production compared to Pre-Prod or UAT environments. A common reason for this discrepancy…

External feed Read More at the Source: https://postgr.es/p/773

 2025-05-10  No Responses »

Ars Technica – Industry groups are not happy about the imminent demise of Energy Star

May 102025
 

It’s a voluntary program launched during a Republican administration, endorsed by manufacturers and well-recognized by U.S. consumers, who have saved an estimated $500 billion over the past 33 years guided by its familiar blue label.

But President Donald Trump’s administration has decided the Energy Star program has got to go.

CNN and The Washington Post first reported the plan to eliminate the program that certifies the most energy-efficient appliances and buildings with the Energy Star label. Knowledgeable sources have confirmed to Inside Climate News that Environmental Protection Agency staffers learned the details at an internal meeting earlier this week.

Read full article

Comments

External feed Read More at the Source: https://arstechnica.com/tech-policy/2025/05/industry-groups-are-not-happy-about-the-imminent-demise-of-energy-star/

 2025-05-10  No Responses »