Re: Performance problem with timestamps in result sets

From: "Thomas Dudziak" <tomdzk(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Performance problem with timestamps in result sets
Date: 2006-03-08 15:12:32
Message-ID: 224f32340603080712l51bcef4i84d5b32c7b9f12df@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 3/8/06, mikael-aronsson <mikael-aronsson(at)telia(dot)com> wrote:

> I do not think there is much more to do, the timestamp is just a 64 bit
> integer and you say an int takes 570ms/10920 calls and a timestamp takes
> 7130ms/8190 calls, this is about twice as much to get twice as much data.

No, thats about 16x slower (and most of the time is spent in the JDBC
driver, not on the wire).

Tom

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Goodenough 2006-03-08 15:54:33 Problem with background thread in Tomcat 5.5.9
Previous Message Oliver Jowett 2006-03-08 15:11:26 Re: Performance problem with timestamps in result sets