I have a file which is a long series of SQL commands. Creating
tables, copying in data, indexing, munging the data, intermittently
vacuuming to keep things moving.
I have usually run this big script like this:
nohup psql dbname < script.sql &
After upgrading to 8.0, the script to slow to a crawl after a while.
However, it works fine when run from inside a psql session like this
\i script.sql
All I can think of is that the entire script is running in one big
transaction, although there are no explicit BEGIN statements in it.
The man page for psql says, regarding the -c option
"If the command string contains multiple SQL commands, they are
processed in a single transaction, unless there are explicit
BEGIN/COMMIT commands included in the string to divide it into
multiple transactions. This is different from the behavior when the
same string is fed to psql's standard input."
implying that stdin is run exactly the same as \i.
That being the case, what could be causing my script to slow to a
crawl when redirected to psql, but run fine from inside psql with -i?
- Ian
