Hi: I've just migrated from Linux/PostgreSQL 7.2 to Windows/PostgreSQL 8.0.3. I have a large view. When I make:
"Select ..... WHERE mydate = 'anydate'" the view lasts 19 seconds to complete. But, when I make: "Select ..... WHERE mydate >= 'anydate'" the view lasts 7 minutes. With PostgreSQL 7.2 they both last for equal time. I did a vacuum analyze with no success. Please, could you help me? Thanks in advance _________________________________________________________________ Need software for your hardware? Click here http://www.asg.co.za ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
