Re: Restore performance?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Cc: Jesper Krogh <jesper(at)krogh(dot)cc>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Restore performance?
Date: 2006-04-10 16:23:45
Message-ID: 20060410162345.GA2461@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Rajesh Kumar Mallah wrote:
> 4. fsync can also be turned off while loading huge dataset ,
> but seek others comments too (as study docs) as i am not sure about the
> reliability. i think it can make a lot of difference.

Also be sure to increase maintenance_work_mem so that index creation
goes faster.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Oscar Picasso 2006-04-10 16:58:57 Better index stategy for many fields with few values
Previous Message Rajesh Kumar Mallah 2006-04-10 16:08:48 Re: Restore performance?