| From: | "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | What kind of performace can I expect and how to measure? |
| Date: | 2004-08-02 12:21:31 |
| Message-ID: | A3D1526C98B7C1409A687E0943EAC41001EA5A@obelix.askesis.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi all,
My system is a PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 20020903 (Red Hat Linux 8.0 3.2-7). It has a Pentium III-733 Mhz with 512 MB ram. It is connected to my workststation (dual XEON 1700 with 1 Gb RAM) with a 100 Mb switched network.
I have a table with 31 columns, all fixed size datatypes. It contains 88393 rows. Doing a "select * from table" with PGAdmin III in it's SQL window, it takes a total of 9206 ms query runtime an a 40638 ms data retrievel runtime.
Is this a reasonable time to get 88393 rows from the database?
If not, what can I do to find the bottleneck (and eventually make it faster)?
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2004-08-02 12:33:34 | Re: What kind of performace can I expect and how to measure? |
| Previous Message | Leeuw van der, Tim | 2004-08-02 12:16:41 | Re: No index usage with "left join" |