On 24 September 2010 00:12, Mark Kirkwood <mark.kirkwood@xxxxxxxxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
