Re: [GENERAL] More psql problems... >.

2004-06-22 Thread Madison Kelly
Scott Marlowe wrote: 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

Re: [GENERAL] More psql problems... >.

2004-06-22 Thread Scott Marlowe
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 > performanc

Re: [GENERAL] More psql problems... >.

2004-06-22 Thread Martijn van Oosterhout
On Tue, Jun 22, 2004 at 03:52:03PM -0400, 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

Re: [GENERAL] More psql problems... >.

2004-06-22 Thread Madison Kelly
Alvaro Herrera wrote: On Tue, Jun 22, 2004 at 03:52:03PM -0400, Madison Kelly wrote: What is happening now is that the program does an 'ls' (system call) to get a list of the files and directories starting at the root of a mounted partition. These are read into an array which perl then process

Re: [GENERAL] More psql problems... >.

2004-06-22 Thread Alvaro Herrera
On Tue, Jun 22, 2004 at 03:52:03PM -0400, Madison Kelly wrote: > What is happening now is that the program does an 'ls' (system call) > to get a list of the files and directories starting at the root of a > mounted partition. These are read into an array which perl then > processes one at a t

[GENERAL] More psql problems... >.

2004-06-22 Thread Madison Kelly
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 ro