Re: performance while importing a very large data set in to database

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance while importing a very large data set in to database
Date: 2009-12-05 19:25:12
Message-ID: 4B1AB398.6080603@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 12/02/2009 11:31 PM, Ashish Kumar Singh wrote:
> While importing this dump in to database I have noticed that initially
> query response time is very slow but it does improves with time.
>
> Any suggestions to improve performance after dump in imported in to
> database will be highly appreciated!

Analyse your tables?
-J

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2009-12-05 20:00:00 Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum
Previous Message Ing . Marcos Luís Ortíz Valmaseda 2009-12-05 14:16:38 Re: performance while importing a very large data set in to database