Are SQL functions better than PG/SQL ones?
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.
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
Show quoted text
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
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?
--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@hotmail.com
Yahoo!: VitalyBe
Import Notes
Reply to msg id not found: 4835549.1090039927604.JavaMail.root@hercules