On Sun, Jun 17, 2012 at 4:32 PM, Bill House <wch-tech(at)house-grp(dot)net> wrote:
> I have a written a script which does what I want it to do on a table
> with 999 records.
> I was wondering if there is anything I need to consider if I run this
> script on a table with 1.1 million records?
It looks fine for me. The only note is that, I may be wrong, but
"UPDATE %s SET del = False" updates the records having del already
false too, taking more time and creating unnecessary bloat. Adding
"WHERE del" may help keeping the bloat to the minimum.
In response to
psycopg by date
|Next:||From: Bill House||Date: 2012-06-17 18:11:12|
|Subject: Re: Capacity questions|
|Previous:||From: Daniele Varrazzo||Date: 2012-06-17 16:32:58|
|Subject: Re: When I select a single column, can I prevent getting a
list of one-element tuples?|