Skip site navigation (1) Skip section navigation (2)

Re: Capacity questions

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Bill House <wch-tech(at)house-grp(dot)net>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Capacity questions
Date: 2012-06-17 18:02:17
Message-ID: CA+mi_8YTejGq9ARStOgo6_Y8cxp8Zot+zrVSLefDo2+pKVy=AA@mail.gmail.com (view raw or flat)
Thread:
Lists: psycopg
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.

-- Daniele

In response to

Responses

psycopg by date

Next:From: Bill HouseDate: 2012-06-17 18:11:12
Subject: Re: Capacity questions
Previous:From: Daniele VarrazzoDate: 2012-06-17 16:32:58
Subject: Re: When I select a single column, can I prevent getting a list of one-element tuples?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group