From: Mark Stosberg <mark@summersault.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: getting the most of out multi-core systems for repeated complex SELECT statements
Date: Thu, 03 Feb 2011 11:16:15 -0500
Message-ID: <4D4AD4CF.5060702@summersault.com> (raw)
In-Reply-To: <Pine.LNX.4.64.1102031849380.31836@sn.sai.msu.ru>
References: <iiegdj$jtg$1@dough.gmane.org>
<Pine.LNX.4.64.1102031849380.31836@sn.sai.msu.ru>
On 02/03/2011 10:54 AM, Oleg Bartunov wrote:
> Mark,
>
> you could try gevel module to get structure of GIST index and look if
> items distributed more or less homogenous (see different levels). You
> can visualize index like http://www.sai.msu.su/~megera/wiki/Rtree_Index
> Also, if your searches are neighbourhood searches, them you could try
> knn, available
> in 9.1 development version.
Oleg,
Those are interesting details to consider. I read more about KNN here:
http://www.depesz.com/index.php/2010/12/11/waiting-for-9-1-knngist/
Will I be able to use it improve the performance of finding nearby
zipcodes? It sounds like KNN has great potential for performance
improvements!
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark@summersault.com
Subject: Re: getting the most of out multi-core systems for repeated complex SELECT statements
In-Reply-To: <4D4AD4CF.5060702@summersault.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox