X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 88C599FAE4E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 24 Jul 2006 12:56:25 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 79972-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 24 Jul 2006 15:56:19 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.184])
	by postgresql.org (Postfix) with ESMTP id 93A659FA5BF
	for <pgsql-sql@postgresql.org>; Mon, 24 Jul 2006 12:56:17 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id p77so1533166nfc
	for <pgsql-sql@postgresql.org>; Mon, 24 Jul 2006 08:56:14 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=jx+dliFnPfBESuCcmwEtHU2fkYIZbXzlChm9a8bKccM9muwDGDvwLHS7kX/tRpgNJBbUDpxLaE6P5AVaC2cUn2GPK8WL/c/xoDC0IMrBT72li86Qkge+ILw4C9Fyf2haCadOmaW3cfOUqKDXIGQaxxUm94yNtImJDAsikP8jHB8=
Received: by 10.78.165.16 with SMTP id n16mr1594708hue;
	Mon, 24 Jul 2006 08:56:13 -0700 (PDT)
Received: by 10.78.32.10 with HTTP; Mon, 24 Jul 2006 08:56:13 -0700 (PDT)
Message-ID: <bf05e51c0607240856l5acb918cw762fdc123baaa3f3@mail.gmail.com>
Date: Mon, 24 Jul 2006 10:56:13 -0500
From: "Aaron Bono" <postgresql@aranya.com>
To: "Hilary Forbes" <hforbes@dmr.co.uk>
Subject: Re: System catalog table privileges
Cc: pgsql-sql@postgresql.org
In-Reply-To: <5.1.0.14.0.20060721171518.035c4008@mailserver.dmr.co.uk>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_127515_28355562.1153756573871"
References: <5.1.0.14.0.20060721133547.040c0e28@mailserver.dmr.co.uk>
	<5.1.0.14.0.20060721171518.035c4008@mailserver.dmr.co.uk>
X-Google-Sender-Auth: aad653bcfba4829c
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.2 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200607/297
X-Sequence-Number: 25871

------=_Part_127515_28355562.1153756573871
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_127515_28355562.1153756573871
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 7/21/06, <b class="gmail_sendername">Hilary Forbes</b> &lt;<a href="mailto:hforbes@dmr.co.uk">hforbes@dmr.co.uk</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
Aaron<br><br>
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
&quot;as of last night&quot;.&nbsp; 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.&nbsp; 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.</div></blockquote><div><br>&nbsp;</div>I have heard &quot;I need up to the minute data&quot; a lot but have NEVER seen it to be true.&nbsp; 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.
<br><br>You could also look at the cost/benefit: if they bring the database down, how much would it cost the business?&nbsp; If they are working on day old data, how much would it cost?&nbsp; Get the user to write down and justify their numbers.&nbsp; This will show to you and the user whether it is really necessary to report off of the live data.
<br><br>Good luck!<br></div><br>==================================================================<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.<br>&nbsp;&nbsp; <a href="http://www.aranya.com">http://www.aranya.com</a><br>
==================================================================

------=_Part_127515_28355562.1153756573871--