Re: Calling conventions - Mailing list pgsql-performance

From Tom Lane
Subject Re: Calling conventions
Date
Msg-id 29443.1248132878@sss.pgh.pa.us
Whole thread Raw
In response to Re: Calling conventions  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
"Kevin Grittner" <Kevin.Grittner@wicourts.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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Full text search with ORDER BY performance issue
Next
From: Krade
Date:
Subject: Re: Full text search with ORDER BY performance issue