Re: [GENERAL] index usage in multi-column ORDER BY

2005-07-11 Thread Adam Pritchard
> Not that it changes anything, but I assume you meant to create > the first index on c1. Yes, I did -- that was just a typo in the example. Thanks for pointing it out. Adam Pritchard ---(end of broadcast)--- TIP 4: Have you searched ou

[GENERAL] index usage in multi-column ORDER BY

2005-07-09 Thread Adam Pritchard
e results above suggest that an explosion of indexes would be required to support that. Is there some better way of doing it? Thank you. Adam Pritchard ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] many updates to single row in single transaction

2005-07-09 Thread Adam Pritchard
and without the speed degrading as it goes. Does anyone know why I'm seeing what I'm seeing or have suggestion on how to correct it? Thanks in advance. Adam Pritchard ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings