programming, databases and other IT something
This transaction has been open since July 2, 2001. We call it "Edward."
Some time ago I was asked about long running transactions. Is that really so bad and how long should a transaction run? I will try to reply that question now, as it returns all the time. The answer is not so trivial, as usually when you ask about databases.
Posted in database.
– February 28, 2011
Last time I was checking speed of Java primitives. It turned out that Integer is much slower than int. This time I want to check how much slower is String concatenation compared to StringBuffer andStringBuilder.
Continued…
Posted in programming.
– January 25, 2011
Well, UUID stands for something UNIQUE. How that happend that it simply doesn’t work?
I had to use a program that generates some random data in the database. The primary key is UUID, so the program generates a lot of UUIDs. It uses standard Java’s way of generating UUIDs, the function: UUID.randomUUID().
That program failed twice, it was a database error, that the UUID exists in the database. I’ve created only a litttle bit over 50k of database rows. There were two collisions. What a crap.
I told that the author of the software, he said that he had the same situation last week.
Another argument for not using UUIDs as Primary Keys.
Posted in database.
– January 19, 2011
I was told many times that Java primitives are better and faster than objects, but I haven’t found any benchmarks for that. So I made my own. I was trying to check how much slower it is to use objects like Integer, Long or Double instead of int, long or double. Continued…
Posted in programming.
– January 11, 2011
There is another great book on PostgreSQL: PostgreSQL 9.0 High Performance written by Gregory Smith and published by Packt Publishing.
From the very beginning I was thinking that it would be a really great position, and I wasn’t wrong.
Posted in database.
– December 22, 2010
I’ve already started writing a review of the second new book about PostgreSQL from Packt Publishing PostgreSQL 9.0 High Performance.
There also is a sample chapter available Database Hardware
I haven’t finished reading this book yet, but for what I could read, this is a really great amount of practical knowledge there.
The review will be published here as soon as I finish reading, I hope it will be tomorrow.
Posted in database.
– December 22, 2010
I wanted to add a review of the PostgreSQL 9.0 Cookbook on amazon.com. I’ve made an account for that, I logged in, I searched for the book. Cool. I clicked to add my review and…
I’ve never bought anything on amazon, nor I want to do that now. Quite strange that I cannot just add a review without paying for that.
– December 13, 2010
I’ve already finished reading PostgreSQL 9 Admin Cookbook, authored by Simon Riggs, Hannu Krosing, and published by Packt Publishing .
This is my first book review, I thought it should be quite easy to write one. So far I’ve written many different academic papers, many blog articles, almost one full chapter of my new book, but there wasn’t any review never before. I like reading, I also like reading technical books, but usually I read fast and only to get the information that I need. This time it was a little bit harder, I had to read every page in the book, but not only for getting the information, but also for gathering some critical remarks about that. Continued…
Posted in database.
– November 22, 2010
Today I was asked by Likesh Bhambhwani from Packt Publishing to write a review of the PostgreSQL 9 Administration Cookbook.
The review will be published here as soon as I finish reading.
Posted in database.
– October 28, 2010
