DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=QHkcWPKi7ng/bMzvpAMfy67YlT68LF5DpdG9fUezYxqf4yzhKT0mIH2Ie/kcBr7uj27dOyAaIOE+NcNqrm9u458/3cjD0a45stQMk9sZ+SvlJ0aFTqfium5LJGmE3dJedFwKrZvHxnINzKhMcY0AG7o+l9HuHpqRDVaNEJx0DZs=;
References: 
 <CACiDZ3XJYepcT6avqCoFeszdGJ4zVGm_BzaRTqx7iuWSnOnEuA@mail.gmail.com>
Message-ID: <1381165990.68015.YahooMailNeo@web162906.mail.bf1.yahoo.com>
Date: Mon, 7 Oct 2013 10:13:10 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Reg. Restore
To: Venakata Ramana <ramana.pls@gmail.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CACiDZ3XJYepcT6avqCoFeszdGJ4zVGm_BzaRTqx7iuWSnOnEuA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Venakata Ramana <ramana.pls@gmail.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.
>=A0=A0=A0=A0 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?
>=A0=A0=A0=A0 After creating an index on that table, then the retrieval
>=A0=A0=A0=A0 become slow.

There's not enough information to give much advice.=A0 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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin