David Kerr <dmk@xxxxxxxxxxxxxx> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
