On Wed, 7 Apr 2004, [iso-8859-15] Hervé Piedvache wrote:
> Hi,
>
> I have a database with one table with about 22 millions records.
> I have a script every day wich insert about 200 000 records ...
> Sometime my script takes 4 hours to insert the data, sometime 1 hour.
Are you wrapping all your inserts into one or several large transactions?
This can make inserting data MUCH faster in postgresql.
Do you have fk/pk relationships? If so, are they of the same types?
I wouldn't worry about the vacuum / analyze numbers being a little off. A
small variance of a few percent is no biggie, it's when things are off by
factors that the planner gets confused and makes bad decisions.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
