| From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | how to increase upsize speed |
| Date: | 2010-11-30 10:41:14 |
| Message-ID: | 12F669C480864FB98FA173D0F467057A@andrusnotebook |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I installed PostgreSql 9 in Win server 2008 R2 x64 dedicated server and used
stack builder to optimize
postgresql.conf file as dedicated server.
Upsize program runs in same server.
Upsize starts transaction.
Then it creates new table, sends insert statements to server through ODBC
driver for every table.
After all data is sent, transaction is committed, analyze command is
executed, primary and foreign keys and other contraints are added.
Some tables are large. This process takes number of hours to complete.
Server hardware is modern, it it expected that this process should not take
so much time.
How to speed it up ? Should I turn sync off for upsize or other idea ?
How to increase
Andrus Moor
OÜ Eetasoft
Akadeemia 21-G302
Tallinn 12618
http://www.eetasoft.ee
http://eeva.eetasoft.ee
tel. 6654214, 6654215
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Farber | 2010-11-30 10:47:08 | Re: select max() |
| Previous Message | Gregory Machin | 2010-11-30 10:34:32 | advise on performance issues please |