DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=kzlkb5s1yGvej0cmtGaepgehs4+GIEkFAZMef9RbV/60eJKlr1UAIn4hPk8XBoRGL9
	McQUS4x3V1y9dvHmCzbu7LT3FBqWaCGFStkAuzIv4TkEyPVUnmCYsP2HCCcGGjz3Xc16
	/zMstSxeF12Kb4qKifpc7HeQH/qCBUb9iqu4Y=
Subject: Re: stored proc and inserting hundreds of thousands of rows
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
From: Joel Reymont <joelr1@gmail.com>
In-Reply-To: <4DBC106E020000250003D0A3@gw.wicourts.gov>
Date: Sat, 30 Apr 2011 22:22:24 +0100
Cc: "Pierre C" <lists@peufeu.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <4C9BC888-20CD-4923-8A2F-C79B3C9E4700@gmail.com>
References: <D5DE36B9-17CF-4A55-9119-CDC0BDC4E48D@gmail.com>
	<4DBC004C020000250003D099@gw.wicourts.gov>
	<4881277622113933088@unknownmsgid> <op.vuri6d2keorkce@apollo13>
	<7582830307139292886@unknownmsgid>
	<4DBC106E020000250003D0A3@gw.wicourts.gov>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>


On Apr 30, 2011, at 7:36 PM, Kevin Grittner wrote:

> It may even be amenable to knnGiST indexing (a new feature coming in
> 9.1), which would let you do your select with an ORDER BY on the
> distance.

I don't think I can wait for 9.1, need to go live in a month, with =
PostgreSQL or without.

> PostgreSQL has a lot of very cool features you just don't have in any =
other product!  :-)


There's a strong NoSQL lobby here and I'm trying my best to show that PG =
can handle the job!

=
--------------------------------------------------------------------------=

- for hire: mac osx device driver ninja, kernel extensions and usb =
drivers
=
---------------------+------------+---------------------------------------=

http://wagerlabs.com | @wagerlabs | =
http://www.linkedin.com/in/joelreymont
=
---------------------+------------+---------------------------------------=