[BUGS] BUG #4097: can join + where query be optimized?

2008-04-07 Thread Adriaan van Kekem
The following bug has been logged online: Bug reference: 4097 Logged by: Adriaan van Kekem Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Ubuntu 7.04 Description:can join + where query be optimized? Details: In the following query you

[BUGS] not sorted clustered index (8.2)

2007-11-05 Thread Adriaan van Kekem
hi, As part of the definition of a clustered index, the default sort of a table is based on the clustered index. In our application sometimes we see that the sort is invalid. Our table is like: iid identity (clustered primary key) data varchar if we do a query like: select * from table where i