Re: More psql problems... >.<
От | Scott Marlowe |
---|---|
Тема | Re: More psql problems... >.< |
Дата | |
Msg-id | 1087947016.1187.969.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | More psql problems... >.< (Madison Kelly <linux@alteeve.com>) |
Ответы |
Re: More psql problems... >.<
|
Список | pgsql-general |
On Tue, 2004-06-22 at 13:52, Madison Kelly wrote: > Hi all, > > I have got to say that my first foray into postgresSQL is becoming a > very madening experience... I am sure it is my own fault for not knowing > very much but it seems that everything I have tried so far to improve > performance has in fact made it a lot worse. Now my program dies after > roughly 300 seconds of processing directories and updates take literally > 10 time longer than inserts (which are themselves very slow). /SNIP > My previous question was performance based, now I just need to get > the darn thing working again. Like I said, after ~300 seconds perl dies. > If I disable auto-commit then it dies the first time it runs an insert. > (this is all done on the same table; 'file_dir'). If I add a 'commit' > before each select than a bunch of selects will work (a few dozen) and > then it dies anyway. Is it exactly 300 seconds? Sounds like a timeout somewhere to me. Does perl have one of those? Or maybe your OS / Shell combo do, or something like it? Just guessing here.
В списке pgsql-general по дате отправления: