Board is slow

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Post Reply
jmpoure
Registered User
Posts: 81
Joined: Sun Mar 11, 2007 9:42 am

Board is slow

Post by jmpoure »

Hello,

I am opening this post to discuss pconnect strategies in PostgreSQL.
Currently, 250 users are connected on my board.

CPU usage is 5%, SWAP is not used and ... 2 postgres processes are currently querying the database (idle) :
postgres 13610 1.5 1.0 408364 21532 ? Ss 13:27 0:00 postgres: phpbb phpbb3 127.0.0.1(49704) idle
postgres 13615 0.0 0.8 408052 17008 ? Ss 13:27 0:00 postgres: phpbb phpbb3 127.0.0.1(49709) idle
root 13617 0.0 0.0 89988 832 pts/0 S+ 13:27 0:00 grep postgre
postgres 25712 0.0 0.5 405148 10512 ? S Jan07 0:31 /usr/lib/postgresql/8.2/bin/postgres -D /home/jmpoure/postgresql/8.2/main -c config_file=/etc/postgresql/8.2/main/postgresql.conf
postgres 25713 0.0 0.0 132992 1388 ? Ss Jan07 0:18 postgres: logger process
postgres 25718 0.0 11.6 405396 238180 ? Ss Jan07 0:01 postgres: writer process
postgres 25719 0.0 0.0 133144 1328 ? Ss Jan07 0:16 postgres: stats collector process
root@www:/etc/apache2# ps aux | grep apache
root 5119 0.0 0.3 185188 6876 ? Ss 12:55 0:00 /usr/sbin/apache2 -k start
www-data 5148 0.1 0.8 194384 16452 ? S 12:55 0:03 /usr/sbin/apache2 -k start
www-data 5164 0.1 0.8 195228 17124 ? S 12:55 0:02 /usr/sbin/apache2 -k start
www-data 5166 0.0 0.7 193632 15340 ? S 12:55 0:01 /usr/sbin/apache2 -k start
www-data 5168 0.0 0.7 193608 15224 ? S 12:55 0:01 /usr/sbin/apache2 -k start
www-data 5170 0.1 0.7 194220 16220 ? S 12:55 0:02 /usr/sbin/apache2 -k start
www-data 5175 0.1 0.6 191136 12948 ? S 12:55 0:02 /usr/sbin/apache2 -k start
www-data 5192 0.1 0.6 190816 12616 ? S 12:56 0:02 /usr/sbin/apache2 -k start
www-data 5254 0.1 0.7 194388 15976 ? S 12:56 0:02 /usr/sbin/apache2 -k start
www-data 5264 0.1 1.1 204448 23872 ? S 12:56 0:02 /usr/sbin/apache2 -k start
www-data 5289 0.1 0.7 194724 16120 ? S 12:56 0:02 /usr/sbin/apache2 -k start
www-data 5348 0.1 1.1 204392 24252 ? S 12:56 0:03 /usr/sbin/apache2 -k start
www-data 5671 0.2 0.6 191992 13964 ? S 12:57 0:04 /usr/sbin/apache2 -k start
www-data 5905 0.1 0.7 193072 15024 ? S 12:58 0:02 /usr/sbin/apache2 -k start
www-data 6037 0.1 0.7 193608 15256 ? S 12:59 0:03 /usr/sbin/apache2 -k start
www-data 6250 0.1 0.5 188448 10356 ? S 13:00 0:02 /usr/sbin/apache2 -k start
www-data 6263 0.1 0.6 191136 13060 ? S 13:00 0:02 /usr/sbin/apache2 -k start
www-data 6265 0.1 0.7 194196 15648 ? S 13:00 0:02 /usr/sbin/apache2 -k start
www-data 6358 0.1 0.7 193652 15300 ? S 13:00 0:02 /usr/sbin/apache2 -k start
www-data 6470 0.1 0.8 195008 16576 ? S 13:01 0:01 /usr/sbin/apache2 -k start
www-data 6592 0.1 0.7 194412 15888 ? S 13:01 0:02 /usr/sbin/apache2 -k start
www-data 6640 0.1 0.6 191144 13108 ? S 13:01 0:01 /usr/sbin/apache2 -k start
www-data 6643 0.1 0.7 192588 14476 ? S 13:01 0:01 /usr/sbin/apache2 -k start
www-data 6788 0.1 0.7 193632 15284 ? S 13:02 0:01 /usr/sbin/apache2 -k start
www-data 7212 0.1 0.5 188980 10840 ? S 13:04 0:01 /usr/sbin/apache2 -k start
www-data 7221 0.1 0.7 193476 15164 ? S 13:04 0:01 /usr/sbin/apache2 -k start
www-data 7243 0.1 0.6 191172 13060 ? S 13:04 0:02 /usr/sbin/apache2 -k start
www-data 7315 0.1 0.7 194304 15928 ? S 13:04 0:02 /usr/sbin/apache2 -k start
www-data 7521 0.1 0.7 193380 15036 ? S 13:05 0:01 /usr/sbin/apache2 -k start
www-data 7561 0.1 1.0 198556 20720 ? S 13:05 0:01 /usr/sbin/apache2 -k start
www-data 7566 0.1 0.7 193604 15284 ? S 13:05 0:02 /usr/sbin/apache2 -k start
www-data 7572 0.1 0.7 194016 15716 ? S 13:05 0:01 /usr/sbin/apache2 -k start
www-data 7573 0.1 0.6 192380 14244 ? S 13:05 0:02 /usr/sbin/apache2 -k start
www-data 7577 0.1 0.7 194408 15884 ? S 13:05 0:02 /usr/sbin/apache2 -k start
www-data 7581 0.0 0.7 194372 15700 ? S 13:05 0:01 /usr/sbin/apache2 -k start
www-data 7585 0.1 0.6 191280 13196 ? S 13:05 0:01 /usr/sbin/apache2 -k start
www-data 7588 0.1 0.6 190688 12684 ? S 13:05 0:01 /usr/sbin/apache2 -k start
www-data 8170 0.0 0.6 191824 13532 ? S 13:08 0:00 /usr/sbin/apache2 -k start
www-data 8690 0.1 0.8 194916 16628 ? S 13:10 0:01 /usr/sbin/apache2 -k start
www-data 8742 0.1 0.7 194136 15836 ? S 13:10 0:01 /usr/sbin/apache2 -k start
www-data 8743 0.2 0.7 194028 15680 ? S 13:10 0:02 /usr/sbin/apache2 -k start
www-data 8747 0.1 0.8 196064 18060 ? S 13:10 0:01 /usr/sbin/apache2 -k start
www-data 8803 0.1 0.6 191140 13048 ? S 13:10 0:01 /usr/sbin/apache2 -k start
www-data 8804 0.0 0.5 188724 10760 ? S 13:10 0:01 /usr/sbin/apache2 -k start
www-data 8813 0.2 0.7 194360 15856 ? S 13:10 0:02 /usr/sbin/apache2 -k start
www-data 8903 0.1 0.7 194076 15624 ? S 13:10 0:01 /usr/sbin/apache2 -k start
www-data 8906 0.1 0.7 194408 15684 ? S 13:10 0:01 /usr/sbin/apache2 -k start
www-data 9120 0.1 0.7 194264 15688 ? S 13:11 0:01 /usr/sbin/apache2 -k start
www-data 9121 0.1 0.7 194284 15732 ? S 13:11 0:01 /usr/sbin/apache2 -k start
www-data 9122 0.1 0.7 193672 15400 ? S 13:11 0:01 /usr/sbin/apache2 -k start
www-data 9285 0.0 0.5 188992 10884 ? S 13:11 0:00 /usr/sbin/apache2 -k start
www-data 9297 0.1 0.6 191580 13420 ? S 13:12 0:01 /usr/sbin/apache2 -k start
www-data 9301 0.1 0.7 193428 15264 ? S 13:12 0:01 /usr/sbin/apache2 -k start
www-data 9327 0.1 0.5 189236 11092 ? S 13:12 0:01 /usr/sbin/apache2 -k start
www-data 9336 0.1 0.7 193852 15272 ? S 13:12 0:01 /usr/sbin/apache2 -k start
www-data 9355 0.1 0.7 194528 16256 ? S 13:12 0:01 /usr/sbin/apache2 -k start
www-data 9589 0.1 0.6 191100 12944 ? S 13:13 0:01 /usr/sbin/apache2 -k start
www-data 9598 0.1 0.7 194148 16180 ? S 13:13 0:00 /usr/sbin/apache2 -k start
www-data 9735 0.0 0.7 194136 15704 ? S 13:13 0:00 /usr/sbin/apache2 -k start
www-data 9760 0.1 1.1 202332 22524 ? S 13:13 0:01 /usr/sbin/apache2 -k start
www-data 9761 0.1 0.7 194400 15744 ? S 13:13 0:00 /usr/sbin/apache2 -k start
www-data 9771 0.0 0.7 193356 14744 ? S 13:13 0:00 /usr/sbin/apache2 -k start
www-data 9833 0.1 0.5 188976 10888 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9836 0.0 0.7 192876 14740 ? S 13:14 0:00 /usr/sbin/apache2 -k start
www-data 9885 0.1 1.0 202336 22032 ? S 13:14 0:00 /usr/sbin/apache2 -k start
www-data 9893 0.1 0.5 189596 11436 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9895 0.1 0.6 192392 14240 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9896 0.1 0.7 194152 15904 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9920 0.1 0.7 192584 14440 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9932 0.1 0.7 194156 15892 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9938 0.1 0.7 193452 15132 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9939 0.1 0.6 191308 13200 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9940 0.0 0.5 188728 10576 ? S 13:14 0:00 /usr/sbin/apache2 -k start
www-data 9988 0.0 0.7 192596 14504 ? S 13:14 0:00 /usr/sbin/apache2 -k start
www-data 9989 0.1 0.6 191312 13204 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9993 0.1 0.8 194920 16484 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 9994 0.1 0.5 188984 10852 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 10002 0.0 0.7 193608 15448 ? S 13:14 0:00 /usr/sbin/apache2 -k start
www-data 10007 0.1 0.6 192308 14228 ? S 13:14 0:00 /usr/sbin/apache2 -k start
www-data 10015 0.1 0.7 194148 15844 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 10062 0.1 0.5 188988 10932 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 10063 0.1 0.8 196188 18268 ? S 13:14 0:01 /usr/sbin/apache2 -k start
www-data 10534 0.0 0.7 193904 15264 ? S 13:16 0:00 /usr/sbin/apache2 -k start
www-data 10697 0.1 0.6 190800 12648 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10698 0.1 0.5 188744 10664 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10719 0.1 0.5 188976 10936 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10720 0.2 0.7 193428 15140 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10722 0.1 0.6 192380 14292 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10736 0.1 0.4 187936 9792 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10738 0.1 0.7 193872 15460 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10752 0.1 0.6 190588 12440 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10758 0.1 0.6 191088 12932 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10760 0.2 0.6 192364 14280 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10796 0.0 0.7 193588 14968 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10798 0.1 0.7 193164 14816 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10799 0.1 0.7 194408 15688 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10822 0.1 0.7 194392 15724 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10830 0.1 0.7 194416 15756 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10831 0.1 0.6 191120 12972 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10838 0.1 0.7 193380 14916 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10839 0.2 0.7 194260 15576 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10840 0.1 0.7 192612 14528 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10841 0.1 0.6 191856 13596 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10847 0.1 0.7 193904 15588 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10848 0.1 0.5 188764 10612 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10849 0.2 0.7 194140 15832 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10850 0.1 0.7 194160 15720 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10851 0.1 0.6 191092 12932 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10852 0.2 0.7 194136 15852 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10853 0.1 0.7 193900 15924 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10854 0.1 0.7 194440 16144 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10867 0.1 0.6 191308 13152 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10875 0.1 0.7 194136 15472 ? S 13:17 0:01 /usr/sbin/apache2 -k start
www-data 10877 0.1 0.5 190264 12112 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 10885 0.1 0.6 191120 12952 ? S 13:17 0:00 /usr/sbin/apache2 -k start
www-data 12415 0.1 0.6 192324 14160 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12476 0.0 0.4 187908 9708 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12484 0.1 0.6 191060 12916 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12496 0.3 0.9 197188 18880 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12497 0.1 0.5 188944 10780 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12498 0.0 0.5 188420 10256 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12499 0.1 0.6 191068 12916 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12503 0.1 0.6 190432 12356 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12504 0.0 0.7 193356 14928 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12505 0.1 0.6 192308 14160 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12529 0.3 0.7 194376 15700 ? S 13:23 0:00 /usr/sbin/apache2 -k start
www-data 12722 0.1 0.6 192336 14168 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12748 0.2 0.7 193384 15088 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12751 0.1 0.5 188688 10528 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12752 0.0 0.3 186328 7644 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12832 0.0 0.5 189108 11004 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12839 0.0 0.6 191060 12816 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12840 0.2 0.5 190272 12180 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12846 0.2 0.5 188976 10808 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12847 0.0 0.3 186400 7668 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12848 0.1 0.4 187940 9760 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12849 0.1 0.7 194220 15524 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12864 0.0 0.5 190216 11900 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12872 0.1 0.6 191056 12956 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12875 0.4 0.5 188976 10904 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12876 0.2 0.6 191080 12932 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12877 0.1 0.5 189996 11844 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12878 0.3 0.5 188964 10852 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 12884 0.1 0.7 193368 14788 ? S 13:24 0:00 /usr/sbin/apache2 -k start
www-data 13310 0.1 0.5 188724 10524 ? S 13:26 0:00 /usr/sbin/apache2 -k start
www-data 13315 0.0 0.5 189696 11380 ? S 13:26 0:00 /usr/sbin/apache2 -k start
www-data 13316 0.1 0.6 191072 12908 ? S 13:26 0:00 /usr/sbin/apache2 -k start
www-data 13320 0.1 0.6 191016 12860 ? S 13:26 0:00 /usr/sbin/apache2 -k start
www-data 13321 0.3 0.6 192544 14108 ? S 13:26 0:00 /usr/sbin/apache2 -k start
www-data 13322 0.1 0.5 189740 11484 ? S 13:26 0:00 /usr/sbin/apache2 -k start
www-data 13899 0.4 0.5 188680 10428 ? S 13:28 0:00 /usr/sbin/apache2 -k start
root 14013 0.0 0.0 89992 840 pts/0 S+ 13:28 0:00 grep apache
Any idea why my board is slow?

jmpoure
Registered User
Posts: 81
Joined: Sun Mar 11, 2007 9:42 am

Re: Board is slow

Post by jmpoure »

No idea, normal operation again.

Post Reply