Re: Insert speed question

On Tuesday 01 June 2004 01:35, Josué Maldonado wrote:
> Hello List,
>
> I'm importing some data from Foxpro to Postgres, there is atable wich
> contains aprox 4.8 million rows and it size about 830MB. I uploaded it
> to Postgres using dbf2pg and worked fine, it tooks about 10-15 minutes.
> Now I'm inserting some data from that table to a brand new table in
> Postgresql, for that I'm doing insert into ... select from. The point is
> inserting this data from one table to another table in Postgresql took
> about 35 minutes ago. Is that the expected behavior in Postgres?

Can you generate explain analyze for insert into.. select from? Most probably
it is using seq. scan because you haven't analysed after inserting 4.8M rows.

Do a vacuum verbose analyze tablename and reattempt inter into.. select from.

You can also read general tuning guide at

http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php

HTH

Shridhar