On 24 September 2010 00:12, Mark Kirkwood <[email protected]> wrote: > Re index size, you could try indexes like: > > some_table(a) > some_table(b) > > which may occupy less space, and the optimizer can bitmap and/or them to > work like the compound index some_table(a,b).
Hm ... never considered that ... but is it cost effective on large indexes? I guess I should do some testing ... -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
