---------- Forwarded message ----------
From: rakesh kumar <trakeshkumar(at)gmail(dot)com>
Date: Nov 19, 2006 9:31 AM
Subject: Re: [PERFORM] start up cost estimate
To: Joshua Marsh <icub3d(at)gmail(dot)com>
for suppose if I had a
query , something like :
where o_totalprice < 156163 and exists
( select *
where l_orderkey = o_orderkey
and l_extendedprice < 38570
what is the amount of cost of EXISTS SUBQUERY involved in estimate of
where l_orderkey is part of index of lineitem , and o_orderkey is primary
key of orders table.
On 11/18/06, Joshua Marsh <icub3d(at)gmail(dot)com> wrote:
> On 11/18/06, rakesh kumar < trakeshkumar(at)gmail(dot)com> wrote:
> > Hi ,
> > I wanted to know , how the start up cost is computed in
> > postgresql . can u give me an example to illustrate the estimation of start
> > up cost .
> > thanku raa
> > .
> It would be very helpful to have a lot more information. Some questions
> that come to mind:
> Approximately how many records will you be storing?
> How big do you think your biggest tables will be?
> How frequently will your biggest tables be accessed (x/day, x/second,
> Will those accesses be read only, or read/write?
> How important is availability vs. cost?
> Who is your favorite Irish folk singer?
In response to
pgsql-performance by date
|Next:||From: Craig A. James||Date: 2006-11-19 06:43:14|
|Subject: Re: Postgres server crash|
|Previous:||From: Brian Wipf||Date: 2006-11-19 03:13:26|
|Subject: Re: shared_buffers > 284263 on OS X |