Author Archives: skahler

Testing out UAC

I haven’t been a big fan of Greenplum’s performance monitoring tools. It’s been a couple years though so it’s time to try them again and see what we’ve got. So just got UAC up and running today and it’s looking … Continue reading

Posted in Uncategorized | Leave a comment

Finding trouble spots

I’ve been fighting some database performance issues recently and started to use the following query to look for tables that are being used that are showing that they have 0 rows. These are likely to be unanalyzed tables being used … Continue reading

Posted in Uncategorized | Leave a comment

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

Controller Setting for Greenplum

I brought another node into one of our clusters yesterday and it made me things of the controller setting I put on the system. In various systems we’ve used the PERC6/E, H700 and LSI-9260-8i controllers and I’ve found I on … Continue reading

Posted in Benchmarking | Leave a comment