| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Jason Lustig <lustig(at)brandeis(dot)edu> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Slow Postgresql server |
| Date: | 2007-04-12 04:34:14 |
| Message-ID: | 461DB6C6.5010207@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
Jason Lustig skrev:
> and work_mem to 8096. What would cause the computer to only use such a
> small percentage of the CPU, with more than half of it waiting on I/O
> requests?
Do your webpages write things to the database on each connect?
Maybe it do a bunch of writes each individually commited? For every
commit pg will wait for the data to be written down to the disk platter
before it move on. So if you do several writes you want to do them in
one transaction so you only need one commit.
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2007-04-12 04:55:33 | Re: Makefile patch to make gcov work on Postgres contrib modules |
| Previous Message | Alvaro Herrera | 2007-04-12 02:35:23 | Re: autovacuum multiworkers, patch 5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2007-04-12 05:33:12 | Re: Slow Postgresql server |
| Previous Message | Alvaro Herrera | 2007-04-12 02:35:23 | Re: autovacuum multiworkers, patch 5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2007-04-12 05:33:12 | Re: Slow Postgresql server |
| Previous Message | Tom Lane | 2007-04-12 04:31:28 | Re: Question about memory allocations |