Re: index on partitioned table

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Wojtek <foo(at)twine(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: index on partitioned table
Date: 2010-02-05 18:23:17
Message-ID: 603c8f071002051023s3101e1f6r5d330b98b491d4bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2010/2/5 Wojtek <foo(at)twine(dot)pl>:
> Most of my queries will have where conditions on timedate and sys_device_id, but a lot of them will have additional clause: where usefields is not null. Some of the queries will be limited on timedate only.

What about a partial index on (timedate) WHERE usefields IS NOT NULL;
or maybe on (timedate, sys_device_id) WHERE usefields IS NOT NULL?

...Robert

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Glenn Maynard 2010-02-06 01:35:39 Re: Slow query: table iteration (8.3)
Previous Message Robert Haas 2010-02-05 18:17:01 Re: foreign key constraint lock behavour in postgresql