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

Strange behavior with large datas

From: "Cyril VELTER" <cyril(dot)velter(at)metadys(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Strange behavior with large datas
Date: 2001-08-17 19:29:35
Message-ID: 023601c12752$f6729330$6901a8c0@Serveur (view raw or flat)
Thread:
Lists: pgsql-cygwin
    I'm trying to bring up a production system using postgresql and cygwin.

    I'm using the latest cygwin packages (as well as cygipc 1.09-2)

    Installation was done without any problem. Evrything works smoothly
except queries on tables containing large toasted values. a select on such a
table will Hang (client locked, use the attached test script to reproduce).
I have tried with an earlier version of postgres (7.1) as well as current
CVS : same problem.
    I found that downgrading cygwin package to cygwin 1.3.1-1 does remove
this problem.

    But with cygwin 1.3.1, there another strange behavior : in one
transaction, I create 20 record with quite large toasted values in them
(~30Ko each in 2 fields). Transaction commit take a very long time (5-10 s).


    Any Idea will be welcome,

    thanks


            cyril


test script :

    create table test (tf test);

    insert into test (tf) values ('aaaaaaaaaa');
    update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff
    update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff
    update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff
    update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff

    select tf from test -> Hang



Responses

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2001-08-18 14:25:48
Subject: Re: Strange behavior with large datas
Previous:From: GuĂ°mundur ErlingssonDate: 2001-08-17 11:21:37
Subject: RE: Special characters in psql

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