On Mittwoch, 7. Mai 2008 Tom Lane wrote:
> No, the trigger command has to be BEFORE UPDATE not AFTER UPDATE for
> this to work. This is definitely the better way though because the
> row only gets updated once, not stored and then updated again
> (in fact, I think you could get into an infinite lo
Hi,
Barbara Stephenson a écrit :
We are new about autovacuum launcher on 8.3.1 and we are not sure what the
parameters should be set to. Is setting them to default ok until we can
monitor if it's vacumming too much?
You can do that. But the default are, as always with PostgreSQL, really
c
Hello,
I have one question - what is the difference between the view and a
function returning a data set? I mean the performance. Which is better
to use? If its the same, I would use functions, because I could use
other languages not just SQL to get the results I want.
Thank you in advance.
Oh I have to look at the other parameters. Once the database is up and it's
not vacuuming like we want how do we make changes to the conf file while the
database is running? Some signal?
Guillaume Lelarge wrote:
> Hi,
>
> Barbara Stephenson a écrit :
> > We are new about autovacuum launcher on
> Hi,
>
> Barbara Stephenson a écrit :
> > We are new about autovacuum launcher on 8.3.1 and we are not sure what
> the
> > parameters should be set to. Is setting them to default ok until we can
> > monitor if it's vacumming too much?
> >
>
> You can do that. But the default are, as always with
On Thursday 08 May 2008 06:16:06 Julius Tuskenis wrote:
> Hello,
>
> I have one question - what is the difference between the view and a
> function returning a data set? I mean the performance. Which is better
> to use? If its the same, I would use functions, because I could use
> other languages n
On Thu, May 8, 2008 at 4:16 AM, Julius Tuskenis <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have one question - what is the difference between the view and a
> function returning a data set? I mean the performance. Which is better to
> use? If its the same, I would use functions, because I could use
On 08/mag/08, at 12:16, Julius Tuskenis wrote:
Hello,
I have one question - what is the difference between the view and a
function returning a data set? I mean the performance. Which is
better to use? If its the same, I would use functions, because I
could use other languages not just SQL
