Quick Links

Re: stored proc and inserting hundreds of thousands of rows

From:	"Pierre C" <lists(at)peufeu(dot)com>
To:	"Joel Reymont" <joelr1(at)gmail(dot)com>
Cc:	"pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: stored proc and inserting hundreds of thousands of rows
Date:	2011-04-30 18:04:51
Message-ID:	op.vuri6d2keorkce@apollo13
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

If you want to search by geographical coordinates, you could use a gist
index which can optimize that sort of things (like retrieving all rows
which fit in a box).

In response to

Re: stored proc and inserting hundreds of thousands of rows at 2011-04-30 17:58:50 from Joel Reymont

Responses

Re: stored proc and inserting hundreds of thousands of rows at 2011-04-30 18:14:31 from Joel Reymont

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Joel Reymont	2011-04-30 18:14:31	Re: stored proc and inserting hundreds of thousands of rows
Previous Message	Joel Reymont	2011-04-30 17:58:50	Re: stored proc and inserting hundreds of thousands of rows