David Kerr <dmk(at)mr-paradox(dot)net> wrote:
> Incidentally the code is written to work like this :
>
> while (read X lines in file){
> Process those lines.
> write lines to DB.
> }
Unless you're selecting from multiple database tables in one query,
effective_cache_size shouldn't make any difference. There's
probably some other reason for the difference.
A couple wild shots in the dark:
Any chance the source files were cached the second time, but not the
first?
Do you have a large checkpoint_segments setting, and did the second
run without a new initdb?
-Kevin