18 DECEMBER 2014: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.4, the latest version of the world's leading open source database system. This release adds many new features which enhance PostgreSQL's flexibility, scalability and performance for many different types of database users, including improvements to JSON support, replication and index performance.

Flexibility

With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can have both at the same time. JSONB supports fast lookups and simple expression search queries using Generalized Inverted Indexes (GIN). Multiple new support functions enable users to extract and manipulate JSON data, with a performance which matches or surpasses the most popular document databases. With JSONB, table data can be easily integrated with document data for a fully integrated database environment.

"JSONB brings PostgreSQL to the JavaScript development community by allowing JSON data to be stored and queried natively. Node.js and other server-side JavaScript frameworks can benefit from the safety and robustness of PostgreSQL, while still storing data in the schema-less format that they prefer," said Matt Soldo, Product Manager, Heroku Postgres.

Scalability

In 9.4, Logical Decoding supplies a new API for reading, filtering and manipulating the PostgreSQL replication stream. This interface is the foundation for new replication tools, such as Bi-Directional Replication, which supports the creation of multi-master PostgreSQL clusters. Other improvements in the replication system, such as replication slots and time-delayed replicas, improve management and utility of replica servers.

"The main reason behind our immediate adoption of PostgreSQL 9.4 in production is the new Logical Decoding feature," said Marco Favale, Cartographic Production Manager of Navionics. "The ability to write custom and flexible output plugins will allow us to transparently collect changes on selected tables and replicate changes where we like, by removing heavier - and more complex to manage - trigger based replication solutions."

"Zalando relies on the stability and performance of hundreds of PostgreSQL database servers to continuously serve millions of customers all around Europe," said Valentine Gogichashvili, Team Lead Database Operations at Zalando Technologies. "We are excited to run time-delayed standby servers which work out of the box, and will evaluate the new bi-directional replication tools as soon as they are released."

Performance

Version 9.4 also introduces multiple performance improvements which will allow users to get even more out of each PostgreSQL server. These include:

• Improvements to GIN indexes, making them up to 50% smaller and up to 3X faster.
• Concurrently updatable Materialized Views for faster, more up-to-date reporting.
• Rapidly reload the database cache on restart using pg_prewarm.
• Faster parallel writing to the PostgreSQL transaction log.
• Support for Linux Huge Pages for servers with large memory.

"We will definitely benefit from concurrent refresh of materialised views, delayed standby servers (which will make our disaster recovery even more robust) as well as the usual performance improvements every new release carries on," added Marco Favale.

Links

• Downloads
• Press Kit
• Release Notes
• What's New in 9.4

About PostgreSQL

PostgreSQL is the leading open source database system, with a global community of thousands of users and contributors and dozens of companies and organizations. The PostgreSQL Project builds on over 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability. Learn more about PostgreSQL and participate in our community on our web page.

U.K. Prime Minister David Cameron is leading a global charge to stamp out child sexual abuse material (CSAM) online, dedicating funding, resources and a personal passion to the effort.

Last week in London, the prime minister held the first-ever global summit entitled “#WePROTECT Children Online,” designed to seek coordinated global action, explore technological solutions and create an international network to protect children from online sexual exploitation. The Summit brought together representatives from more than 50 countries, 26 technology companies, 10 non-governmental organizations and a host of law enforcement agencies to pledge their ongoing support.

“[A] global gathering like this is long overdue,” the prime minister said in his keynote address. “We have international summits to stamp out drug dealing, to beat modern-day slavery, and this is another major international crime of our age.”

Concrete, tangible outcomes were demanded, and the U.K. government stepped up to lead and deliver on that mandate in a big way. To assist with the plight of child victims, the U.K. government is putting 50 million pounds, over the course of five years, into a new fund to be managed by UNICEF. The fund will help identify, rescue and aid child victims as they seek to rebuild their lives following unspeakable physical, mental and emotional trauma. In a separate 10 million pound effort, the U.K. government will increase the number of specialist crimefighters within the U.K.’s National Crime Agency, being that law enforcement resources and highly trained personnel have long been in short supply to combat these particularly heinous crimes. The prime minister also announced pending changes to U.K. law that would make it a criminal offense to send a sexual communication to a child.

