Re: performance problems inserting random vals in index

From: Leonardo F <m_lists(at)yahoo(dot)it>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: performance problems inserting random vals in index
Date: 2010-04-20 06:52:43
Message-ID: 938636.36439.qm@web29008.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> The usual set of tricks is to
> increase shared_buffers, checkpoint_segments, and checkpoint_timeout to cut down

Uh, didn't know shared_buffers played a role in index insertion as well...
got to try that. Thank you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rene Schickbauer 2010-04-20 07:10:48 Re: Virtual table with pl/perl?
Previous Message Leonardo F 2010-04-20 06:51:01 Re: performance problems inserting random vals in index