| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Christopher Petrilli <petrilli(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, jd(at)commandprompt(dot)com, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Sustained inserts per sec ... ? |
| Date: | 2005-04-06 08:14:19 |
| Message-ID: | 1112775259.16721.1005.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 2005-04-05 at 16:05 -0400, Christopher Petrilli wrote:
> On Apr 5, 2005 3:48 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steinar H. Gunderson | 2005-04-06 11:28:17 | Re: Follow-Up: How to improve db performance with $7K? |
| Previous Message | Simon Riggs | 2005-04-06 08:09:58 | Re: Sustained inserts per sec ... ? |