Skip site navigation (1) Skip section navigation (2)

Re: Memory usage - indexes

From: Tobias Brox <tobixen(at)gmail(dot)com>
To: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Memory usage - indexes
Date: 2010-09-24 20:00:03
Message-ID: AANLkTimgDEzMa0-9PXrnBfBz4HY_Q9zAP=RMWtVW4JXX@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 24 September 2010 00:12, Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)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 ...

In response to

pgsql-performance by date

Next:From: Tobias BroxDate: 2010-09-24 20:08:08
Subject: Re: Memory usage - indexes
Previous:From: Tobias BroxDate: 2010-09-24 19:58:12
Subject: Re: Memory usage - indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group