From: | Robert Poor <rdpoor(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, mmoncure(at)gmail(dot)com, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: slow self-join query |
Date: | 2012-03-19 15:22:17 |
Message-ID: | CAGHqdqVVwR5NvgpyC_eAp3fF8fQa_VA=SVaoEA3chx+eDjPq9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
@merlin, @kevin: Thank you both -- I'll try your suggestions as soon
as I get back to the mothership.
@kevin: I hear you. (I'm deeply steeped in Ruby on Rails and
foolishly assume that it's easy to read.) With that in mind:
\d user_associations
Table "public.user_associations"
Column | Type |
Modifiers
-------------+-----------------------------+---------------------------------------------------------
id | integer | not null default
nextval('followings_id_seq'::regclass)
leader_id | integer |
follower_id | integer |
created_at | timestamp without time zone | not null
updated_at | timestamp without time zone | not null
Indexes:
"followings_pkey" PRIMARY KEY, btree (id)
"index_followings_on_leader_id_and_follower_id" UNIQUE, btree
(leader_id, follower_id)
"index_followings_on_follower_id" btree (follower_id)
"index_followings_on_leader_id" btree (leader_id)
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-03-19 16:45:56 | Re: slow self-join query |
Previous Message | Kevin Grittner | 2012-03-19 14:27:06 | Re: slow self-join query |