"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance