Re(2): db server is too slow, real slow

The postgres server was started with the command:
/usr/bin/postmaster -i -S -D/var/lib/pgsql

Here is just one query executed from Embperl pages with Perl DBI:
officedata=> explain SELECT * FROM office, office_application
officedata-> WHERE office.code = office_application.office_code
officedata-> AND office_application.active
officedata-> AND NOT office.deleted;
NOTICE: QUERY PLAN:

Hash Join (cost=5524.86 rows=644 width=262)
-> Seq Scan on office_application (cost=4261.49 rows=9767 width=245)
-> Hash (cost=908.88 rows=854 width=17)
-> Seq Scan on office (cost=908.88 rows=854 width=17)

note: office.code and office_application.office_code are serial data types.
office_application.active and office.deleted are boolean.
others are char, inet, oid (for lobj), and date data types.

Here is another query executed from ms excel (pgsql-odbc):
workdata=> explain select * from consol;
NOTICE: QUERY PLAN:

Seq Scan on consol (cost=1133.48 rows=8560 width=256)

note: consol table contains no index, no sequence, no primary key
(just char, date, money, and inet)

sszabo(at)megazone23(dot)bigpanda(dot)com writes:
>
>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
>>
>