Hi all, I'm upgrading from 7.1.3 to 7.2. Right now, I'm busy doing backups, so I have a little time to think. I'm thinking of changing some of the int8 fields into int4 fields, since this would save about 4 bytes/record and with 25 Million records, this is 100 MB just in the data per field, but the int8 values are also used in a few indexes, so I might save maybe a GB or so. The problem is, that the file which contains the pg_dump data is 2.8 GB in size and I don't want to tackle that with an editor. (Schema info lives in the front of the file, then follows the data, then follow the indexes).
In the old days, before editors where written is such a way that they suck all the data into their buffer all at once, we had stuff which only loaded so-and-so many KB at a time. Is there still something like that out there which is safe to use with a Postgres dump file? Best regards, Chris -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
