Contact
Offices

Blog

news rss

Irenie White
Earlier this year, blogger and PostgreSQL Committer Andrew Dunstan drew up a list of individual Committers to the PostgreSQL Project. We are proud to say that this list featured some of our employees. In May, PostgreSQL's Andrew Dunstan published some data about the productivity of PostgreSQL...
Joseph Conway
I've been asked on at least three separate occasions lately how to know if changing a particular postgresql.conf item requires a restart, or a reload, of PostgreSQL. Here is my quick and dirty favorite way to answer this question: -- configs requiring postgresql restart select name, setting,...
Lukas Gärtner
CIOZone, a social network for CIOs, recently interviewed our Founder and CEO Dr. Michael Meskes. CIOZone is a central place where CIOs can network. In this video, Roger Green takes the time to drop in to our office in Moenchengladbach, Germany to interview Michael Meskes, the founder of credativ...
Joseph Conway
When you pass large amounts of data to and from PL/R, quite a lot of time is needed for converting. A change is being tested which treats arrays of 4 byte integers and 8 byte floating point values as a special case, resulting in a dramatic performance improvement. In a recent post, I discussed PL/R...
Irenie White
The vast majority of Debian installations are simplified with the use of Preseeding and Netboot. Friedrich Weber, a school student on a work experience placement with us at our German office has observed the process and captured it in a Howto here: Imagine the following situation: you find yourself...
Irenie White
nVidia has made it known that the free nv Driver is no longer going to be supported. Starting with the newly publicised Fermi Graphics Cards, future cards from nVidia will no longer work with nv Drivers. Originally, nv Drivers from nVidia were developed to provide basic 2D performance. 3D support...
Joseph Conway
When you pass large amounts of data to and from PL/R, quite a lot of time is needed for converting. It's better to directly store the data as R objects. I had been planning to continue with timeseries aggregation, but decided to take a side-road based on a recent question on the PL/R mailing list...
Joseph Conway
Frequently when dealing with parametric data, you need to "roll up" the data in summary fashion as it ages in order to reduce the volume kept on hand, or maybe because the summary statistics are what really interests you. There are several ways to do that, and this post highlights four different...
Joseph Conway
Someone posted a dilemma to the pgsql-sql list today that involved many if not all of his sequences getting out of sync with their respective "serial" columns. In other words, something like "SELECT max(id) FROM sometable" yields 42, but the sequence nextval for sometable.id is currently set to 36...
Joseph Conway
I was given a Postgres database dump to analyze today created by "pg_dump -Fc". The source database included PostGIS 1.3.x extensions. I'm not sure if this is standard with PostGIS, but the related database objects were all dumped with a hard-coded library path, specifically /usr/lib/postgresql/8.3...