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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.