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

Re: ByteA column retrieved in 31 minutes ...

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: andrea(dot)ricci(at)dedalus(dot)eu
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ByteA column retrieved in 31 minutes ...
Date: 2012-07-17 21:11:51
Message-ID: 5005D517.3020809@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Andrea,

(2012/07/17 23:46), Andrea Ricci wrote:
> Hi,
> I'm using a 9.0.2 db in a PowerBuilder 12.1 application, connecting to
> it via ODBC driver 09.00.0200.
>
> I have a table with a bytea column:
>
> CREATE TABLE docs
> (
>    blobid character(7) NOT NULL,
>    descript character varying(40),
>    data date,
>    "lock" character(1),
>    ora character(5),
>    parita character(1),
>    tipo character(3),
>    dbvtesto bytea,
>    CONSTRAINT docs_pkey PRIMARY KEY (blobid),
>    CONSTRAINT fk1_docs FOREIGN KEY (blobid)
>        REFERENCES blob (blobid) MATCH SIMPLE
>        ON UPDATE NO ACTION ON DELETE CASCADE
> )
> WITH (
>    OIDS=FALSE
> );
>
>
> When I retrieve via embedded SQL the dbvtesto column (using PK obv.) I
> get it in few seconds if its length is about 10 KB, but I've to wait 31
> minutes (!) if it's about 1 MB.
>
> If someone has a proposal ...

Mylog is a performance killer for this kind of query.
How about disabling Mylog?

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Andrea RicciDate: 2012-07-18 12:44:01
Subject: Re: ByteA column retrieved in 31 minutes ...
Previous:From: Andrea RicciDate: 2012-07-17 14:46:30
Subject: ByteA column retrieved in 31 minutes ...

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