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

Re: Strange behavior with large datas

From: "Cyril VELTER" <cyril(dot)velter(at)metadys(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Strange behavior with large datas
Date: 2001-08-18 16:51:53
Message-ID: 00fc01c12806$1889bf80$6901a8c0@Serveur (view raw or flat)
Thread:
Lists: pgsql-cygwin
     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
>


Responses

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2001-08-18 21:14:25
Subject: Re: Strange behavior with large datas
Previous:From: Jason TishlerDate: 2001-08-18 14:25:48
Subject: Re: Strange behavior with large datas

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