Re: Reg. Restore

Thanks for your reply.

---> You should update to a more current minor release.

Recently I updated to 9.1.5. I will do in near future.

--> You need to provide more information on how you backed up, how you
are restoring, and what the bottleneck seems to be.

I am pg_restore using for restoring the backup which created using pg_dump.

Thanks in Advance

Regards

Ramana

On Mon, Oct 7, 2013 at 10:43 PM, Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:

> Venakata Ramana <ramana(dot)pls(at)gmail(dot)com> wrote:
>
> > I am using postgresql 9.1.5. on windows Xp.
>
> You should update to a more current minor release.
>
> http://www.postgresql.org/support/versioning/
>
> > 1. Restore of DB is very slow.
> > How to improve the speed of Restore?
>
> You need to provide more information on how you backed up, how you
> are restoring, and what the bottleneck seems to be.
>
> http://www.postgresql.org/docs/9.1/interactive/backup.html
>
>
> > 2. Without indexes, retrieving from table is fast?
> > After creating an index on that table, then the retrieval
> > become slow.
>
> There's not enough information to give much advice. Please read
> this page and start a new thread on the pgsql-performance list:
>
> http://wiki.postgresql.org/wiki/SlowQueryQuestions
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>