Right, the view that prompted this involved subqueries; the function was just
an artificial test case.
That change seems like a good one for sure.
Ideally I'd like to enable it for a particular view rather than incur the
planning expense for the whole DB (something like ALTER VIEW foo WITH
CON
Hi everyone,
I did a software upgrade, and with it came a new feature where when
selecting a customer it queries for the sum of a few columns. This
takes 7 seconds for the 'Cash Sale' customer - by far the most active
customer. I'd like to see if it's possible to get it down a bit by
changin
2011/9/23 M. D.
>
> I did a software upgrade, and with it came a new feature where when
> selecting a customer it queries for the sum of a few columns. This takes 7
> seconds for the 'Cash Sale' customer - by far the most active customer. I'd
> like to see if it's possible to get it down a bit b
Hello,
It is interesting how PostgreSQL reads the tablefiie.
Whether its indexes store/use filesystem clusters locations containing
required data (so it can issue a low level cluster read) or it just
fseeks inside a file?
Thank you
--
Sent via pgsql-performance mailing list (pgsql-performance@p
