Re: Preventing query from hogging server

From: "Matthew Nuzum" <matt(dot)followers(at)gmail(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Preventing query from hogging server
Date: 2005-03-24 19:53:37
Message-ID: 42431ac6.29dd6143.2b52.ffffbf08@mx.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> How many rows in usage_access? How many groups do you expect?
> (Approximate answers are fine.) What PG version is this, and
> what's your sort_mem setting?
>
> regards, tom lane

I believe there are about 40,000,000 rows, I expect there to be about
10,000,000 groups. PostgreSQL version is 7.3.2 and the sort_mem is at the
default setting.

(I know that's an old version. We've been testing with 7.4 now and are
nearly ready to upgrade.)

--
Matthew Nuzum <matt(at)followers(dot)net>
www.followers.net - Makers of "Elite Content Management System"
View samples of Elite CMS in action by visiting
http://www.followers.net/portfolio/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Nuzum 2005-03-24 19:55:32 Re: Preventing query from hogging server
Previous Message Reid Thompson 2005-03-24 19:46:41 Configuration/Tuning of server/DB