Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UQR30-00025u-Ip for pgsql-sql@arkaria.postgresql.org; Thu, 11 Apr 2013 23:36:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UQR30-0003PB-2Z for pgsql-sql@arkaria.postgresql.org; Thu, 11 Apr 2013 23:36:54 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UQR2z-0003P5-48 for pgsql-sql@postgresql.org; Thu, 11 Apr 2013 23:36:53 +0000 Received: from zql.com ([206.222.31.58]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UQR2s-0003hB-6K for pgsql-sql@postgresql.org; Thu, 11 Apr 2013 23:36:52 +0000 Received: from localhost.localdomain ([127.0.0.1] helo=localhost) by zql.com with smtp (Exim 4.68) (envelope-from ) id 1UQR2r-0002TL-Oa; Thu, 11 Apr 2013 19:36:45 -0400 From: "Greg Sabino Mullane" To: pgsql-sql@postgresql.org Subject: Re: Advice for index design X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: Date: Thu, 11 Apr 2013 23:36:45 -0000 X-Mailer: JoyMail 3.0.1 Message-ID: X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Jorge Maldonado wrote: ... > What is a good index design approach? Maybe, setting simple separate > indexes (one for each field) would work fine if I need to > retrieve data in different combinatios, but I am not sure. Yes, just create separate indexes and you will be fine, especially given the very small size of the table. If you find your queries going slow, you could start investigating compound indexes (or in this case, partial indexes). - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201304111933 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAlFnSPYACgkQvJuQZxSWSshm6wCggdl2FyowAbca93hYKXGgcXoE iN0AniOL8OS3teTgk6thxkJjUGqEf15k =1Eb6 -----END PGP SIGNATURE----- -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql