From: | "Cyril VELTER" <cyril(dot)velter(at)metadys(dot)com> |
---|---|
To: | <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Strange behavior with large datas |
Date: | 2001-08-17 19:29:35 |
Message-ID: | 023601c12752$f6729330$6901a8c0@Serveur |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
I'm trying to bring up a production system using postgresql and cygwin.
I'm using the latest cygwin packages (as well as cygipc 1.09-2)
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,
thanks
cyril
test script :
create table test (tf test);
insert into test (tf) values ('aaaaaaaaaa');
update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff
update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff
update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff
update test set tf=tf||tf||tf||tf||ff||tf||tf||tf||tf||ff
select tf from test -> Hang
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Tishler | 2001-08-18 14:25:48 | Re: Strange behavior with large datas |
Previous Message | Guðmundur Erlingsson | 2001-08-17 11:21:37 | RE: Special characters in psql |