On Mon, May 29, 2006 at 07:35:14AM -0700, Cstdenis wrote:
> > To be honest, you're pushing things expecting a machine with only 1G to
> > serve 300 active connections. How large is the database itself?
>
> The database is 3.7G on disk. There is about 1G of actual data in it -- the
> rest is dead t
(Resending because my other send didn't get a CC to the list)
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Cstdenis" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 22, 2006 8:20 AM
Subject: Re: [PERFORM] How can I make this query faster (resend)
> On Fri, Ma
cost variables could be adjusted to
better reflect my server's hardware?
- Original Message -
From: "Markus Schaber" <[EMAIL PROTECTED]>
To: "Cstdenis" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 22, 2006 8:30 AM
Subject: Re: [PERFORM] How can I make
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Cstdenis" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 22, 2006 8:20 AM
Subject: Re: [PERFORM] How can I make this query faster (resend)
> On Fri, May 19, 2006 at 03:56:49PM -0700, Cstdenis wrote:
> > (Its bee
Hi, Cstendis,
Cstdenis wrote:
> Server is a dual xeon with a gig of ram dedicated mostly to postgresql.
> Here is the changed lines in my postgresql.conf: http://pastebin.ca/57222
3M is really low for a production server.
Try using pg_pool and limiting it to about 30 or so backend connections,
On Fri, May 19, 2006 at 03:56:49PM -0700, Cstdenis wrote:
> (Its been a hour and I dont see my message on the list so I'm sending it
> again. I've moved the queries and analyze out of the email incase it was
> rejected because too long)
>
> query: http://pastebin.ca/57218
>
> In the pictures ta
(Its been a hour and I dont see my message on the
list so I'm sending it again. I've moved the queries and analyze out of the
email incase it was rejected because too long)
query: http://pastebin.ca/57218
In the pictures table all the ratings have a shared index
CREATE INDEX idx_rating O
