[PERFORM] performance while importing a very large data set in to database

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 dum

Re: [PERFORM] Estimates on partial index

K te er Xi Sent from Nine From: Jim Nasby Sent: 19-Aug-2016 03:32 To: Jeff Janes; Victor Yegorov Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Estimates on partial index On 8/18/16 3:06 PM, Jeff Janes wrote: > If you can