PostGIS – How to create a Spatial Database with PGC Command Line

We are excited to announce that BigSQL distributions of PostGIS now come bundled with several popular community spatial extensions: postgis fuzzystrmatch postgis_tiger_geocoder postgis_topology ogr_fdw address_standardizer address_standardizer_data_us This is the only community distribution to offer PostGIS with these extensions across ALL platforms (Mac, Linux, and Windows)! So, for all you GeoGeeks using Linux / Mac - [...]

By | February 10th, 2017|Categories: Holly PostGIS|1 Comment

Are you a Yoda or a Diego?

In the geospatial world there are usually 2 types of people supporting spatially enabled databases: 1. GIS analysts  (scientist, statisticians, analysts, etc) who find themselves as the de facto DBA (among other things). “I don’t have time for this! I’m saving this sea turtle. Just give me a GUI!” 2. DBAs who find themselves supporting these strange [...]

By | February 8th, 2017|Categories: Holly PostGIS|0 Comments

Don’t move your Oracle database to the cloud

Why move your Oracle database to the cloud? It just doesn't make sense. You are moving to the cloud for flexibility, for cost savings, for ease of changing your infrastructure. Does doubling your Oracle license fee for AWS or Azure usage sound like Oracle wants to let you have flexibility or cost savings?? (Hint: NO!!) [...]

By | February 7th, 2017|Categories: OpenSource|Tags: , , , , |0 Comments

Using pg_bulkload to load data to PostgreSQL

PostgreSQL by BigSQL is committed to making Postgres user and developer friendly. As part of this effort, we continue to extend the list of extensions we ship and support. Recently, we started supporting pg_bulkload, a high speed data loading utility for PostgreSQL. In this blog post, we will illustrate how to quickly install and use [...]

By | February 1st, 2017|Categories: Jobin PostgreSQL|Tags: , , |0 Comments

How to: Pick a PostgreSQL Python driver

Using Postgres with python is easy and provides first class database capabilities for applications and data processing. When starting a new project, you need to choose which PostgreSQL python driver to use. The best choice depends on your deployment, python version, and background. Here's a quick guide to choosing between three popular python PostgreSQL drivers: [...]

By | January 10th, 2017|Categories: Dave PostgreSQL|Tags: , |8 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: BigSQL, Jobin PostgreSQL, OpenSCG, PostgreSQL|0 Comments

PostgreSQL Schema Visualization

I spend a lot of time trying to learn what's already been implemented, as DBA's, we tend to live in that world. It's important that you have tools that allow you to quickly get the visual so you can get on with your job. One of the biggest 'reverse engineering' tasks that DBA's have to [...]

By | December 22nd, 2016|Categories: Scott PostgreSQL|1 Comment

Is my query stuck? PostgreSQL 9.6

One of the most common queries that I keep in my pocket is SELECT pid, datname, usename, now() - query_start AS runtime, waiting, state, query FROM pg_stat_activity WHERE waiting='true'; This gives you a quick look at any queries that are ‘waiting’.  Specifically, you will see queries that are explicitly blocked on some other database activity. [...]

By | November 17th, 2016|Categories: Scott PostgreSQL|0 Comments

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

In a previous blog post we talked about the technical details behind the new CassandraFDW that enables PostgreSQL to connect to a Cassandra cluster. This provides PostgreSQL users the ability to easily read and write data to a very popular open source multi-master database that can support writes in multiple data centers. This means if [...]