Re: db server is too slow, real slow

We'll probably need some additional information:

What settings did you start the server with, what queries are you running
that are slow (with schema, index information), what does explain show for
the queries?

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Thu, 19 Oct 2000, pgsql-admin wrote:

> I'm using
> PostgreSQL 6.5.3 on i686-pc-linux-gnu.
> I have a backup of our database (sql dump and large object)
> backup.tar.bz2 with the size of 10121985.
> We have users accessing our database from http and
> odbc (ms excel).
>
> Can someone pls tell how to solve this problem?
>
> Thank you very much.
> Sherwin
>
> Here are the processes:
> 6:08pm up 12 days, 23:39, 2 users, load average: 12.99, 12.70, 11.29
> 74 processes: 57 sleeping, 17 running, 0 zombie, 0 stopped
> CPU states: 24.9% user, 74.2% system, 0.0% nice, 0.7% idle
> Mem: 387032K av, 184556K used, 202476K free, 48872K shrd, 49308K
> buff
> Swap: 265032K av, 5284K used, 259748K free 73596K
> cached
>
> PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
> 11345 postgres 9 0 2604 2544 1928 R 0 13.6 0.6 1:23
> postmaster
> 11220 postgres 9 0 2604 2544 1924 R 0 13.4 0.6 3:10
> postmaster
> 11213 postgres 7 0 2604 2544 1928 R 0 13.0 0.6 3:16
> postmaster
> 10860 postgres 6 0 5552 5492 2068 R 0 12.8 1.4 14:48
> postmaster
> 10862 postgres 8 0 2588 2528 1896 R 0 12.8 0.6 14:17
> postmaster
> 10996 postgres 8 0 4404 4344 2072 R 0 12.8 1.1 8:28
> postmaster
> 11168 postgres 6 0 3552 3492 2072 R 0 12.8 0.9 3:51
> postmaster
> 10966 postgres 5 0 4652 4592 2064 R 0 12.6 1.1 10:04
> postmaster
> 10957 postgres 7 0 4800 4740 2064 R 0 12.4 1.2 10:51
> postmaster
> 10861 postgres 5 0 5396 5336 2064 R 0 12.2 1.3 14:15
> postmaster
> 10867 postgres 9 0 5332 5272 2060 R 0 12.2 1.3 13:53
> postmaster
> 10892 postgres 5 0 5084 5024 2060 R 0 11.8 1.2 12:33
> postmaster
> 10995 postgres 5 0 4416 4356 2072 R 0 11.8 1.1 8:33
> postmaster
> 11163 postgres 5 0 2612 2552 1924 R 0 11.4 0.6 4:01
> postmaster
> 11170 postgres 5 0 2428 2368 1844 R 0 10.6 0.6 1:07
> postmaster
> 10888 postgres 5 0 2584 2524 1896 R 0 10.2 0.6 12:47
> postmaster
>