Re: how to vacuum thru psycopg
Tim Roberts <[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Organization | Providenza & Boekelheide, Inc. |
| Message-ID | <[email protected]> |
Tim Roberts wrote: > If you're doing it with a Python dictionary, then it will still be > linear in time, but it will be a much shorter time. > Following up on my own post, it would be quite reasonable to read the entire key/value table into a dictionary to enable this. If the whole table is only a few megabytes, that's nothing. That would allow you to do the uniqueness checks without ever going to the server. -- Tim Roberts, [email protected] Providenza & Boekelheide, Inc.