Justin Clift wrote:
> Does anyone here have experience with Data Warehousing, and be able to
> give some advice as to PostgreSQL's suitability for it in regards to
> this? Am asking here as I have no clue of the answer(s) other than
> PostgreSQL does work with Crystal Reports, and hoping people can assist.
>
I have found Postgresql quite suitable for data warehousing :
- optimizer does star queries well - often better than 9.0.1, but slower
than 9.2.0
- fast load utility (COPY) is fast (not quite as fast as Oracle 9i)
- simpler to administer and tune compared to Oracle 9i
I would recommend that prospective buyers try this sort of thing out -
and I have (attempted) to make this very thing easy - see:
http://sourceforge.net/projects/benchw.
Its a "cut down", easy to run data warehouse benchmark. ( works against
Oracle and Postgresql and several others)
With respect to the query and modelling tools, I am not sure, my
experience has been with folk using JDBC ad-hoc query type applications,
which are quite Db agnostic.
Cheers
Mark