Re: Reg. Restore

Thanks for your reply.

---> You should update to 9.1.9.

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

--> How are you doing this restore? Is it from a dump? Are you using or
could you use custom format?

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

--> That is odd. Perhaps your indexes are bloat or you don't have proper
statics on your tables?! Please, give us the EXPLAIN ANALYZE of the queries
with and without the indexes (you could use [2]), and run ANALYZE on the
table before it.

I used [2] option.

With Index, and With out Index came in White Color.

In this nDl and Nqr are query Plans i pasted. Please go through that.
Suggest me whether i am doing in correct way or not.

Thanks in Advance.

Regards

Ramana

On Mon, Oct 7, 2013 at 11:04 PM, Matheus de Oliveira <
matioli(dot)matheus(at)gmail(dot)com> wrote:

>
>
>
> On Mon, Oct 7, 2013 at 9:03 AM, Venakata Ramana <ramana(dot)pls(at)gmail(dot)com>wrote:
>
>> 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 or could
> you use custom format?
>
> At [1] there are some tips to help.
>
>
> 2. Without indexes, retrieving from table is fast?
>> After creating an index on that table, then the retrieval become slow.
>>
>>
> That is odd. Perhaps your indexes are bloat or you don't have proper
> statics on your tables?! Please, give us the EXPLAIN ANALYZE of the queries
> with and without the indexes (you could use [2]), and run ANALYZE on the
> table before it.
>
>
> [1] http://www.postgresql.org/docs/9.1/static/populate.html
> [2] http://explain.depesz.com/
>
> Regards,
> --
> Matheus de Oliveira
> Analista de Banco de Dados
> Dextra Sistemas - MPS.Br nível F!
> www.dextra.com.br/postgres
>
>