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	April 21, 2010 10:36:29
Msg-id	516768.87883.qm@web29016.mail.ird.yahoo.com Whole thread Raw
In response to	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

That did it. Setting a much higher shared_buffers helped quite a lot.


Thank you everybody for your suggestions.

pgsql-general by date:

From: Andre Lopes
Date: 21 April 2010, 09:01:40
Subject: Database viewpoint of subject - Sending e-mails from database table with Cronjob

From: Leonardo F
Date: 21 April 2010, 10:45:50
Subject: Performance impact of hundreds of partitions

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

Previous

Next