Re: [HACKERS] Composite index and min()

2015-02-26 Thread Jim Nasby
On 2/26/15 1:34 AM, James Sewell wrote: I have the following table: I'm moving this discussion to -general. -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To ma

[HACKERS] Composite index and min()

2015-02-25 Thread James Sewell
Hello, I have the following table: \d a Table "phxconfig.a" Column | Type | Modifiers ---+-+--- phx_run_id| integer | cell_id | integer | Indexes: "a_phx_run_id_cell_id_idx" btree (phx_run_id, cell_id) When I use a min() query I ge