Re: [GENERAL] Questions about indexes

Thank you for your explaination, David ! Renaud THONNART ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Time to insert

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. > &g

Re: [GENERAL] Time to insert

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:

Re: [GENERAL] Time to insert

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 > >

[GENERAL] Time to insert

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

[GENERAL] Multiple INSERT

u all, Sincerelly, Renaud THONNART ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])