Category Archives: Uncategorized

Data Science Summit 2012

I’m attending the 2012 Data Science Summit and I am happy to report it has been well worth my time. It isn’t a nuts and bolts confernce on what technologies to use or how to use them, what processes you … Continue reading

Posted in Uncategorized | Leave a comment

Dashboarding Greenplum

When Greenplum first landed in our shop they had wanted us to use gpperfmon. It quickly because obvious that it wasn’t stable at that time and that it created way to much overhead. So a couple years ago I came … Continue reading

Posted in Uncategorized | Leave a comment

FATAL website has all kinds of issues

Went to drop and update on the website and it is in all kinds of pain. Looks like there is some work to be done

Posted in Uncategorized | Leave a comment

Falling behind

The gpadmin site is sorely lacking in updates recently. That’s not to say I don’t have things to post about. Just haven’t had the time to make a reasonable post about them. Look for some updates soon.

Posted in Uncategorized | Leave a comment

Figuring out what’s running on nodes

I use this to figure out what’s going happening on the nodes and if I might have hanging queries on one of them gpssh -f hosts.seg => ps -ef | grep postgres | grep con | awk ‘{print $12}’ | … Continue reading

Posted in Uncategorized | Leave a comment

GP 4.0.5.4 out

GP 4.05.4 just rolled out and it looks like it addresses some bugs we’ve hit. We had upgraded from 4.0.5.1 to 4.0.5.3 and had to revert back because we started seeing segments popping offline. The README notes for the new … Continue reading

Posted in Uncategorized | Leave a comment

Greenplum HD Announced

Reading the news on the Greenplum HD announcement. I find it especially interesting because one of the main reasons I had an initial flurry of posts here and then trailed off was that I got heavily involved in our Hadoop … Continue reading

Posted in Uncategorized | Leave a comment

GP 4.0.5.0 is out

Greenplum 4.0.5.0 rolled out this last week and fixes many network communication and Append Only table issues that we’ve been running into. The caveat here is that GP has had some additional things crop up so I would recommend waiting … Continue reading

Posted in Uncategorized | Leave a comment

plugin action

Just uploaded a Greenplum plugin to the Nagios plugin exchange. It’s my first go at an official Nagios plugin. I’ve created checks for a simple login, reading from a table, writing to a temp table and checking for segment status … Continue reading

Posted in Uncategorized | 2 Comments

move data from db to db

We had two Greenplum instances running and we needed to copy one big table to the other. There’s a variety of ways to dump and import but we were moving a large amount of data, so the thought of dropping … Continue reading

Posted in Uncategorized | Leave a comment