Postgres Pro
Downloads
Home   >   mailing lists

Re: performance problems inserting random vals in index - Mailing list pgsql-general

From Leonardo F
Subject Re: performance problems inserting random vals in index
Date
Msg-id 938636.36439.qm@web29008.mail.ird.yahoo.com
Whole thread Raw
In response to Re: performance problems inserting random vals in index  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: performance problems inserting random vals in index  (Leonardo F <m_lists@yahoo.it>)
List pgsql-general
Tree view 
> 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.

pgsql-general by date:

Previous
From: Leonardo F
Date:
Subject: Re: performance problems inserting random vals in index
Next
From: Rene Schickbauer
Date:
Subject: Re: Virtual table with pl/perl?