pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
To: pgsql-performance@postgresql.org
Subject: Re: Same query, same performance
Date: Thu, 23 Jan 2003 18:31:03 -0200 (BRST)
Message-ID: <10520.200.225.202.15.1043353863.squirrel@webmail.ad2.com.br> (raw)
In-Reply-To: <web-2323224@davinci.ethosmedia.com>
References: <10635.200.225.202.15.1043288804.squirrel@webmail.ad2.com.br>
	<web-2323224@davinci.ethosmedia.com>

Josh,

> Alexandre,
>
>> I have a system with 7 Million of records in 600 tables.
>> My actual production machine is: P4 1.6G, 3 IDE 7200, 1GB PC133
>> My new machine production is: Dual Xeon 2.0G HT, 1GB DDR266 ECC
>> 3 SCSI with HW Raid 5
>
> Well, first of all, those two systems are almost equivalent as far as
> Postgres is concerned for simple queries.   The extra processor power
> will only help you with very complex queries.  3-disk RAID 5 is no
> faster ... and sometimes slower ... than IDE for database purposes.
>   The only real boost to the Xeon is the faster RAM ... which may not
> help you if your drive array is the bottleneck.

Today, I will add more one HD and I will make an RAID 10 ...
In next week i will report my tests to the list...

>
>>
>> The postgresql.conf is the SAME in both systems and I test
>> with no other connections, only my local test.
>>
>> shared_buffers = 80000
>> effective_cache_size = 60000
>> random_page_cost = 2.5
>> cpu_tuple_cost = 0.001
>> cpu_index_tuple_cost = 0.0001
>> cpu_operator_cost = 0.00025
>
> Not that it affects the query below, but what about SORT_MEM?

Sort_mem = 32000

> Actually, from your stats, Postgres is doing a pretty good job.   1.18
> seconds to return 15 rows from a 7 million row table searching on not
> Indexed columns?  I don't think you have anything to complain about.

The table have 300000 tuples, the entire database have 7 million.
Tomazs answer the question: a missing index on fn06t ...

But the query time difference of the systems continue.
I will change the discs and tell to list after...

Thank“s Josh,


Alexandre








view thread (5+ messages)

Message-ID: <10520.200.225.202.15.1043353863.squirrel@webmail.ad2.com.br>
Permalink:  ../10520.200.225.202.15.1043353863.squirrel@webmail.ad2.com.br/
Also on:    postgresql.org/message-id/10520.200.225.202.15.1043353863.squirrel@webmail.ad2.com.br

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: alepaes@aldeiadigital.com.br
  Subject: Re: Same query, same performance
  In-Reply-To: <10520.200.225.202.15.1043353863.squirrel@webmail.ad2.com.br>
  References: <10635.200.225.202.15.1043288804.squirrel@webmail.ad2.com.br> <web-2323224@davinci.ethosmedia.com> <10520.200.225.202.15.1043353863.squirrel@webmail.ad2.com.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox