Thread: Are SQL functions better than PG/SQL ones?

Are SQL functions better than PG/SQL ones?

From

"Vitaly Belman"

Date:

16 July 2004, 18:58:22

I ready somewhere that PostgreSQL is able to optimize SQL functions,
the same way it does with views. For example if you do:

select * from cv_customers() order by customer_id;

When customers is an SQL function the optimizer/planner will be able to
actually use the customer_id index.

From some tests I made it doesn't seem true.. Yet I am asking to know
for sure.

Re: Are SQL functions better than PG/SQL ones?

From

mike g

Date:

17 July 2004, 04:35:38

Have you run the analyze function on the table or database?

We would need to see the sql for your tests to determine why it was or
was not used.

By the way the pgsql-performance list is probably a much better place to
discuss this.

Mike


On Sat, 2004-07-10 at 05:57, Vitaly Belman wrote:
> I ready somewhere that PostgreSQL is able to optimize SQL functions,
> the same way it does with views. For example if you do:
>
> select * from cv_customers() order by customer_id;
>
> When customers is an SQL function the optimizer/planner will be able to
> actually use the customer_id index.
>
> >From some tests I made it doesn't seem true.. Yet I am asking to know
> for sure.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

Re: Are SQL functions better than PG/SQL ones?

From

Vitaly Belman

Date:

18 July 2004, 21:27:51

I see. I'll redirect the question there then. Thanks.

On Fri, 16 Jul 2004 23:32:13 -0500, mike g <mike@thegodshalls.com> wrote:
> Have you run the analyze function on the table or database?
>
> We would need to see the sql for your tests to determine why it was or
> was not used.
>
> By the way the pgsql-performance list is probably a much better place to
> discuss this.
>
> Mike
>
> On Sat, 2004-07-10 at 05:57, Vitaly Belman wrote:
> > I ready somewhere that PostgreSQL is able to optimize SQL functions,
> > the same way it does with views. For example if you do:
> >
> > select * from cv_customers() order by customer_id;
> >
> > When customers is an SQL function the optimizer/planner will be able to
> > actually use the customer_id index.
> >
> > >From some tests I made it doesn't seem true.. Yet I am asking to know
> > for sure.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>


--
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent@hotmail.com
 Yahoo!: VitalyBe