Re: [GENERAL] Time to insert

2001-05-03 Thread Renaud Thonnart
Ok, I will try to do a VACUUM ANALYZE in my program. I suppose it is better to do it too much than too less time Many thanks for your help Einar. Renaud Einar Karttunen wrote: > On Thu, 3 May 2001, Renaud Thonnart wrote: > > > Thank you Einar and Colin for your help. > > > > I have some li

Re: [GENERAL] Time to insert

2001-05-03 Thread Einar Karttunen
On Thu, 3 May 2001, Renaud Thonnart wrote: > Thank you Einar and Colin for your help. > > I have some little qusetions more : > > - How do I interpret a VACUUM ANALYSE ? > - I'm going to load version 7.1 : what is the difference between 7.1 and > 7.1rc4 ? > 7.1rc4 is the fourth release candidate.

Re: [GENERAL] Time to insert

2001-05-03 Thread Renaud Thonnart
Thank you Einar and Colin for your help. I have some little qusetions more : - How do I interpret a VACUUM ANALYSE ? - I'm going to load version 7.1 : what is the difference between 7.1 and 7.1rc4 ? Renaud THONNART Einar Karttunen wrote: > On Thu, 3 May 2001, Renaud Thonnart wrote: > > > It

Re: [GENERAL] Time to insert

2001-05-03 Thread Einar Karttunen
On Thu, 3 May 2001, Renaud Thonnart wrote: > It is a little difficult to perform VACUUM analyse because I'm writing an > application in C++ using libpq++. > I Use version 7.0.3 > I try COPY too but result was about the same. > int PgConnection::ExecCommandOk("VACUUM ANALYZE"); If you can upgradi

Re: [GENERAL] Time to insert

2001-05-03 Thread Renaud Thonnart
It is a little difficult to perform VACUUM analyse because I'm writing an application in C++ using libpq++. I Use version 7.0.3 I try COPY too but result was about the same. Renaud. Einar Karttunen wrote: > On Thu, 3 May 2001, Renaud Thonnart wrote: > > > Hi everyone > > Could someone explain

Re: [GENERAL] Time to insert

2001-05-03 Thread Einar Karttunen
On Thu, 3 May 2001, Renaud Thonnart wrote: > Hi everyone > Could someone explain me why time of insertion become that long when > table increase ? > For the same kind of insertion: > When table is empty : 0.03s/row > Table has 3663 rows : 2.07s/row > Is that normal ? > > Sincerely, Renaud THONNAR

[GENERAL] Time to insert

2001-05-03 Thread Renaud Thonnart
Hi everyone Could someone explain me why time of insertion become that long when table increase ? For the same kind of insertion: When table is empty : 0.03s/row Table has 3663 rows : 2.07s/row Is that normal ? Sincerely, Renaud THONNART ---(end of broadcast)