Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E528E1337B8C for ; Thu, 17 Feb 2011 11:24:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 47608-07 for ; Thu, 17 Feb 2011 15:24:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tamriel.snowman.net (tamriel.snowman.net [72.66.115.51]) by mail.postgresql.org (Postfix) with ESMTP id 86E621337B4A for ; Thu, 17 Feb 2011 11:24:46 -0400 (AST) Received: by tamriel.snowman.net (Postfix, from userid 1000) id E9BF922954; Thu, 17 Feb 2011 10:24:45 -0500 (EST) Date: Thu, 17 Feb 2011 10:24:45 -0500 From: Stephen Frost To: Mark Stosberg Cc: pgsql-performance@postgresql.org Subject: Re: application of KNN code to US zipcode searches? Message-ID: <20110217152445.GV4116@tamriel.snowman.net> References: <4D5CE118020000250003AB83@gw.wicourts.gov> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="oWTZj2IXuq/WGFAU" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.6.32-5-amd64 (x86_64) X-Uptime: 10:22:53 up 14 days, 23:52, 6 users, load average: 0.06, 0.07, 0.02 User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/429 X-Sequence-Number: 42567 --oWTZj2IXuq/WGFAU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * Mark Stosberg (mark@summersault.com) wrote: > Recommendations? PostGIS, geometry columns, and UTM.. I'm not sure where they are wrt adding KNN support, but it's something they've been anxious to have for a while, so I expect support will come quickly. Thanks, Stephen --oWTZj2IXuq/WGFAU Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAk1dPb0ACgkQrzgMPqB3kij2jwCgleUHU8Ql3qHIAFJ8LTsyFV/J tbcAoIQkDuwC55zAV0Sadc6sCCwhX5NO =FNsY -----END PGP SIGNATURE----- --oWTZj2IXuq/WGFAU--