Reg. Restore

From: Venakata Ramana <ramana(dot)pls(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Reg. Restore
Date: 2013-10-07 12:03:13
Message-ID: CACiDZ3XJYepcT6avqCoFeszdGJ4zVGm_BzaRTqx7iuWSnOnEuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 solution

Thanks in advance

Regards

Ramana

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2013-10-07 17:13:10 Re: Reg. Restore
Previous Message Jov 2013-10-07 08:27:50 Re: pg_stat_activity - proc id