-----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 g...@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
