Thread: Performance

Performance

From
"Martins Zarins"
Date:
Hello all!

I need to setup high performance DB server. Some time ago I red
there about processor cache influence on query execution
performance.
A question:
What system would perform better?
lh6000 with two xeon 7000Mhz 2MB cache
or
with four xeon 7000Mhz 1MB cache

Mark

Re: Performance

From
Jeremy Buchmann
Date:
On Friday, January 18, 2002, at 02:00 AM, Martins Zarins wrote:

> Hello all!
>
> I need to setup high performance DB server. Some time ago I red
> there about processor cache influence on query execution
> performance.
> A question:
> What system would perform better?
> lh6000 with two xeon 7000Mhz 2MB cache
> or
> with four xeon 7000Mhz 1MB cache

It's more than just processor cache, it's your whole I/O subsystem.
How fast are your drives?  How fast is the drive controller?  How much
cache is on each drive?  How much cache is on the drive controller?
Are you going to use a RAID?  If so, what type?  Do you have enough
memory for the size of the database and type of queries you're going to
run?

As far as processor cache goes, your goal is to avoid cache misses...so
it
depends on how many connections you're expecting, what those connections
will be doing, etc.  The best advice is to run your own benchmarks and
find
out for yourself.

--Jeremy


Re: Performance

From
"Martins Zarins"
Date:
On 18 Jan 2002, at 9:22, Jeremy Buchmann wrote:
>
> It's more than just processor cache, it's your whole I/O subsystem.
> How fast are your drives?  How fast is the drive controller?  How much
> cache is on each drive?  How much cache is on the drive controller?
> Are you going to use a RAID?  If so, what type?  Do you have enough
> memory for the size of the database and type of queries you're going
> to run?
Is there any good doc about this on net?
(About disc cache, raid cache processor cache and queries - how
they influence each other?)

Mark



Re: Performance

From
Bruce Momjian
Date:
See techdocs performance article:

    http://techdocs.postgresql.org

Martins Zarins wrote:
> On 18 Jan 2002, at 9:22, Jeremy Buchmann wrote:
> >
> > It's more than just processor cache, it's your whole I/O subsystem.
> > How fast are your drives?  How fast is the drive controller?  How much
> > cache is on each drive?  How much cache is on the drive controller?
> > Are you going to use a RAID?  If so, what type?  Do you have enough
> > memory for the size of the database and type of queries you're going
> > to run?
> Is there any good doc about this on net?
> (About disc cache, raid cache processor cache and queries - how
> they influence each other?)
>
> Mark
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Any body know --- 'sql query where condition execution plan'

From
raja kumar thatte
Date:

 Hai every body,

I want to know how the--where condition--is executed in a sql query.

e.g., select aa,bb,cc from ttt where aa=100 and bb = 200 and cc =300.

my doubt is , will psql leave the record as on when it fails to satisfy a record having aa !=100 

or will it chect for bb = 200 and cc = 300 also.

ie will it work like C-language if condition or not.

If i give paranthesis, will it change the execution plan accordingly.

Thanks in advance.

c u

raja



Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.

Re: Any body know --- 'sql query where condition execution plan'

From
Tom Lane
Date:
raja kumar thatte <trajakumar@yahoo.com> writes:
> I want to know how the--where condition--is executed in a sql query.
> e.g., select aa,bb,cc from ttt where aa=100 and bb = 200 and cc =300.
> my doubt is , will psql leave the record as on when it fails to satisfy a record having aa !=100
> or will it chect for bb = 200 and cc = 300 also.
> ie will it work like C-language if condition or not.
> If i give paranthesis, will it change the execution plan accordingly.

The planner will make its own decisions about which query plan to
follow; it's quite impervious to parentheses, clause order, or any
other semantically-insignificant details in the WHERE clause.

You may care to read the chapter on performance tips in the User's
Guide.

            regards, tom lane