Skip site navigation (1) Skip section navigation (2)

Re: Suggestions for a data-warehouse migration routine

From: Mischa Sandberg <mischa(dot)sandberg(at)telus(dot)net>
To: Richard Rowell <richard(at)bowmansystems(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org,Mark Rinaudo <mark(at)bowmansystems(dot)com>
Subject: Re: Suggestions for a data-warehouse migration routine
Date: 2005-04-28 15:00:53
Message-ID: 1114700453.4270faa5894b1@webmail.telus.net (view raw or flat)
Thread:
Lists: pgsql-performance
Quoting Richard Rowell <richard(at)bowmansystems(dot)com>:

> I've ported enough of my companies database to Postgres to make
> warehousing on PG a real possibility.  I thought I would toss my
> data
> migration architecture ideas out for the list to shoot apart..
> 
[...]
Not much feedback required.

Yes, dropping the entire database is faster and simpler.
If your database is small enough that you can rebuild it from scratch
every time, go for it.

Yes, vacuum analyze required; creating indexes alone does not create
statistics.

From a I'd dump an extract of pg_stat[io_]user_(tables|indexes)
to see how index usage and table load changes over time.
-- 
"Dreams come true, not free." -- S.Sondheim, ITW 


In response to

pgsql-performance by date

Next:From: Mischa SandbergDate: 2005-04-28 15:21:36
Subject: Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
Previous:From: JeffDate: 2005-04-28 12:13:43
Subject: Re: Why is this system swapping?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group