On Mon, 25 Feb 2008 14:11:16 -0800
"Joshua D. Drake" <jd@commandprompt.com> wrote:
O.k. with 24 connections 3.5 hours. Testing with 12 now. 6 never
finished due to a bug.
Observations:
As simple as this solution is, it is not eloquent nor is it smart.
Using this method, if you have a 100GB table (which is very common)
you are still bound in a bad way by a single connection and you are
holding up everyone else.
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit