performance while importing a very large data set in to database

From: "Ashish Kumar Singh" <ashishkumar(dot)singh(at)altair(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: performance while importing a very large data set in to database
Date: 2009-12-02 23:31:46
Message-ID: 4E4BE0891B34364AAA883AC3F85CF86803870DCC@blrex.prog.altair.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello Everyone,

I have a very bit big database around 15 million in size, and the dump
file is around 12 GB.

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!

Regards,

Ashish

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Neill 2009-12-03 01:31:01 Re: Order by (for 15 rows) adds 30 seconds to query time
Previous Message Kevin Grittner 2009-12-02 23:31:26 Re: Order by (for 15 rows) adds 30 seconds to query time