Re: how to vacuum thru psycopg
Federico Di Gregorio <fog-NGVKUo/i/[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Organization | initd.org |
| Message-ID | <1244791398.4477.1.camel@erin> |
Il giorno gio, 11/06/2009 alle 19.46 -0700, Al Niessner ha scritto: > So, if I cannot do it with a cursor, then how do I do it? I have 20000 > large, complex items to add and time is growing linearly and will take > years to complete at its growth rate. However, if I can vacuum once in > a > while, then I can keep the time down to finish in a week or two. When inserting a lot of rows I found that, depending on your hardware and configuration, batching the INSERTs in transactions of a few hundredths items gives you maximum speed. -- Federico Di Gregorio http://people.initd.org/fog Debian GNU/Linux Developer [email protected] INIT.D Developer fog-NGVKUo/i/[email protected] Gli esseri umani, a volte, sono destinati, per il solo fatto di esistere, a fare del male a qualcuno. -- Haruki Murakami _______________________________________________ Psycopg mailing list Psycopg-IAPFreCvJWPBWskQ1e/[email protected] http://lists.initd.org/mailman/listinfo/psycopg
signature.asc
(application/pgp-signature, 197 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEABECAAYFAkoyAmEACgkQvcCgrgZGjetjhgCdEoEvMzuJWPsN/9dvLRK6XJ9q vlUAnilT1eTreiBDPleEo8DcjbzspRgX =Ds/6 -----END PGP SIGNATURE-----