Re: Memory usage - indexes - Mailing list pgsql-performance

From Tobias Brox
Subject Re: Memory usage - indexes
Date
Msg-id AANLkTimgDEzMa0-9PXrnBfBz4HY_Q9zAP=RMWtVW4JXX@mail.gmail.com
Whole thread Raw
In response to Re: Memory usage - indexes  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-performance
On 24 September 2010 00:12, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> 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 ...

pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: Memory usage - indexes
Next
From: Tobias Brox
Date:
Subject: Re: Memory usage - indexes