benefits are.
>
> I'll let you know if we get anywhere.
>
> Cheers,
> Carson
>
> On Jan 13, 2:05 pm, John McCaffrey wrote:
>> I've been working on postgres tuning for an app recently, and I was
>> wondering if you were able to change these configs lo
t anywhere.
Cheers,
Carson
On Jan 13, 2:05 pm, John McCaffrey wrote:
> I've been working on postgres tuning for an app recently, and I was
> wondering if you were able to change these configs locally and see a
> meaningful improvement.
>
> I've seen improvements of larg
I've been working on postgres tuning for an app recently, and I was
wondering if you were able to change these configs locally and see a
meaningful improvement.
I've seen improvements of large queries with sorts, by increasing work_mem
(which can be done within your session), but othe
Yeah.
Sadly, we are all very much stuck in the YesSQL mindset (our data is
relational) and would prefer to stick with that horse as long as is
possible. Our performance is good right now and appears to scale to
the loads we'd like to see, but since perf is typically a non-linear
sort of thing reg
Your use case (high volume, low value writes) sounds like it would be a
perfect match for one of heroku's nosql addons... mongo or couch in
particular.
--
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to her...@goog
Hey Guys,
Any further thoughts on this?
Thanks,
Carson
On Jan 7, 1:35 pm, Carson Gross wrote:
> Sure. We've got a big, ugly database that we are constantly slamming
> data into (nearly constant appends on one table, with occasionally
> purges.) We'd like to increase the checkpoint segments t
Sure. We've got a big, ugly database that we are constantly slamming
data into (nearly constant appends on one table, with occasionally
purges.) We'd like to increase the checkpoint segments to see if that
boosts write performance.
On the cache side, according to this website:
http://wiki.pos
Hi Carson,
We don't support tuning the dedicated database.
I'd love to hear more about your requirements and needs around this. It's
possible that this could be supported in the future.
Matt
On Fri, Jan 7, 2011 at 10:50 AM, Carson Gross wrote:
> Is it possible to tune a dedicated postgres dat
Is it possible to tune a dedicated postgres database? In particular,
we'd like to change the effective cache size and checkpoint segments
setting from the defaults (appear to be ~200MB and 40, respectively.)
Cheers,
Carson
--
You received this message because you are subscribed to the Google Gr
