Re: Strange behavior with large datas

     Jason,

    Just tried it (13 august snapshot). The behavior is exactly the same
 than 1.3.2 : insertion of large fields is fast, but the large field select
 still fail (Hang).

     I've done some more tests and the problem seem libpq related (and not
 backend related). In fact, if I use the windows psql to connect to a linux
 server, I get the exact same problem. When I use linux psql with either
 linux or cygwin backend all is fine.


         cyril


> > 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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>