subject:"\[GENERAL\] Using max\(\) MUCH slower in v7.1"

Re: [GENERAL] Using max() MUCH slower in v7.1

2001-01-17 Thread Tom Lane

"Gordan Bobic" <[EMAIL PROTECTED]> writes: > CREATE VIEW LastDate AS > SELECTCompany, > max(Date) AS Date > FROMPastInvoices > GROUP BYCompany; > And then call it like > SELECT Date FROM LastDate ORDER BY Date WHERE Company = 'SomeCompany'; > It ta

[GENERAL] Using max() MUCH slower in v7.1

2001-01-17 Thread Gordan Bobic

Hi. I have just upgraded from v7.0.3 to v7.1b3, and one of the things I am noticing is that doing a max() query search seems to take forever. For example, if I have a view like: CREATE VIEW LastDate AS SELECTCompany, max(Date) AS Date FROMPastInvoices