Strange behavior with large datas
От | Cyril VELTER |
---|---|
Тема | Strange behavior with large datas |
Дата | |
Msg-id | 023601c12752$f6729330$6901a8c0@Serveur обсуждение исходный текст |
Ответы |
Re: Strange behavior with large datas
|
Список | 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
В списке pgsql-cygwin по дате отправления: