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

Re: Slow Postgresql server

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Jason Lustig <lustig(at)brandeis(dot)edu>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: Guido Neitzer <lists(at)event-s(dot)net>, Ron <rjpeace(at)earthlink(dot)net>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow Postgresql server
Date: 2007-04-12 17:03:15
Message-ID: Pine.LNX.4.64.0704121000570.32187@glacier.frostconsultingllc.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-performance
On Thu, 12 Apr 2007, Scott Marlowe wrote:

> On Thu, 2007-04-12 at 10:19, Guido Neitzer wrote:
>> On 12.04.2007, at 08:59, Ron wrote:
>
>>
>> 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.
>
> It could also be something as simple as a very bloated data store.
>
> I'd ask the user what vacuum verbose says at the end

You know, I should answer emails at night...we didn't ask when the last time 
the data was vacuumed or analyzed and I believe he indicated that the only 
non-default values were memory related, so no autovacuum running.

Jason,

Before you go any further, run 'vacuum analyze;' on your DB if you're not 
doing this with regularity and strongly consider enabling autovacuum.

-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

Responses

pgsql-performance by date

Next:From: Robert TreatDate: 2007-04-12 17:54:01
Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
Previous:From: Scott MarloweDate: 2007-04-12 16:56:04
Subject: Re: Slow Postgresql server

pgsql-hackers by date

Next:From: Kris KennawayDate: 2007-04-12 17:06:19
Subject: Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]
Previous:From: Bruce MomjianDate: 2007-04-12 16:57:32
Subject: Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]

pgsql-patches by date

Next:From: Trevor HardcastleDate: 2007-04-12 17:56:09
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Previous:From: Scott MarloweDate: 2007-04-12 16:56:04
Subject: Re: Slow Postgresql server

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