| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Guido Neitzer <lists(at)event-s(dot)net> |
| Cc: | Ron <rjpeace(at)earthlink(dot)net>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Slow Postgresql server |
| Date: | 2007-04-12 16:56:04 |
| Message-ID: | 1176396964.13754.16.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-04-12 16:57:32 | Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?] |
| Previous Message | Bruce Momjian | 2007-04-12 16:24:38 | Re: TOASTing smaller things |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2007-04-12 17:03:15 | Re: Slow Postgresql server |
| Previous Message | Tom Lane | 2007-04-12 15:49:57 | Re: Autovacuum PGPROCs in ProcGlobal? (was Re: autovacuum multiworkers) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2007-04-12 17:03:15 | Re: Slow Postgresql server |
| Previous Message | Steve | 2007-04-12 16:46:00 | Re: Question about memory allocations |