:(( VEEERRRRYYYY SLLLOOOWWWWWW!
| От | Costin Manda |
|---|---|
| Тема | :(( VEEERRRRYYYY SLLLOOOWWWWWW! |
| Дата | |
| Msg-id | 002b01c53389$15868240$1877e2c1@interpoint.ro обсуждение исходный текст |
| Ответ на | how to connect to posgresql 8 using vb (Ramon Orticio <rporticio@yahoo.com>) |
| Список | pgsql-novice |
I have this computer using postgres and PHP script that access and insert values in this database. I also have a computer with a MsSQL db on it. I made a script to read and update values from the MsSQL db to postgres. At the time I had postgres 7.4.1 and the script went excruciatingly slow. Something like 4 inserts per second! I tried every optimisation trick I could find on the net, but to no avail. Finally I upgraded to 8.0.1 and the script ran INSTANTLY! like, 200 thousand inserts in 10 minutes. So I was very happy about it. But yesterday the power went off. When I restarted the computer, the script went very slow again. I tried vacuuming, reindexing, deleting all indexes and recreating them, using pg_resetxlog, changing linux kernel variables and postgres configuration variables. Nothing helps! PLEASE!! Help me or kill me!
В списке pgsql-novice по дате отправления: