Re: Question about speed: Weird Behavior

From: Israel Ben Guilherme Fonseca <israel(dot)bgf(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Question about speed: Weird Behavior
Date: 2011-06-13 17:12:24
Message-ID: BANLkTimNhvPo9VeL94o0sxnBCDcRpLKK5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Thanks for all the answers,

Smogura: "This is system autotuning - a good solution."

Where can I find more about this subject, and how can I weak it? Is it
hidden on postresql.conf? Can I configure it to always use an specifc size
like 8258 bytes per-package?

I'm doing tests on other drivers of other programming languages to
postgresql, and for those, there wasn't any package size differences, only
with the Java tests. Maybe the others drivers are setting specific values
for this.

2011/6/13 Maciek Sakrejda <msakrejda(at)truviso(dot)com>

> > There may be some GC
> > overhead, you should call System.gc after or before each pass to start
> with
> > similar environment.
>
> Note that the contract of System.gc() is really more like "Hey, I
> think it might be fun to run GC right now," than "You'll run GC right
> now and you'll like it." In other words, it's technically only a
> suggestion, so you should make sure it's actually doing something
> before you start depending on it for performance numbers.
>
> ---
> Maciek Sakrejda | System Architect | Truviso
>
> 1065 E. Hillsdale Blvd., Suite 215
> Foster City, CA 94404
> (650) 242-3500 Main
> www.truviso.com
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message crramirez 2011-06-13 17:15:16 Re: ERROR : column c.reltriggers does not exist
Previous Message Maciek Sakrejda 2011-06-13 16:13:42 Re: Question about speed: Weird Behavior