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