Re: postgres performance: comparing 2 data centers - Mailing list pgsql-performance

From Rod Taylor
Subject Re: postgres performance: comparing 2 data centers
Date
Msg-id 1086388027.67371.92.camel@jester
Whole thread Raw
In response to Re: postgres performance: comparing 2 data centers  ("Michael Nonemacher" <Michael_Nonemacher@messageone.com>)
List pgsql-performance
> The members table contains about 500k rows.  It has an index on
> (group_id, member_id) and on (member_id, group_id).


Yes, bad stats are causing it to pick a poor plan, but you're giving it
too many options (which doesn't help) and using space up unnecessarily.

Keep (group_id, member_id)
Remove (member_id, group_id)
Add (member_id)

An index on just member_id is actually going to perform better than
member_id, group_id since it has a smaller footprint on the disk.

Anytime where both group_id and member_id are in the query, the
(group_id, member_id) index will likely be used.

--
Rod Taylor <rbt [at] rbt [dot] ca>

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
PGP Key: http://www.rbt.ca/signature.asc


pgsql-performance by date:

Previous
From: Laurent Martelli
Date:
Subject: Re: Query involving views
Next
From: Markus Schaber
Date:
Subject: Re: [JDBC] Using a COPY...FROM through JDBC?