From: | Renaud Thonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr> |
---|---|
To: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Time to insert |
Date: | 2001-05-03 12:39:20 |
Message-ID: | 3AF15178.DF5F10C0@amwdb.u-strasbg.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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 upgrading to 7.1 it will probably help with the performance
> problem. The copy is good only if you perform very many inserts the
> same time. I use a cron job that performs the vacuuming so I don't
> have to worry about it in client aps. If you have multiple inserts,
> but not so many that you should use a copy, try wrapping them in a
> single transaction.
>
> - Einar Karttunen
From | Date | Subject | |
---|---|---|---|
Next Message | Tod McQuillin | 2001-05-03 12:49:14 | Re: psql with PHP question |
Previous Message | Michelle Murrain | 2001-05-03 12:39:18 | Re: Perl Scope problem |