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