OpenStack’s security groups capability is a key feature in its support for multi-tenant workloads. Security groups are sets of rules that users utilize to specify access to their application infrastructure. This access is specified either via a classless inter-domain routing (CIDR) network range or by specifying the name of another security group. Let’s take a […]

The post VMware Integrated OpenStack Video Series: Security Groups appeared first on OpenStack Blog for VMware.

Happy New Year everyone! 2016 will be a very exciting year for Socialcast and we can’t wait to share all the new things currently in the works. But first, let’s take a look back at all the feature enhancements and mobile apps that were released in December to round out 2015.

Read more on Feature and Mobile Updates: December 2015…

7 JANUARY 2016: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.5. This release adds UPSERT capability, Row Level Security, and multiple Big Data features, which will broaden the user base for the world's most advanced database. With these new capabilities, PostgreSQL will be the best choice for even more applications for startups, large corporations, and government agencies.

Annie Prévot, CIO of the CNAF, the French Child Benefits Office, said, "The CNAF is providing services for 11 million persons and distributing 73 billion Euros every year, through 26 types of social benefit schemes. This service is essential to the population and it relies on an information system that must be absolutely efficient and reliable. The CNAF's information system is satisfyingly based on the PostgreSQL database management system."

UPSERT

A most-requested feature by application developers for several years, "UPSERT" is shorthand for "INSERT, ON CONFLICT UPDATE", allowing new and updated rows to be treated the same. UPSERT simplifies web and mobile application development by enabling the database to handle conflicts between concurrent data changes. This feature also removes the last significant barrier to migrating legacy MySQL applications to PostgreSQL.

Developed over the last two years by Heroku programmer Peter Geoghegan, PostgreSQL's implementation of UPSERT is significantly more flexible and powerful than those offered by other relational databases. The new ON CONFLICT clause permits ignoring the new data, or updating different columns or relations in ways which will support complex ETL (Extract, Transform, Load) toolchains for bulk data loading. And, like all of PostgreSQL, it is designed to be absolutely concurrency-safe and to integrate with all other PostgreSQL features, including Logical Replication.

Row Level Security

PostgreSQL continues to expand database security capabilities with its new Row Level Security (RLS) feature. RLS implements true per-row and per-column data access control which integrates with external label-based security stacks such as SE Linux. PostgreSQL is already known as "the most secure by default." RLS cements its position as the best choice for applications with strong data security requirements, such as compliance with PCI, the European Data Protection Directive, and healthcare data protection standards.

RLS is the culmination of five years of security features added to PostgreSQL, including extensive work by KaiGai Kohei of NEC, Stephen Frost of Crunchy Data, and Dean Rasheed. Through it, database administrators can set security "policies" which filter which rows particular users are allowed to update or view. Data security implemented this way is resistant to SQL injection exploits and other application-level security holes.

Big Data Features

PostgreSQL 9.5 includes multiple new features for bigger databases, and for integrating with other Big Data systems. These features ensure that PostgreSQL continues to have a strong role in the rapidly growing open source Big Data marketplace. Among them are:

BRIN Indexing: This new type of index supports creating tiny, but effective indexes for very large, "naturally ordered" tables. For example, tables containing logging data with billions of rows could be indexed and searched in 5% of the time required by standard BTree indexes.

Faster Sorts: PostgreSQL now sorts text and NUMERIC data faster, using an algorithm called "abbreviated keys". This makes some queries which need to sort large amounts of data 2X to 12X faster, and can speed up index creation by 20X.

CUBE, ROLLUP and GROUPING SETS: These new standard SQL clauses let users produce reports with multiple levels of summarization in one query instead of requiring several. CUBE will also enable tightly integrating PostgreSQL with more Online Analytic Processing (OLAP) reporting tools such as Tableau.

Foreign Data Wrappers (FDWs): These already allow using PostgreSQL as a query engine for other Big Data systems such as Hadoop and Cassandra. Version 9.5 adds IMPORT FOREIGN SCHEMA and JOIN pushdown making query connections to external databases both easier to set up and more efficient.

TABLESAMPLE: This SQL clause allows grabbing a quick statistical sample of huge tables, without the need for expensive sorting.

"The new BRIN index in PostgreSQL 9.5 is a powerful new feature which enables PostgreSQL to manage and index volumes of data that were impractical or impossible in the past. It allows scalability of data and performance beyond what was considered previously attainable with traditional relational databases and makes PostgreSQL a perfect solution for Big Data analytics," said Boyan Botev, Lead Database Administrator, Premier, Inc.

Links

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

Contact

PostgreSQL Press Team press@postgresql.org Phone: +1 (347) 674-7759

About PostgreSQL

PostgreSQL is the world's most advanced 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 at: http://www.postgresql.org.

Let’s make a bold call about this year’s CES right now. If you’re looking for the sexiest product here, swing by the Daimler-Benz booth. The German automaker is just one of the automotive companies using NVIDIA to build new products. More than 10 million cars on the road right now powered by NVIDIA technologies. And… Read More

The post CES 2016: Auto Partners Worldwide Showing Off NVIDIA Powered Products appeared first on The Official NVIDIA Blog.

By: Mike Langdon, Blue Medora If you are a XenDesktop or XenApp admin, an all too common complaint is: “My desktop is so slow.” If one user is complaining, chances are that many more are suffering. This is where vRealize Operations comes in. Using the Management Pack for XenDesktop and XenApp, we can zero in […]

