Re: [BUGS] BUG #4313: Strange optimizer behaviour

2008-07-17 Thread Gregory Stark
"Daniel Podlejski" <[EMAIL PROTECTED]> writes: > I think there is no sense to cast too big value to numeric when field type > is integer. > On really big table this "bug" cause unnecessary io load. Well, for example, the same logic doesn't hold for < where all the records would satisfy the inequa

[BUGS] BUG #4313: Strange optimizer behaviour

2008-07-17 Thread Daniel Podlejski
The following bug has been logged online: Bug reference: 4313 Logged by: Daniel Podlejski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1, 8.3.3 Operating system: Linux Description:Strange optimizer behaviour Details: cvalley_dev=# \d messages