From: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
---|---|
To: | Renaud Thonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Time to insert |
Date: | 2001-05-03 11:16:20 |
Message-ID: | Pine.LNX.4.30.0105031407170.26292-100000@melkinpaasi.cs.Helsinki.FI |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Andy Howarth | 2001-05-03 11:35:24 | Problems compiling 7.1 with TCL support on Solaris 7 |
Previous Message | Renaud Thonnart | 2001-05-03 10:50:03 | Re: Time to insert |