The post Bringing XenDesktop and XenApp Users and Sessions to vRealize Operations appeared first on VMware Cloud Management.

From ground breaking announcements to packed events and industry awards, …

Read More

After upgrading an ESXi host to 5.5 Update 3b and later, the host is no longer manageable by vCenter Server Licensing ESXi 5.x and vCenter Server 5.x Licensing ESXi 6.x and vCenter Server 6.x Reverting to a previous version of ESXi Commands to monitor snapshot deletion in VMware ESXi/ESX Collecting diagnostic information for VMware ESX/ESXi […]

The post Top 20 ESXi articles for December 2015 appeared first on Support Insider.

Pour Allocab, le 1er réseau de chauffeur privés VTC et …

Read More

Even great teams grow stale if they never collaborate beyond their inner circle. The most creative contributors and fastest problem-solvers often have the largest social circles at work.

If you really want to work smarter and get ahead in 2016, it’s time for your tiny social bubble to pop and to start collaborating beyond your neck of the cubicles!

Read more on Want to Look Like a Genius at Work? Grow Your Social Circle…

After upgrading an ESXi host to 5.5 Update 3b and later, the host is no longer manageable by vCenter Server Purging old data from the database used by VMware vCenter Server Consolidating snapshots in vSphere 5.x/6.0 Unlocking and resetting the VMware vCenter Single Sign-On administrator password Upgrading to vCenter Server 6.0 best practices Permanent Device […]

The post Top 20 vCenter KBs for December 2015 appeared first on Support Insider.

Repairing or updating the trust between all components within a VMware vRealize Automation environment Update sequence for vSphere 6.0 and its compatible VMware products Removing a virtual machine from Management in VMware vRealize Automation or vCloud Automation Migrating to a new SSO or recovering from a reinstallation of SSO in VMware vRealize Automation Changing the […]

The post Top 20 vRealize Automation KBs for December 2015 appeared first on Support Insider.

Resetting the Administrator password in VMware vRealize Operations Manager appliance Update sequence for vSphere 6.0 and its compatible VMware products The VMware vRealize Operations Manager for Horizon (V4H/V4V) 6.2 Broker Agent fails to pair with the Horizon adapter Public Patch (Build 3294016) for VMware vRealize Operations Manager 6.1 vRealize Operations Manager 6.1 Sizing Guidelines Collecting […]

The post Top 20 vRealize Operations Manager KBs for December 2015 appeared first on Support Insider.

After reviewing the continued popularity of the VMware Certified Professional 5 - Data Center Virtualization Delta exam for candidates to recertify their VCP5-DCV we have decided to extend the availability date until March 31, 2016. The exam offers some key advantages: It’s based on new material between the vSphere 5.0/5.1 and vSphere 5.5 exams so […]

The post VCP5-DCV Delta Exam Availability Extended appeared first on VMware Education and Certification Blog.

If you missed the December call, please use this link to register (we know it has passed)…. Once registered, you will then get access to the on demand version where VMware representatives provided valuable insights on NSX, Virtual SAN, and Education Service.

The post Attn EMEA Partners… Did You Miss December’s Short & Snappy Call ? appeared first on Partner News.

Happy new year friends! Did you know about this little book I wrote called ‘Getting Started WithVMware Fusion’? No? Well good news! It’s on sale for $5! Before Imoveddown heretoSilicon Valley, Iwas a lead on the Fusion /Workstation Support team in Canada, and in 2014 I was asked by the good folks at Packt Publishingtowrite […]

The post Getting Started with VMware Fusion eBook: $5 appeared first on VMware Fusion Blog.

Some administrative practices, like a bad habit, have more lives than the proverbial cat - they tend to stay around forever. It is, therefore, very comforting when one finds a problematic administrative practice that has not just been universally abandoned by administrators, but is also on the top of any junior administrator’s “configurations sure to […]

The post Completely Disable Time Synchronization for your VM appeared first on Virtualize Business Critical Applications.

Four lidar detectors. Four fisheye cameras. Two narrow field-of-view cameras. GPS. We may be cruising down a sun-dappled Silicon Valley expressway within the posted miles per hour. But every second, untold quantities of data are being scooped up by our specially tricked out luxury sports sedan. Yet without the ability to bring the data from… Read More

The post Supercomputing at 60 MPH: How Deep Learning Will Give Cars Superhuman Capabilities appeared first on The Official NVIDIA Blog.

More than 10 million cars on the road today are powered by NVIDIA. Step into our booth in the North Hall of the Las Vegas Convention Center at the CES 2016 tradeshow and we’ll convince you that we’re just getting started. We’re not just focused on cars at this year’s CES. We’re focused on telling a… Read More

The post 3 Reasons Why Computers Will Drive Better Than You appeared first on The Official NVIDIA Blog.

While external perimeter protection requirements will most likely command hardware acceleration and support for the foreseeable future, the distributed nature of the services inside the data center calls for a totally different set of specifications. Some vendors have recently claimed they can achieve micro-segmentation at data center scale while maintaining a hardware architecture. As I […]

The post VMware NSX and Split and Smear Micro-Segmentation appeared first on The Network Virtualization Blog.

Happy New Year from the VMware vCloud Air Community! As 2016 gets underway, it’s the perfect time to assess your cloud computing strategy for the coming year. Where are you on the journey to the public cloud? And where do you want to be? In this week’s vTech Talk, we’re highlighting the vCloud Air Public […]

The post vCloud Air vTech Talk: Take the Quiz, Chart Your Course appeared first on VMware vCloud Air Blog.