OpenSCG

/OpenSCG

Holy Easy PostgreSQL deployment

Holy Easy PostgreSQL deployment! In case you missed it, the BigSQL team released an awesome package manager for installing and configuring PostgreSQL and many related, useful components. The package manager can be found here: https://www.bigsql.org/package-manager.jsp. Playfully named pgc, for ‘pretty good command line’, pgc is a utility similar to yum or apt-get that allows you [...]

By | October 14th, 2016|BigSQL, Dave PostgreSQL, OpenSCG|0 Comments

Integrating Cassandra, Spark, PostgreSQL and Hadoop as a Hybrid Data Platform – Part 2

In the previous post, we provided a business and architectural background for the Postgres FDWs that we are developing for Spark, Hadoop and Cassandra. In particular, we highlighted the key benefits of bringing Cassandra and PostgreSQL together. With this post, we will start taking a more technical look at the Cassandra FDW. The C* FDW [...]

By | September 23rd, 2016|Affan PostgreSQL, OpenSCG, PostgreSQL Blogs|0 Comments

Improve PostgreSQL on Windows performance by 100%

It sounds like click-bait, or one of those late night TV promotions - "Improve your database performance by 100% - by changing just this one setting!" But in this case, it's true - you can drastically improve PostgreSQL on Windows performance by changing one configuration setting - and we made this the default in our [...]

By | September 20th, 2016|Dave PostgreSQL, OpenSCG|0 Comments

Building PostgreSQL on Windows for Performance

Before PostgreSQL 9.1, adding additional features like data types was non-standard and awkward, but 9.1 brought extensions. By adding extensions as well as the plumbing for things like foreign data wrappers, the use of extensions have exploded over the last few years. This is great for people who are using PostgreSQL on Linux or similar [...]

By | February 17th, 2016|BigSQL, Jim PostgreSQL, OpenSCG, Uncategorized|1 Comment

Video – Behold! The Power of Foreign Data Wrappers!

If you've never heard of PostgreSQL's “foreign data wrappers” -- you've been missing out on a very powerful tool to connect and integrate heterogenous databases. By leveraging FDW's, you can put PostgreSQL at the center of a integrated database federation and read and write data from other PostgreSQL servers, other relational databases (Oracle, MySQL), many NoSQL systems (MongoDB, Hadoop) [...]

By | December 10th, 2015|FDW (Foreign Data Wrapper), OpenSCG|0 Comments

PostgreSQL Studio 2.0 is out

PostgreSQL Studio is a fully open source web based UI for PostgreSQL that is ideal for Postgres in the cloud. With the impending release of PostgreSQL 9.5, PostgreSQL Studio 2.0 has just been released supporting some of the new features in Postgres. The big new feature that requires UI changes is support for Row Level [...]

By | December 1st, 2015|Jim PostgreSQL, OpenSCG, PostgreSQL|1 Comment

PostgreSQL PL/pgSQL Profiler

Some of our customers really like writing their business logic inside of PostgreSQL. While this is really cool that PostgreSQL is capable of handling, trying to performance tune large amounts of PL/pgSQL code becomes unwieldy. If your functions are small enough, it's possible add some logging statements, but that is not possible with hundreds or [...]

By | February 20th, 2015|Jim PostgreSQL, OpenSCG|Comments Off on PostgreSQL PL/pgSQL Profiler

Synchronous Commit

While I was at PGConf.EU a couple of weeks ago in Madrid, I attended a talk by Grant McAlister discussing Amazon RDS for PostgreSQL.  While it was interesting to see how Amazon had made it very simple for developers to get a production PostgreSQL instance quickly, the thing that really caught my eye was the [...]

By | November 10th, 2014|Jim PostgreSQL, OpenSCG, PostgreSQL|Comments Off on Synchronous Commit

Stinger Delivers Fast Hive SQL via YARN & TEZ

The latest BigSQL bundle now includes Stinger and Tez to dramatically improve performance and extend the SQL dialect. In the latest distribution of BigSQL Release 2, it is extremely easy to get started exploring Tez and Stinger in your own sandbox environment. Taking advantage of YARN, Stinger is now delivering on its three main goals [...]

By | March 12th, 2014|Big Data, BigSQL, OpenSCG|Comments Off on Stinger Delivers Fast Hive SQL via YARN & TEZ