Postgres Pro
Downloads
Home   >   mailing lists

Reg. Restore - Mailing list pgsql-admin

From Venakata Ramana
Subject Reg. Restore
Date
Msg-id CACiDZ3XJYepcT6avqCoFeszdGJ4zVGm_BzaRTqx7iuWSnOnEuA@mail.gmail.com
Whole thread Raw
Responses Re: Reg. Restore
Re: Reg. Restore
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Jov
Date:
Subject: Re: pg_stat_activity - proc id
Next
From: Matheus de Oliveira
Date:
Subject: Re: Reg. Restore