PDA

View Full Version : Improving import performance



melles
12-03-2008, 02:18 PM
Will this improve import speed when importing alot of hands.

First
Installing Postgres on a own HD so its not installed on C:

Second
How does the import works, does Postgres first write the log files then import it into the DB is that why there are a bunch of log files in \PostgreSQL\8.2\data\pg_log can I tell Postgres where to write the log files on what HD?

So would it improve import performance if I would tell Postgres to write the log files to a own HD? install postgres to lets say d: and tell it to write log files to e:

If not how can I improve import performance with hardware and software installation and config setting?