Skip site navigation (1) Skip section navigation (2)

Re: Slow Postgresql server

From: Guido Neitzer <lists(at)event-s(dot)net>
To: Ron <rjpeace(at)earthlink(dot)net>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow Postgresql server
Date: 2007-04-12 15:19:57
Message-ID: 0914C05F-BA1B-4A6C-A1B1-52256BC851A4@event-s.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-performance
On 12.04.2007, at 08:59, Ron wrote:

> 1= Unless I missed something, the OP described pg being used as a  
> backend DB for a webserver.

Yep.

> I know the typical IO demands of that scenario better than I  
> sometimes want to.
> :-(

Yep. Same here. ;-)

> 2= 1GB of RAM + effectively 1 160GB HD = p*ss poor DB IO support.

Absolutely right. Depending a little bit on the DB and WebSite layout  
and on the actual requirements, but yes - it's not really a kick-ass  
machine ...

> Completely agree that at some point the queries need to be examined  
> (ditto the table schema, etc), but this system is starting off in a  
> Bad Place for its stated purpose IME.
> Some minimum stuff is obvious even w/o spending time looking at  
> anything beyond the HW config.

Depends. As I said - if the whole DB fits into the remaining space,  
and a lot of website backend DBs do, it might just work out. But this  
seems not to be the case - either the site is chewing on seq scans  
all the time which will cause I/O or it is bound by the lack of  
memory and swaps the whole time ... He has to find out.

cug

In response to

Responses

pgsql-performance by date

Next:From: Jeff FrostDate: 2007-04-12 15:35:24
Subject: Re: Slow Postgresql server
Previous:From: RonDate: 2007-04-12 14:59:10
Subject: Re: Slow Postgresql server

pgsql-hackers by date

Next:From: Jeff FrostDate: 2007-04-12 15:35:24
Subject: Re: Slow Postgresql server
Previous:From: Alvaro HerreraDate: 2007-04-12 15:14:10
Subject: Autovacuum PGPROCs in ProcGlobal? (was Re: autovacuum multiworkers)

pgsql-patches by date

Next:From: Jeff FrostDate: 2007-04-12 15:35:24
Subject: Re: Slow Postgresql server
Previous:From: Alvaro HerreraDate: 2007-04-12 15:14:10
Subject: Autovacuum PGPROCs in ProcGlobal? (was Re: autovacuum multiworkers)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group