Skip site navigation (1) Skip section navigation (2)

Re: Calling conventions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Matthew Wakeling" <matthew(at)flymine(dot)org>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Calling conventions
Date: 2009-07-20 23:34:38
Message-ID: 29443.1248132878@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"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: KradeDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group