Re: Slow Postgresql server - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Slow Postgresql server
Date
Msg-id 1176396964.13754.16.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Slow Postgresql server  (Guido Neitzer <lists@event-s.net>)
Responses Re: Slow Postgresql server
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Steve
Date:
Subject: Re: Question about memory allocations
Next
From: Jeff Frost
Date:
Subject: Re: Slow Postgresql server