[ADMIN] Reg. Restore

2013-10-07 Thread Venakata Ramana
Hi, I am using postgresql 9.1.5. on windows Xp. I am facing two problems: 1. Restore of DB is very slow. How to improve the speed of Restore? 2. Without indexes, retrieving from table is fast? After creating an index on that table, then the retrieval become slow. plz prove any

Re: [ADMIN] Reg. Restore

2013-10-10 Thread Venakata Ramana
, Venakata Ramana ramana@gmail.comwrote: Hi, I am using postgresql 9.1.5. on windows Xp. You should update to 9.1.9. I am facing two problems: 1. Restore of DB is very slow. How to improve the speed of Restore? How are you doing this restore? Is it from a dump? Are you using