Re: GiST index performance - Mailing list pgsql-performance

From Greg Smith
Subject Re: GiST index performance
Date
Msg-id alpine.GSO.2.01.0906261028320.1033@westnet.com
Whole thread Raw
In response to Re: GiST index performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: GiST index performance
List pgsql-performance
On Thu, 11 Jun 2009, Tom Lane wrote:

> Matthew Wakeling <matthew@flymine.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.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Marcin Stępnicki
Date:
Subject: Re: slow DELETE on 12 M row table
Next
From: Robert Haas
Date:
Subject: Re: GiST index performance