Re: [PERFORM] slow self-join query

2012-03-17 Thread Scott Marlowe
On Sat, Mar 17, 2012 at 2:56 PM, Robert Poor wrote: > Disclaimer: this is a re-post, since I wasn't subscribed the first > time I posted.  Pardon if this is a duplicate.] > > The following query is abysmally slow (e.g. 7 hours+).  The goal is to > find "among the users that follow user #1, who do

[PERFORM] slow self-join query

2012-03-17 Thread Robert Poor
Disclaimer: this is a re-post, since I wasn't subscribed the first time I posted. Pardon if this is a duplicate.] The following query is abysmally slow (e.g. 7 hours+). The goal is to find "among the users that follow user #1, who do they also follow?" and to count the latter. SELECT L2.foll

Re: [PERFORM] Shared memory for large PostGIS operations

2012-03-17 Thread Kevin Grittner
Andy Colson wrote: On 03/16/2012 05:30 PM, Kevin Grittner wrote: >> Ah, I didn't pick up on the attempts at humor; perhaps that's why >> you mistook something I said as an attempt at an insult. > > It wasn't you Kevin, it was me that insulted him. (Although I was > trying to be funny, and not me

Re: [PERFORM] Shared memory for large PostGIS operations

2012-03-17 Thread Andy Colson
On 03/16/2012 05:30 PM, Kevin Grittner wrote: Brian Hamlin wrote: On Mar 16, 2012, at 7:17 AM, Kevin Grittner wrote: Andy Colson wrote: I tried shared_buffers at both 2400M and 18000M, and it took 4.5 hours both times. ... (weak attempts at humor omitted) Ah, I didn't pick up on the