Re: [ADMIN] very, very slow performance

2009-02-21 Thread Scott Marlowe
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?

Re: [ADMIN] very, very slow performance

2009-02-21 Thread Tena Sakai
...@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

Re: [ADMIN] very, very slow performance

2009-02-21 Thread Tena Sakai
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

Re: [ADMIN] very, very slow performance

2009-02-21 Thread Jan-Peter Seifert
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

Re: [ADMIN] very, very slow performance

2009-02-21 Thread Tena Sakai
. 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

Re: [ADMIN] very, very slow performance

2009-02-21 Thread Scott Marlowe
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,

Re: [ADMIN] very, very slow performance

2009-02-20 Thread Emanuel Calvo Franco
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,

Re: [ADMIN] very, very slow performance

2009-02-20 Thread Tena Sakai
: [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

Fwd: [ADMIN] very, very slow performance

2009-02-20 Thread Emanuel Calvo Franco
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

Re: [ADMIN] very, very slow performance

2009-02-20 Thread Uwe C. Schroeder
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

[ADMIN] very, very slow performance

2009-02-19 Thread Tena Sakai
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.

Re: [ADMIN] very, very slow performance

2009-02-19 Thread Scott Marlowe
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