Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group