Postgres Pro
Downloads
Home   >   mailing lists

What kind of performace can I expect and how to measure? - Mailing list pgsql-performance

From Joost Kraaijeveld
Subject What kind of performace can I expect and how to measure?
Date
Msg-id A3D1526C98B7C1409A687E0943EAC41001EA5A@obelix.askesis.nl
Whole thread Raw
Responses Re: What kind of performace can I expect and how to
List pgsql-performance
Tree view 
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
hasa Pentium III-733 Mhz with 512 MB ram. It is connected to my workststation (dual XEON 1700 with 1 Gb RAM) with a 100
Mbswitched network. 

I have a table with 31 columns, all fixed size datatypes. It contains 88393 rows. Doing a "select * from table" with
PGAdminIII 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.Kraaijeveld@Askesis.nl
web: www.askesis.nl

pgsql-performance by date:

Previous
From: "Leeuw van der, Tim"
Date:
Subject: Re: No index usage with "left join"
Next
From: "Merlin Moncure"
Date:
Subject: Re: What kind of performace can I expect and how to measure?