“If you ask a child to take their clothes off and send you a picture, you are as guilty as if you did that in person,” Cameron said. “Just as it is illegal to produce and possess images of child abuse, now we’re making it illegal for an adult to send a sexual communication to a child. This law will make it clear this is a crime and you will be arrested and prosecuted if you take part in it.”

I had the honor of representing Microsoft at the global summit and delivering an address that summarized the company’s ongoing and longstanding commitment to protecting children — and, indeed, all individuals — as they live out their digital lives. I noted that Microsoft approaches online safety and child online protection with four key areas in mind: technology, self-governance, education and partnerships.

First and foremost, we’re a technology company, and we have a responsibility to seek to create software, devices and services that have safety features, functionality and considerations built in from the outset. In addition, we devise and implement internal online safety policies, standards and procedures that extend beyond pure legal requirements in an effort to self-govern product development and operations. We also have a responsibility to stay abreast of the risks that individuals and families may face online; alert consumers to such developments and educate them about how they can help protect themselves and their families. Perhaps most importantly, we embrace a “multi-stakeholder” model, and partner with others because no one entity or organization can successfully tackle these significant and nuanced issues alone.

I recounted that Microsoft first came to understand the magnitude of the online horror that is child sexual exploitation (sometimes misguidedly referred to as “child pornography”) in 2003, when a lead detective with the Toronto Police Department sent an email to our then-CEO Bill Gates. The detective asked for help from technology to track down purveyors of child sexual abuse material and for assistance with his goal of rescuing child victims. After years of witnessing and experiencing the challenges that child advocates, law enforcement and the technology industry faced in their efforts to stem the online flow of CSAM, Microsoft was privileged to work with the U.S. National Center for Missing and Exploited Children (NCMEC) and Dartmouth College to help address the problem. In 2009, Microsoft and Dartmouth developed PhotoDNA, a technology that aids in finding and removing from the Internet some of the “worst of the worst” of these images. We donated PhotoDNA to NCMEC that same year, and now license it for free to 45 international organizations — all playing a role in helping to rid the Web of this vile imagery.

I also hinted at some upcoming developments with respect to technology, an ongoing technology partnership pilot, research and awareness-raising. More on these in due course.

As I did in my formal remarks at the event, I thank and applaud the U.K. government for shining a bright, global spotlight on a dark and serious issue and for highlighting the gravity of not just online child exploitation, but the need for the online protection of children and our global society at large. We need to continue to work together to find new and inventive ways to bring attention to these issues; to stop the spread of this abhorrent content; to rescue child victims and to prosecute perpetrators.

For more on Microsoft’s work in Online Safety and Child Online Protection, visit our Safety & Security Center; “like” us on Facebook; follow us on Twitter, and look for my “point of view” following the #MSFTCOSO hashtag.

About the Author

Jacqueline Beauchere

Chief Online Safety Officer, Microsoft

Jacqueline F. Beauchere is the Chief Online Safety Officer at Microsoft. In this role, Ms. Beauchere is responsible for all aspects of Microsoft’s online safety strategy, including cross-company policy creation and implementation, influence over consumer safety features and functionality, and communications to and engagement with a variety of external audiences. She also currently serves as the chair of the National Cyber Security Alliance (NCSA) Board of directors, and is Microsoft’s representative to the Family Online Safety Institute (FOSI) board, as well as INHOPE’s Advisory Board. Ms. Beauchere has spent almost 15 years at Microsoft leading various groups and efforts that evangelize the company's commitment to help create a safer, more trusted Internet experience for people of all ages and abilities. Before joining Microsoft in December 1999, Ms. Beauchere was an attorney in private practice in New Jersey, New York and Washington, D.C. A second-career lawyer, she spent 12 years as a real-time financial news correspondent and Editor in Charge, most recently with Reuters America Inc. in New York.

??????? VMware ??????? ??????? ? ??????????? NetApp Insight, ??????????? ? …

Read More