Re: [HACKERS] Speeding up operations

2003-08-14 Thread Hannu Krosing
Rahul_Iyer kirjutas K, 13.08.2003 kell 08:23: > hi... > im on a project using Postgres. The project involves, at times, upto > 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts > into a 2 column table (one col=integer, 2nd col=character). I used the > Prepare... and execu

Re: [HACKERS] Speeding up operations

2003-08-14 Thread Frank Wiles
On Wed, 13 Aug 2003 10:53:39 +0530 "Rahul_Iyer" <[EMAIL PROTECTED]> wrote: > hi... > im on a project using Postgres. The project involves, at times, upto > 5,000,000 inserts. I was checking the performance of Postgres for 5M > inserts into a 2 column table (one col=integer, 2nd col=character). I >

Re: [HACKERS] Speeding up operations

2003-08-14 Thread Rod Taylor
> im on a project using Postgres. The project involves, at times, upto > 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts > into a 2 column table (one col=integer, 2nd col=character). I used the > Prepare... and execute method, so i basically had 5M execute statements an

[HACKERS] Speeding up operations

2003-08-14 Thread Rahul_Iyer
hi... im on a project using Postgres. The project involves, at times, upto 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts into a 2 column table (one col=integer, 2nd col=character). I used the Prepare... and execute method, so i basically had 5M execute statements and

Re: [HACKERS] Speeding up operations

2003-08-14 Thread Tom Lane
"Rahul_Iyer" <[EMAIL PROTECTED]> writes: > im on a project using Postgres. The project involves, at times, upto > 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts > into a 2 column table (one col=integer, 2nd col=character). I used the > Prepare... and execute method, so