Published by Baron Schwartz on Oct 13, 2017 10:16:40 AM

Monitor Your Citus Cluster With VividCortex

VividCortex now has support for monitoring Citus, a scale-out solution for massively sharded data storage and processing using standard open-source PostgreSQL. Citus (previously known as CitusDB) layers an additional set of capabilities on top of PostgreSQL. The result is a powerful distributed database that shards your data and lets you ingest a firehose of data, while running complex real-time analytics queries in parallel across nodes for blazing fast performance.

Read More
Published by Alex Slotnick on Jul 25, 2017 1:32:08 PM

Brainwaves Podcast Ep 5: An Interview with Bruce Momjian

In this episode of Brainwaves, Alex chats with Bruce Momjian, a member of PostgreSQL's core development team, at the PGConf Local meetup in Philadelphia, July 2017. They discuss Bruce's background with PostgreSQL, some of the history of PostgreSQL’s development, how community support helps drive the database's evolution, and the importance of PostgreSQL's hybrid userbase.

Read More
Published by Alex Slotnick on Jul 18, 2017 4:07:38 PM

PGConf Local in Philly: PostgreSQL Performance, in Theory and Practice

A few members of the VividCortex team had the chance to attend PGConf's local meetup in Philadelphia last week. The group came together to discuss anything and everything Postgres, including new features to be included in PostgreSQL 10, building a scalable time-series database on top of PostgreSQL, and common mistakes people make when migrating from Oracle to PostgreSQL.

Read More
Published by Kelsey Uebelhor on Mar 16, 2017 5:57:56 PM

See You on the Road at 2017's Shows and Events!

Calling all developers, DBAs, engineers, SREs, and database aficionados: we’re hitting the road and hope to see you along the way. It's always a highlight of our year when we get to meet up with our users and friends face-to-face, and we'll be attending events across the country (and abroad!) for the rest of 2017. If you see our booth, come say hello. 

Read More
Published by Baron Schwartz on Feb 10, 2017 4:42:00 PM

JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server

If you've been watching the evolution of database technologies over the past few years, you've seen how quickly JSON has quickly cemented its position in major database servers. Due to its use in the web front-end, JSON has overtaken XML in APIs, and it’s spread through all the layers in the stack one step at a time.

Read More
Published by Alex Slotnick on Oct 27, 2016 6:26:42 PM

Webinar Recap: What's New in PostgreSQL 9.6 and MySQL 8.0?

Earlier this week, Baron Schwartz, VividCortex's CEO and author of High Performance MySQL, led a thorough webinar about the new and upcoming updates for a couple major databases: MySQL 8.0 and PostgreSQL 9.6. Attendees of the webinar had the opportunity to learn and ask questions about the most exciting, most impactful, and most overdue changes on offer in these latest iterations.

Read More
Published by Alex Slotnick on Sep 29, 2016 6:48:13 PM

Upcoming Database Updates: A Very Brief Pronunciation Guide

As many readers already know, it's update season for a couple key database systems. This morning the PostgreSQL Global Development Group released PostgreSQL 9.6 and published an announcement covering need-to-know details. Similarly, MySQL 8.0 is right around the corner, and as the full numeric uptick to 8.0 indicates, it's bound to contain some significant changes. This is major news for many users of these platforms. In recognition of these shifts in the database landscape, we'll be hosting a webinar on October 25, where Baron Schwartz will look at the changes these updates contain, discussing features such as replication capabilities; more extensibility; improved performance; broader SQL implementation; and more. 

In the meantime, we wanted to take a moment to help prep users in a different way: this blog post is a quick, pocket pronunciation and etymology guide that we hope will assist readers in uttering the vowel-phobic names of these systems with confidence.

Read More
Published by Baron Schwartz on Sep 16, 2016 1:19:26 PM

Surprising Behaviors of PostgreSQL Statistics Views

PostgreSQL provides a variety of statistics views that you can use to see what’s happening in the database. However, as with any complex system operating under a demanding workload, using these views may cause unwanted performance side effects, if you’re not careful. At the same time, the views have special behaviors that might surprise you if you’re not aware of them. If you’re planning to examine the PostgreSQL statistics views for any purpose, here’s what you should watch for.

Read More
Published by Alex Slotnick on Mar 2, 2016 2:06:45 PM

Sometimes a Variety of Databases is THE Database You Need

We were just leafing through the 2015 edition of The DZone Guide to Database and Persistence Management, and we noticed some interesting stats in the guide's included survey, about which we'd like to share some observations. The survey is one of the ebook's central features, and it includes feedback from over 800 IT Professionals, with 63% of those respondents coming from companies with over 100 employees and 69% with over 10 years of experience -- they represent a significant and important cross-section of our industry.

Read More

Recent Posts

Subscribe to Email Updates

Posts by Topic

see all