On Fri, Feb 20, 2009 at 10:45 PM, Uwe C. Schroeder u...@oss4u.com wrote:
On Friday 20 February 2009, Tena Sakai wrote:
Hi Scott,
What does explain and (it'll take a while to get
it) explain analyze select ... have to say?
...@gallo.ucsf.edu
-Original Message-
From: Uwe C. Schroeder [mailto:u...@oss4u.com]
Sent: Fri 2/20/2009 9:45 PM
To: pgsql-admin@postgresql.org
Cc: Tena Sakai; Scott Marlowe
Subject: Re: [ADMIN] very, very slow performance
On Friday 20 February 2009, Tena Sakai wrote:
Hi Scott,
What
in a day or two.
Many thanks for your help.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Sat 2/21/2009 12:57 AM
To: Uwe C. Schroeder
Cc: pgsql-admin@postgresql.org; Tena Sakai
Subject: Re: [ADMIN] very, very slow
Hello,
I have adjusted postgres parameters per your recommen-
dation. Work_mem is now 8GB,
GB is just a typo I guess? Otherwise the value is insanely high. See:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html
Peter
--
Sent via pgsql-admin mailing list
. Maybe I can
get him to say I am doing something WILD?! ;)
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
-Original Message-
From: Jan-Peter Seifert [mailto:jan-peter.seif...@gmx.de]
Sent: Sat 2/21/2009 5:45 AM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] very, very slow
On Sat, Feb 21, 2009 at 3:11 AM, Tena Sakai tsa...@gallo.ucsf.edu wrote:
Hi Scott,
Thanks for clustering suggestion. I have never used
cluster command and I need to read up before I can
use it.
I have adjusted postgres parameters per your recommen-
dation. Work_mem is now 8GB,
2009/2/20 Tena Sakai tsa...@gallo.ucsf.edu:
Hi Everybody,
Here's the query (please read them in fixed-size font, if
you can):
select subjectid, genotype.markerid, a1.value as allele1,
a2.value as allele2, genotype.dateCreated,
genotype.dateReplaced, genotype.ignore,
: [ADMIN] very, very slow performance
2009/2/20 Tena Sakai tsa...@gallo.ucsf.edu:
Hi Everybody,
Here's the query (please read them in fixed-size font, if
you can):
select subjectid, genotype.markerid, a1.value as allele1,
a2.value as allele2, genotype.dateCreated
on behalf of Emanuel Calvo Franco
Sent: Fri 2/20/2009 4:10 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] very, very slow performance
2009/2/20 Tena Sakai tsa...@gallo.ucsf.edu:
Hi Everybody,
Here's the query (please read them in fixed-size font, if
you can):
select subjectid
On Friday 20 February 2009, Tena Sakai wrote:
Hi Scott,
What does explain and (it'll take a while to get
it) explain analyze select ... have to say?
---
-- Hash Join (cost=165264.65..55486119.31
Hi Everybody,
I am running postgres v8.3.3 on redhat linux (del hardware)
with 4 cpu's. This machine is terribly bogged down and I
would like a bit of help as to what can be done.
For last maybe 18+/- hours, there are 24 queries happening.
What's odd is that 21 of them are identical queries.
On Thu, Feb 19, 2009 at 10:02 PM, Tena Sakai tsa...@gallo.ucsf.edu wrote:
Hi Everybody,
I am running postgres v8.3.3 on redhat linux (del hardware)
with 4 cpu's. This machine is terribly bogged down and I
would like a bit of help as to what can be done.
For last maybe 18+/- hours, there
12 matches
Mail list logo