Re: GiST index performance

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: GiST index performance
Date: 2009-06-26 15:00:24
Message-ID: 603c8f070906260800h601bb72epd69ea180a44d7e07@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jun 26, 2009 at 10:33 AM, Greg Smith<gsmith(at)gregsmith(dot)com> wrote:
> On Thu, 11 Jun 2009, Tom Lane wrote:
>
>> Matthew Wakeling <matthew(at)flymine(dot)org> writes:
>>>
>>> Oprofile scares me with the sheer number of options.
>>
>> You can ignore practically all of them; the defaults are pretty sane.
>> The recipe I usually follow is:
>
> An excellent brain dump from Tom and lots of other good stuff in this
> thread.  I just dumped a summary of all the profiling lore discussed onto
> http://wiki.postgresql.org/wiki/Profiling_with_OProfile as I don't know that
> I've ever seen a concise intro to this subject before.

Nice, thanks!

...Robert

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message bob_lunney 2009-06-26 17:25:29 Insert performance and multi-column index order
Previous Message Greg Smith 2009-06-26 14:33:24 Re: GiST index performance