Re: Old data (was Re: Long term database archival)

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: Old data (was Re: Long term database archival)
Дата
Msg-id 20060707005912.36153.qmail@web31808.mail.mud.yahoo.com
обсуждение исходный текст
Список pgsql-general
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Richard Broersma Jr wrote:
> [snip]
> > I am not to sure of the relevance, but I periodically worked as a
> > sub-contractor for an Oil-producing Company in California.  They
> > were carrying 35 years of data on an Alpha Server running
> > Ca-Ingres.  The really bad part is that hundreds and hundreds of
> > reporting tables were created on top of the functioning system
> > for reporting over the years.  Now nobody know which tables are
> > relevant and with are redundant and or deprecated.
> >
> > Also year after year, new custom text file reports were created
> > with procedural scrips.  The load on the server was such that the
> > daily reporting was taking near taking 23 hours to complete.  And
> >  the requests for new reports was getting the IT department very
> > worried.
> >
> > Worst of all know one there really know the ins and outs of
> > Ingres to do anything about it.
> >
> > Well, I take part of that back.  They recently upgrade to a newer
> > alpha to reduce the time daily reporting was taking. :-)
>
> OpenVMS never stops, does it?  :)
>
> We've got some big OLTP systems running RDB.  I dread having to move
> to Oracle, even though it will be running on Linux.


I don't know but maybe some-one else on the list will. :-)

Regards,

Richard Broersma Jr.


В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: How do I revoke CREATE TABLE and other privileges?
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Long term database archival