From: Aaron Bono <postgresql@aranya.com>
To: Hilary Forbes <hforbes@dmr.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: System catalog table privileges
Date: Mon, 24 Jul 2006 10:56:13 -0500
Message-ID: <bf05e51c0607240856l5acb918cw762fdc123baaa3f3@mail.gmail.com> (raw)
In-Reply-To: <5.1.0.14.0.20060721171518.035c4008@mailserver.dmr.co.uk>
References: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk>
<5.1.0.14.0.20060721171518.035c4008@mailserver.dmr.co.uk>
On 7/21/06, Hilary Forbes <hforbes@dmr.co.uk> wrote:
>
> Aaron
>
> Thanks for this one - I had actually wondered about doing that but the
> trouble is that they say that they need up to the minute reports not "as of
> last night". Indeed, I do have another app where I do just that because I
> find that reports indexes/requirements are very different to transactional
> type requirements. However, you have made me make up my mind to see if I
> can persuade them to work on data that is a day old.
>
I have heard "I need up to the minute data" a lot but have NEVER seen it to
be true. I guess if you are trading stocks on the stock market and need to
buy and sell immediately as the prices change then you would have a reason
but almost always business users think they need things now when they don't.
You could also look at the cost/benefit: if they bring the database down,
how much would it cost the business? If they are working on day old data,
how much would it cost? Get the user to write down and justify their
numbers. This will show to you and the user whether it is really necessary
to report off of the live data.
Good luck!
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, hforbes@dmr.co.uk
Subject: Re: System catalog table privileges
In-Reply-To: <bf05e51c0607240856l5acb918cw762fdc123baaa3f3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox