Re: [Pypgsql-users] Querying large sets with PyPgSQL

[Aaron H. <aa...@Me...>]

Mike Watkins wrote:
> I realize my question is largely a Postgres domain question, but would 
> like to know if any PyPgSQL users are routinely manipulating data sets 
> containing tens of millions of records.

100 million records on a dual PIII 1200 w/ 2 Gig RAM and 15k SCSI
updating 20 million via pypgSQL takes about 25 minutes.

Seaches take seconds.

-Aaron