"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Oh, well, if you load all the data into Java's heap and are accessing
> it through HashMap or similar, I guess a factor of 100 is about right.
> I see the big difference as the fact that the Java implementation is
> dealing with everything already set up in RAM, versus needing to deal
> with a "disk image" format, even if it is cached.
Eliminating interprocess communication overhead might have something
to do with it, too ...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Krade||Date: 2009-07-21 00:25:02|
|Subject: Re: Full text search with ORDER BY performance issue|
|Previous:||From: Raji Sridar (raji)||Date: 2009-07-20 22:33:04|
|Subject: Help needed for reading postgres log : RE: Concurrency issue under very heay loads|