Re: Real time query analyzer

-----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-----