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?
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?