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.