I see. I'll redirect the question there then. Thanks. On Fri, 16 Jul 2004 23:32:13 -0500, mike g <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] Yahoo!: VitalyBe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html