PostgreSQL 9.1

[oracle3001]

Will PT3 work with PostgreSQL 9.1? It is now in RC stage, and wonder if there will be any likely issues if I upgrade with respect to the functionality of PT3.

[kraada]

Looking over the changelog quickly I see no reason why it wouldn't work, but as far as I know we haven't tested it ourselves yet - we're a bit focused on PT4 at the moment.

[tarix]

Looking over the changelog quickly I see no reason why it wouldn't work.

Every single major Postgres upgrade has caused issues for users who were quick to update. If you want to test 9.1 make sure you keep your important data in a previous version of Postgres.

[kraada]

I've since been informed that there was testing done on several of the 9.1 betas and they caused severe problems for those who tested, so please tread with caution.

[funkyj]

My PT3 currently uses PostgreSQL v8.3.9 (that is what shows up in DB management).

Should I expect to see better performance with 9.0? Is there a compelling reason to upgrade?

TANGENT: I too have seen the import h/s rate go down over time when doing a large import. Presumably there is no solution to this issue?

BTW, my system is a thinkpad T61p, 8GB RAM, Windows-7, SSD (local C drive where the SQL DB and everything else lives)

[WhiteRider]

If you have 64-bit Windows you will get some performance improvement by installing the 64-bit version of PostgreSQL 9.0, but I don't have any figures for the exact improvement.

Please be aware that in order to use your database(s) in a new major version of PostgreSQL you will need to make a Backup before you update (while you are still using 8.3) and restore it when you are running 9.0.

If doing large bulk imports you may find better overall performance by splitting the import into somewhat smaller sets, and just running housekeeping once at the end.

[bdadavies]

When you say split the import into smaller sets, do you mean to run housekeeping at the end of each?

I cant see why splitting it and not running housekeeping several times would be quicker than not splitting it and only running housekeeping ta the end.

Can you shed a bit of light on this thanks.

[WhiteRider]

You'll probably get the fastest imports by importing less files in each batch.
You only need to run housekeeping once after you have done all the imports - that will be the most efficient method overall, but will be a single chunk of time running housekeeping. If you housekeeping after each batch of imports it will need to do much more work overall.