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