Postgres Pro
Downloads
Home   >   mailing lists

Re: stored proc and inserting hundreds of thousands of rows - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: stored proc and inserting hundreds of thousands of rows
Date
Msg-id 4DBC004C020000250003D099@gw.wicourts.gov
Whole thread Raw
In response to stored proc and inserting hundreds of thousands of rows  (Joel Reymont <joelr1@gmail.com>)
Responses Re: stored proc and inserting hundreds of thousands of rows  (Joel Reymont <joelr1@gmail.com>)
Re: stored proc and inserting hundreds of thousands of rows  (Joel Reymont <joelr1@gmail.com>)
List pgsql-performance
Tree view 
Joel Reymont <joelr1@gmail.com> wrote:

> We have 2 million documents now and linking an ad to all of them
> takes 5 minutes on my top-of-the-line SSD MacBook Pro.

How long does it take to run just the SELECT part of the INSERT by
itself?

-Kevin

pgsql-performance by date:

Previous
From: Joel Reymont
Date:
Subject: stored proc and inserting hundreds of thousands of rows
Next
From: Joel Reymont
Date:
Subject: Re: stored proc and inserting hundreds of thousands of rows