Re: [SQL] Slow Inserts Again - Mailing list pgsql-sql

From Frank Morton
Subject Re: [SQL] Slow Inserts Again
Date
Msg-id 07d001be95c1$119189d0$8355e5ce@base2inc.com
Whole thread Raw
List pgsql-sql
>Is it at all possible that the optimizer is responsible for this behaviour?
>The reason I ask is that the fact that when the inserts start the optimizer
is
>working with a very small table, as the table grows larger the optimizer
never
>learns it because no VACUUM or VACUUM ANALYZE have been run.
>
>If this is indeed the problem, then running VACUUM after every 10,000
inserts
>would solve the problem.

Can I run a vacuum while inserts are still going?





pgsql-sql by date:

Previous
From: "Rudy Gireyev"
Date:
Subject: Re: [SQL] Slow Inserts Again
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Slow Inserts Again