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@bigpanda.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
>