I doubt many people can tell you exactly when the first time they read a map was. Mine was memorable though. Circa 3rd grade, I went through the usual battery of standardized tests for the first time, which included map reading. I did pretty bad, which was odd because it was the only section I […]
Association rules with MADlib in Greenplum
/0 Comments/in Data Mining, Greenplum /by Carlo Ascani[*MADlib*](http://madlib.net) is an open-source library for scalable in-database analytics which targets the PostgreSQL and the Greenplum databases. MADlib version 0.2beta needs to be installed properly to follow this article, so we encourage you to read the [official documentation](http://github.com/madlib/madlib/wiki/Installation-Guide-%28v0.2beta%29) to install it in a Greenplum database. I’m going to show you how to perform Association Rules […]
Soon! 4-Days Admin Training in German
/0 Comments/in International News /by susanne.ebrechtBecause of PostgreSQL Conference Europe I had to reschedule the German trainings. The next upcoming training will be the 4-Days Administration, Performance, Streaming Replication Training. There are still a few seats left. Schedule: 2011 October 7 – 10 Location: Bielefeld Come to the nice East-Westphalia town and join our training.Register now! Detailed informations in German […]
How to test Greenplum Community Edition on VirtualBox
/2 Comments/in Greenplum /by Gabriele BartoliniGreenplum Community Edition is available in different flavours, including a VMWare virtual machine based on CentOS with all the fancy tools and the documentation already installed. This allows you to easily try and evaluate this powerful platform for data warehousing. [Greg Smith from our 2ndQuadrant team, recently explained how to install this image on Linux](http://www.greenplum.com/community/forums/showthread.php?486-Getting-Started-with-VMWare-on-Linux). […]
Planetary alignment
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressPicking back up this week’s theme of where you can publicize your PostgreSQL related project at, you’re probably reading this blog entry because it appeared on the Planet PostgreSQL blog aggregator. There are “Planet” feeds around many open-source projects. The Debian and GNOME ones spawned off the Planet software, which now powers a ton of […]
The cost of free PostgreSQL publicity
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant PressThe software license PostgreSQL is released under makes it extremely friendly to businesses who would like to use the database in commercial products. Partly as a result of this, a significant amount of PostgreSQL development is donated by companies who sell products derived from the database (even entire forks of the source code). Normally this […]
Performing parallel ETL with Greenplum’s gpfdist and external tables
/0 Comments/in Greenplum /by Gabriele BartoliniOne of the coolest features that Greenplum offers to Data warehousing and Business Intelligence operators as far as ETL is concerned, is the combination of read only external tables with gpfdist, Greenplum’s parallel file distribution server. The typical use case for this solution is parallel data loading of text files (coming from etherogeneous sources – […]
EuroPython 2011: “The Python and the Elephant”
/0 Comments/in International News, United Kingdom News /by Gabriele BartoliniDuring EuroPython 2011, the major annual event for Python developers and users in Europe, 2ndQuadrant will deliver a special hands-on training session entitled “The Python and the Elephant”. This 4-hour workshop will take place on Thursday June 23 and will cover the two main techniques for writing applications in Python for PostgreSQL: standard client applications […]
PostGIS In Action
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressI doubt many people can tell you exactly when the first time they read a map was. Mine was memorable though. Circa 3rd grade, I went through the usual battery of standardized tests for the first time, which included map reading. I did pretty bad, which was odd because it was the only section I […]
PostgreSQL agent in SQL Standard committee again
/0 Comments/in International News, PostgreSQL, Susanne's PlanetPostgreSQL /by susanne.ebrechtBy always having Peter E. in background I am active in SQL Standard (ISO/IEC 9075) committee since 2008. The membership expired after I switched companies. I got the pleasant news today morning that the German office of my new company extended the membership. This means – I will be PostgreSQL agent in SQL Standard committee […]
Intel SSD, now off the sh..err, shamed list
/2 Comments/in Greg's PlanetPostgreSQL, PostgreSQL, United States News /by 2ndQuadrant PressI already did the long conference entry here, so just a quick update: slides from PGEast are posted and next week I’ll be at the increasingly misnamed MySQL Conference in Santa Clara, California. One thing I’m known for now is ranting about cheap Solid State Drives and how they suck for database use. The Reliable […]