pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres eating CPU
6+ messages / 4 participants
[nested] [flat]

* postgres eating CPU
@ 2004-11-17 22:13  silviapg@tiscali.it <silviapg@tiscali.it>
  0 siblings, 1 reply; 6+ messages in thread

From: silviapg@tiscali.it @ 2004-11-17 22:13 UTC (permalink / raw)
  To: pgsql-performance

Hi,

in March there was an interesting discussion on the list with the 
subject "postgres eating CPU on HP9000".

Now I'm the same problem on a Dell dual processor machine.

Anybody know if there was a solution?

Thanks

Piergiorgio



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: postgres eating CPU
@ 2004-11-17 22:27  Josh Berkus <josh@agliodbs.com>
  parent: silviapg@tiscali.it <silviapg@tiscali.it>
  0 siblings, 2 replies; 6+ messages in thread

From: Josh Berkus @ 2004-11-17 22:27 UTC (permalink / raw)
  To: pgsql-performance; +Cc: silviapg@tiscali.it <silviapg@tiscali.it>


> in March there was an interesting discussion on the list with the
> subject "postgres eating CPU on HP9000".

Link, please?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: postgres eating CPU
@ 2004-11-17 22:51  silviapg@tiscali.it <silviapg@tiscali.it>
  parent: Josh Berkus <josh@agliodbs.com>
  1 sibling, 2 replies; 6+ messages in thread

From: silviapg@tiscali.it @ 2004-11-17 22:51 UTC (permalink / raw)
  To: pgsql-performance; +Cc: josh@agliodbs.com

Josh Berkus wrote:

>>in March there was an interesting discussion on the list with the
>>subject "postgres eating CPU on HP9000".
>>    
>>
>
>Link, please?
>
>  
>

   http://archives.postgresql.org/pgsql-performance/2004-03/msg00380.php


  



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: postgres eating CPU
@ 2004-11-17 23:23  Josh Berkus <josh@agliodbs.com>
  parent: silviapg@tiscali.it <silviapg@tiscali.it>
  1 sibling, 0 replies; 6+ messages in thread

From: Josh Berkus @ 2004-11-17 23:23 UTC (permalink / raw)
  To: pgsql-performance; +Cc: silviapg@tiscali.it <silviapg@tiscali.it>


> >>in March there was an interesting discussion on the list with the
> >>subject "postgres eating CPU on HP9000".

Aha, this one.   Yeah, I believe that they upgraded to 7.4 inorder to deal 
with REINDEX issues.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: postgres eating CPU
@ 2004-11-17 23:38  Tom Lane <tgl@sss.pgh.pa.us>
  parent: silviapg@tiscali.it <silviapg@tiscali.it>
  1 sibling, 0 replies; 6+ messages in thread

From: Tom Lane @ 2004-11-17 23:38 UTC (permalink / raw)
  To: silviapg@tiscali.it <silviapg@tiscali.it>; +Cc: pgsql-performance; josh@agliodbs.com

"silviapg@tiscali.it" <silviapg@tiscali.it> writes:
> in March there was an interesting discussion on the list with the
> subject "postgres eating CPU on HP9000".
>    http://archives.postgresql.org/pgsql-performance/2004-03/msg00380.php

Reviewing that, the problem is most likely that (a) they didn't have
max_fsm_pages set high enough to cover the database, and (b) they were
running 7.3.* which is prone to index bloat.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: postgres eating CPU
@ 2004-11-18 03:30  Joshua D. Drake <jd@commandprompt.com>
  parent: Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 6+ messages in thread

From: Joshua D. Drake @ 2004-11-18 03:30 UTC (permalink / raw)
  To: josh@agliodbs.com; +Cc: pgsql-performance@postgresql.org, "silviapg@tiscali.it" <silviapg@tiscali.it>

Josh Berkus wrote:

>>in March there was an interesting discussion on the list with the
>>subject "postgres eating CPU on HP9000".
>>

http://archives.postgresql.org/pgsql-performance/2004-03/msg00380.php

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 283B) download begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
^ permalink raw reply [nested|flat] 6+ messages in thread


end of thread, other threads:[~2004-11-18 03:30 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-17 22:13 postgres eating CPU silviapg@tiscali.it <silviapg@tiscali.it>
2004-11-17 22:27 ` Josh Berkus <josh@agliodbs.com>
2004-11-17 22:51   ` silviapg@tiscali.it <silviapg@tiscali.it>
2004-11-17 23:23     ` Josh Berkus <josh@agliodbs.com>
2004-11-17 23:38     ` Tom Lane <tgl@sss.pgh.pa.us>
2004-11-18 03:30   ` Joshua D. Drake <jd@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox