Re: [PERFORM] Nested Loop "Killer" on 8.1

2009-06-26 Thread Dave North
ave > -Original Message- > From: gsst...@gmail.com [mailto:gsst...@gmail.com] On Behalf > Of Greg Stark > Sent: June 25, 2009 5:30 PM > To: Tom Lane > Cc: Dave North; pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Nested Loop "Killer" on 8.1 > &g

[PERFORM] Nested Loop "Killer" on 8.1

2009-06-24 Thread Dave North
WHERE web_user_id IN (SELECT web_user_id FROM web_user_grp_member WHERE member_id = 249 ORDER BY name; Thanks in advance Dave Dave North dno...@signiant.com

Re: [PERFORM] Database size Vs performance degradation

2008-07-30 Thread Dave North
> -Original Message- > From: Greg Smith [mailto:[EMAIL PROTECTED] > Sent: July 30, 2008 12:48 PM > To: Dave North > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Database size Vs performance degradation > > On Wed, 30 Jul 2008, Dave North wrote

Re: [PERFORM] Database size Vs performance degradation

2008-07-30 Thread Dave North
l Message- > From: Valentin Bogdanov [mailto:[EMAIL PROTECTED] > Sent: July 30, 2008 10:58 AM > To: pgsql-performance@postgresql.org; Dave North > Subject: Re: [PERFORM] Database size Vs performance degradation > > I am guessing that you are using DELETE to remove the 75

Re: [PERFORM] Database size Vs performance degradation

2008-07-30 Thread Dave North
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Wakeling Sent: July 30, 2008 8:37 AM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Database size Vs performance degradation On Wed, 30 Jul 2008, Dave North wrote: > Running on

Re: [PERFORM] Database size Vs performance degradation

2008-07-30 Thread Dave North
-Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: July 30, 2008 8:28 AM To: Dave North Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Database size Vs performance degradation Dave North wrote: > Morning folks, > Long time listener, firs

[PERFORM] Database size Vs performance degradation

2008-07-30 Thread Dave North
igher shared_buffers rather than relying so much on OS cache? Yes, I know we need to upgrade to 8.3 but that's going to take some time :) Many thanks in advance. Dave ___ Dave North [EMAIL PROTECTED] Signiant - Making Media Move Visit Signiant at: www.signiant.com <http://www.signiant.com