Tuesday, June 16. 2009
As promised in the previous post this is the second part in a series of testing/benchmarking 8.4 under various circumstances.
Continue reading "Benchmarking 8.4 - Chapter 2/bulk loading"
Friday, June 12. 2009
Computing platforms are constantly changing, evolving and improving. This holds true for both the hardware and the software running on that hardware.
Continue reading "Benchmarking 8.4 - Chapter 1/Read-Only workloads"
Saturday, September 13. 2008
Long time no post - but I just got back home from the Netways Nagios Conference 2008 where I was invited to give a talk on "PostgreSQL Monitoring - Introduction, Internals And Monitoring Strategies for postgresql.org" so I figured it is time to say something again ...
Continue reading "Nagios conference 2008"
Monday, February 25. 2008
FOSDEM was a really nice and successful event for Opensource in general and especially PostgreSQL - we had a really impressive booth and a huge number of talks with a lot of attendances.
Continue reading "fosdem - a huge success"
Thursday, January 31. 2008
PostgreSQL is a thriving and fast evolving project with regular releases that add new features, improve existing functionality and increase speed.
Continue reading "feature matrix - or "what is new in version XY?""
Tuesday, December 11. 2007
With 8.3 just around the corner more and more people are actually starting to test 8.3 with their code base and wondering if it will be worth to switch/upgrade and so did I.
All the testing is done on a DL380 G5 with two Quadcore Intel Xeon CPUs (X5345 - so 2,33Ghz per core) 12GB of RAM and 6 disks in a RAID1+0 with 512MB BBWC on a Smartarray P400.
The benchmark database is initialized with a scaling factor of 100 (equals to 10M rows) which seems to be a reasonable size for a table in an OLTP style database) all testing was done with 100 clients and 100000 transactions/client which comes out to 10M transactions and an average runtime of about 1,5 hours.
what we can see here is that 8.3B4 is about 2.2x faster than 8.2 out-of-the-box for this very update heavy workload and is able to keep that advantage after similar tuning is applied to both instances.
the second thing I tried to test was the effect of various shared_buffer settings on the transaction rate(the other parts of the configuration stayed the same as in the "tuned" variant above):
there are two main things to note here - one is the obvious one that the scaling on the x-axis is not linear.
All in all 8.3 seems to become a rather impressive release and as always proper tuning is very critical to getting the best out of (dedicated) database server instances.
Saturday, November 3. 2007
Joshua Drake just announced that the first machine is finally available for a PostgreSQL Performance Test lab donated by a range of commercial sponsors.
Some of the reasons why it is not so well suited for that purpose are:
What I would like to see in the future is a threefold approach:
Monday, July 9. 2007
pgday.it in Prato was a truly marvelous conference, but everything is eventually coming to an end and so did this conference. On sunday Gabriele and Andrea took us one a tour through Florence ending in a great dinner and a bit of a challenge to catch the last train^bus back to prato ...
Today we started at around 09:30 in the morning trying to get Magnus to the airport which turned into quite a long trip mostly due to the fact that andreas navigation system developed something that can only be described as "artificial (un)intelligence".
After we left the airport we thought we were good for going back up to Salzburg (and Munch) but the navigation system acted up again and caused so much confusion that we actually managed to get up the highway WITHOUT(!) getting a ticket from the toll station.
After a somewhat interesting discussion which mainly consisted of well wild gestures and "i have no idea what you are talking about" faces we managed to get a form that probably claims (again all Italian) that we turned around on the highway or something like that - but well it seems we don't have to pay anything for "hacking" the italian highway system.
On the way back to the car from the autostrada office we met the guy manning the 18+ toll houses again telling us that there is a completely unlabeled underground crossing to the other side of the highway which would have been a good thing to to know earlier for well "making crossing a highway "easier".
Saturday, July 7. 2007
So well - the official part of pgday.it is over now and today we had a lot of interesting talks from a number of international people covering everything from encoding(Susanne) related stuff over to full text search(Oleg) and PITR(Simon).
Friday, July 6. 2007
so pgday.it is in full swing, and it's a truly impressive conference. Andreas and I arrived after a 7h drive from Salzburg in Prato.
Today is the first day of the actual conference and one can only barely imagine the amount of work the organizers have put into this ...
(Page 1 of 2, totaling 16 entries) » next page