Re: start up cost estimate - Mailing list pgsql-performance

From Joshua Marsh
Subject Re: start up cost estimate
Date
Msg-id 38242de90611180627s76262418j1fb73bac61d30e3f@mail.gmail.com
Whole thread Raw
In response to start up cost estimate  ("rakesh kumar" <trakeshkumar@gmail.com>)
List pgsql-performance

On 11/18/06, rakesh kumar <trakeshkumar@gmail.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, x/week)?
Will those accesses be read only, or read/write?
How important is availability vs. cost?
Who is your favorite Irish folk singer?


pgsql-performance by date:

Previous
From: Marc Cousin
Date:
Subject: Re: Optimicing Postgres for SunSolaris10 on V240
Next
From: Dave Cramer
Date:
Subject: Re: shared_buffers > 284263 on OS X