Slow Postgresql server

Поиск
Список
Период
Сортировка
Искать
От
Jason Lustig
Тема
Slow Postgresql server
Дата
Msg-id
57271CC2-BCB1-4ACA-A177-4FF64F1BC33F@brandeis.edu
Список
Дерево обсуждения
Slow Postgresql server Jason Lustig <lustig@brandeis.edu>
Re: Slow Postgresql server Dennis Bjorklund <db@zigo.dhs.org>
Re: Slow Postgresql server Ron <rjpeace@earthlink.net>
Re: Slow Postgresql server Guido Neitzer <lists@event-s.net>
Re: Slow Postgresql server Ron <rjpeace@earthlink.net>
Re: Slow Postgresql server Guido Neitzer <lists@event-s.net>
Re: Slow Postgresql server Scott Marlowe <smarlowe@g2switchworks.com>
Re: Slow Postgresql server Jeff Frost <jeff@frostconsultingllc.com>
Re: Slow Postgresql server Carlos Moreno <moreno_pg@mochima.com>
Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Scott Marlowe <smarlowe@g2switchworks.com>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Scott Marlowe <smarlowe@g2switchworks.com>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Fwd: Strangely Variable Query Performance "Robins Tharakan" <robins@pobox.com>
Fwd: Strangely Variable Query Performance Robins <tharakan@gmail.com>
Re: Fwd: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
choose_bitmap_and again (was Re: Strangely Variable Query Performance) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance) Alvaro Herrera <alvherre@commandprompt.com>
Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance) Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Strangely Variable Query Performance Tom Lane <tgl@sss.pgh.pa.us>
Re: Strangely Variable Query Performance Steve <cheetah@tanabi.org>
Re: Slow Postgresql server Jeff Frost <jeff@frostconsultingllc.com>
Hello all,

My website has been having issues with our new Linux/PostgreSQL  
server being somewhat slow. I have done tests using Apache Benchmark  
and for pages that do not connect to Postgres, the speeds are much  
faster (334 requests/second v. 1-2 requests/second), so it seems that  
Postgres is what's causing the problem and not Apache. I did some  
reserach, and it seems that the bottleneck is in fact the hard  
drives! Here's an excerpt from vmstat:

procs -----------memory---------- ---swap-- -----io---- --system--  
-----cpu------
r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us  
sy id wa st
1  1    140  24780 166636 575144    0    0     0  3900 1462  3299  1   
4 49 48  0
0  1    140  24780 166636 575144    0    0     0  3828 1455  3391  0   
4 48 48  0
1  1    140  24780 166636 575144    0    0     0  2440  960  2033  0   
3 48 48  0
0  1    140  24780 166636 575144    0    0     0  2552 1001  2131  0   
2 50 49  0
0  1    140  24780 166636 575144    0    0     0  3188 1233  2755  0   
3 49 48  0
0  1    140  24780 166636 575144    0    0     0  2048  868  1812  0   
2 49 49  0
0  1    140  24780 166636 575144    0    0     0  2720 1094  2386  0   
3 49 49  0

As you can see, almost 50% of the CPU is waiting on I/O. This doesn't  
seem like it should be happening, however, since we are using a RAID  
1 setup (160+160). We have 1GB ram, and have upped shared_buffers to  
13000 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?

Thanks a lot
Jason

В списке pgsql-performance по дате отправления
От: Steve
Дата:
От: Tom Lane
Дата:
FAQ