Howard Goldberg commented on the post, Going Beyond Structured Data with Pivotal Greenplum 4 days, 22 hours ago
Looks interesting, Ivan. It looks like you have to perform an extra step to install it.
Before you can use hstore data type and functions, run the installation script $GPHOME/share/postgresql/contrib/hstore.sql in each database where you want the ability to query other databases:
$ psql -d testdb -f $GPHOME/share/postgresql/contrib/hstore.sql
A common question that is frequently asked when performing maintenance on Greenplum tables is “Why does my ALTER TABLE add column DDL statement take so long to run?” Although it appears to be a simple command and […]
Vacuuming your home is a laborious task that you would rather not do. However, vacuuming your home is an essential chore that must be done. The same is true for vacuuming the catalog in a Pivotal Greenplum […]