Le Friday 19 December 2008 20:15:37 David Lee Lambert, vous avez écrit :
> The advantage of a "C" stored procedure is speed:

Yes, for sure but it's also a bit more complex to install...

To speedup things (for reading), it's also possible to create an index (i will 
add the IMMUTABLE parameter)

Bye

> bacula=# SELECT MAX('a'||bacula_lstat_mtime(lstat)) FROM file WHERE
> fileid<1000000 ;
>             max
> -------------------------
>   a2008-02-27 20:24:10-05
> (1 row)
>
> Time: 70.689 ms
> bacula=# SELECT MAX(base64_decode_lstat(12,lstat)*interval '1 second' +
> timestamptz 'epoch') FROM file WHERE fileid<1000000 ;
>            max
> ------------------------
>   2008-02-27 20:24:10-05
> (1 row)
>
> Time: 762.390 ms
>
> Otherwise, the PL/perl function does the same thing; thanks for the
> pointer!
>
> ebollengier wrote:
> > You can also use the bweb pure PL function for that (see
> > bweb/scripts/bweb-postgresql.sql).
> >
> > DavidLeeLambert wrote:
> >> I was looking into making queries for a particular file in a Bacula
> >> Postgres database,  and came up with the attached functions.  [...]



------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users