Re: Runtime dependency from size of a bytea field

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Sander, Ingo (NSN - DE/Munich)" <ingo(dot)sander(at)nsn(dot)com>
Cc: ext Merlin Moncure <mmoncure(at)gmail(dot)com>, ext Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Runtime dependency from size of a bytea field
Date: 2010-10-12 12:36:24
Message-ID: AANLkTimSDmGHjnLVh5Zh7mixwg4e5uf6qgQrcboJ9cr9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Oct 8, 2010 at 12:53 AM, Sander, Ingo (NSN - DE/Munich)
<ingo(dot)sander(at)nsn(dot)com> wrote:
> The difference to my test is that we use the ODBC interface in our C program. Could it be that the difference in the runtimes is caused by the ODBC?

I've heard tell that ODBC is substantially slower than a native libpq
connection, but I don't know that for a fact, not being an ODBC user.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jon Nelson 2010-10-12 13:07:46 Re: Slow count(*) again...
Previous Message Robert Haas 2010-10-12 12:34:23 Re: How does PG know if data is in memory?