Skip site navigation (1) Skip section navigation (2)

Re: slow self-join query

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 (view raw or flat)
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)

In response to

Responses

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2012-03-19 16:45:56
Subject: Re: slow self-join query
Previous:From: Kevin GrittnerDate: 2012-03-19 14:27:06
Subject: Re: slow self-join query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group