-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/18/06 17:56, Jim C. Nasby wrote: > On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote: >>> In any case, you'll be much, much happier if you do this project on at >>> least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's >>> support requirements it will probably remain supported for a few more >>> years by Tom/the community, but you might start having issues getting >>> commercial support. >> We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to >> convince the SysAdmin to install 8.1 or 8.2. > > Typical reports are that 8.1 is 2x faster than 7.4, so it's probably > well worth it to do so. If support from Red Hat becomes an issue, > there's other options available. It's a definite goal! >> Since the data will be relatively static (only loaded monthly, and >> no updates or deletes) and in by-quarter tables, I'm thinking that >> it would be adequate to "pg_dump -t" on the /current/ tables, "tar >> cj", ftp the tarball it to a machine with a tape drive. > > If that's OK for backups then you could use the same technique to > upgrade (assuming upgrade-in-place isn't available). True. Reindexing that much data is not that high on my ways-to-use- resources list, though. ;) - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFNrPqS9HxQb37XmcRAsNhAJ9vc9zWXL8qZOrEm9fjjMKVOOiniwCdHyM+ akxBBNBLIy4oVAa3TI9ZM6Y= =B+wy -----END PGP SIGNATURE-----
