On Tue, 2005-04-05 at 16:05 -0400, Christopher Petrilli wrote:
> On Apr 5, 2005 3:48 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
> > > The indicated fix of course is to increase shared_buffers.
> > 
> > Splitting your tables at 4M, not 10M would work even better.
> 
> Unfortunately, given we are talking about billions of rows
> potentially, I'm concerned about that many tables when it comes to
> query time. I assume this will kick in the genetic optimizer?

No, it won't start using the genetic optimizer.

You could just buy more RAM and keep table size the same.

Best Regards, Simon Riggs


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to