Jun 042023

The 8-1 ruling throws open the door for employers to sue unions for damages in the event of a strike, implying that strikes are only allowed so long as they do not in any way harm the company’s bottom line.

External feed Read More at the Source: https://www.wsws.org/en/articles/2023/06/03/canx-j03.html

 2023-06-04  Comments Off on World Socialist Web Site (en) – US Supreme Court issues far-reaching attack on the right to strike
Jun 042023

One of the big topics in Postgres is bloat. It is something that every DBA comes across and in fact we have a few good posts on how to work with bloat in our blog. 
Update-heavy tables is a special case of data that due to business requirements needs to be updated frequently to stay relevant. Autovacuum may be a good solution for table bloat (you can check this post describing how to do that), however it does not help with index bloat. 
Pg_index_watch resolves this issue by automatically rebuilding indexes when needed. 
How it works?
With the introduction of REINDEX CONCURRENTLY in PostgreSQL 12 there was finally a safe way to rebuild indexes without heavy locks. At the same…

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

 2023-06-04  Comments Off on Planet PostgreSQL – Maxim Boguk: Please welcome Pg_index_watch – a utility for dealing with index bloat on frequently updated tables.
Jun 042023

A poison pill buried within the new debt ceiling deal would “gut” key elements of the nation’s bedrock environmental law in exchange for preventing a national default and could make it easier for highway-building agencies to expedite road projects that harm vulnerable communities for generations, advocates warn.
After tense negotiations with GOP lawmakers, a sprawling bill that would authorize the treasury to raise the debt limit in time to prevent a catastrophic June 5 default. Known in Washington as the Fiscal Responsibility Act of 2023, it includes a set of provisions that opponents say have “nothing to do” with the country’s ability to pay its creditors, but would have everything to do with enshrining car dependency on…

External feed Read More at the Source: https://usa.streetsblog.org/2023/06/02/the-debt-ceiling-deal-could-be-bad-news-for-freeway-fighters/

 2023-06-04  Comments Off on Streetsblog.org – The Debt Ceiling Deal Could Be Bad News For Freeway Fighters
Jun 042023

Postgres 16 is hot off the press with the beta release last week. I am really
excited about the new feature that allows logical replication from standbys,
allowing users to:

create logical decoding from a read-only standby
reduce the workload on the primary server
have new ways to achieve high-availability for applications that require data
synchronization across multiple systems or for auditing purposes

A second relevant and exciting new feature coming in 16 is that replication
slots on a given standby persist the promotion of that standby to a primary.
This means that in the event of primary server failure and promotion of a
standby to primary, the replication slots will persist and the former-standby
subscribers will not be affected.
These two together give PostgreSQL a huge boost…

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

 2023-06-04  Comments Off on Planet PostgreSQL – Roberto Mello: Logical Replication on Standbys in Postgres 16