Re: views, queries, and locks

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: views, queries, and locks
Date: 2012-04-03 17:48:57
Message-ID: jlfd61$o7s$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jon Nelson wrote on 03.04.2012 19:01:
> I also update this view with CREATE OR REPLACE VIEW every 15-30 minutes

That is a highly questionable approach.

What real problem are you trying to solve with that?
Maybe there is a better solution that does not require changing the view.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message leaf_yxj 2012-04-03 17:49:23 Re: Please help me to take a look of the erros in my functions. Thanks.
Previous Message Jon Nelson 2012-04-03 17:30:25 Re: views, queries, and locks