Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux