Re: Strange behavior with large datas

Cyril,

On Fri, Aug 17, 2001 at 09:29:35PM +0200, Cyril VELTER wrote:
>     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,

Can you try the latest Cygwin snapshot and report back to the list?

You can find the snapshots at:

    http://www.cygwin.com/snapshots/

or one of the Cygwin mirrors:

    http://www.cygwin.com/mirrors.html

Thanks,
Jason