OpenSCG

/Tag:OpenSCG

Successful database Migrations : Are they really possible?

We talk to a lot of clients who want to perform database migrations but just about all of them are skeptical that the project will be a success. There are a number of reasons for this, including: Fear Lack of time to take on project Belief that their usage isn’t easy convertible to a new [...]

By | March 2nd, 2017|Categories: OpenSCG, OpenSource, PostgreSQL, thoughts, Uncategorized|Tags: , , , , |0 Comments

pg_repack in Postgres by BigSQL

Many DBAs agree that one of the most useful extension in their arsenal is pg_repack. Pg_repack addresses a serious shortcoming in Postgres: doing VACUUM FULL online. Due to the way Postgres handles the MVCC, tables and indexes become bloated. Dead tuples are addressed by AUTOVACUUM and space will be marked free. In many situations a [...]

By | January 9th, 2017|Categories: Jobin PostgreSQL|Tags: , , , |0 Comments

Why are you still paying for your GIS when you can get it for free?

If you haven’t switched to open source solutions (FREE!), then you have probably fallen for some common misconceptions/myths: MYTH: Open source tools are buggy. Does software have bugs? Of course. It was made by humans! But open source has the benefit of a strong community that can crowdsource fixes because the code base is not [...]

By | October 4th, 2016|Categories: Holly PostGIS|Tags: , , , , , |0 Comments

BigSQL

BigSQL. From data to information, from information to insight. A state-of-the-art Big Data Warehouse solution that is fast, secure and continuously available. BigSQL will scale from your desktop to the cloud. Run real time OLAP directly from the worlds most secure RDBMS. Get started with BigSQL right now. You can immediately put BigSQL to work [...]

PostgreSQL Clustering with Postgres HA

PostgreSQL Clustering made easy with PostgresHA. Authored jointly with Scott Mead, Sr. Architect OpenSCG and Architect of PostgresHA. PostgresHA is Highly Available (HA) PostgreSQL. High Availability High availability is not new. Financial trading systems and the telephone network were federally mandated to provide highly availability. People didn’t do HA because it was a fun project, [...]

By | April 17th, 2013|Categories: High Availability, OpenSCG, OpenSource, PostgreSQL|Tags: , , , , , , , , |Comments Off on PostgreSQL Clustering with Postgres HA