Re: [PERFORM] Millions of tables

2016-09-27 Thread Terry Schmitt
On Sun, Sep 25, 2016 at 7:50 PM, Greg Spiegelberg wrote: > Hey all, > > Obviously everyone who's been in PostgreSQL or almost any RDBMS for a time > has said not to have millions of tables. I too have long believed it until > recently. > > AWS d2.8xlarge instance with 9.5 is my test rig using XF

Re: [PERFORM] Hardware advice for scalable warehouse db

2011-07-27 Thread Terry Schmitt
more costly then local drives. It really depends on what your needs are. The biggest benefit for me in using SAN is using the special features that it offers. We use snapshots and flex clones, which is a great way to backup and clone large databases. Cheers, Terry On Thu, Jul 14, 2011 at 11:34 PM

Re: [PERFORM] Performance degradation of inserts when database size grows

2011-05-23 Thread Terry Schmitt
re spending too much time on the database. Perhaps there are memory issues or excessive garbage collection on the app server? Terry On Tue, May 17, 2011 at 5:45 AM, Andrey Vorobiev < andrey.o.vorob...@gmail.com> wrote: > Hi, guys. > > > I have following environment configurat

Re: [PERFORM] can we optimize STACK_DEPTH_SLOP

2010-02-20 Thread terry
Thanks for your help! But why we set STACK_DEPTH_SLOP to 512K, not 128K? What it according to?

[PERFORM] can we optimize STACK_DEPTH_SLOP

2010-02-20 Thread terry
hi, STACK_DEPTH_SLOP stands for Required daylight between max_stack_depth and the kernel limit, in bytes. Why we need so much memory? MySql need only no more than 100K. Where these memory allocated for? Can we do something to decrease this variable? Thanks.

[PERFORM] can we optimize STACK_DEPTH_SLOP

2010-02-20 Thread terry
hi, STACK_DEPTH_SLOP stands for Required daylight between max_stack_depth and the kernel limit, in bytes. Why we need so much memory? MySql need only no more than 100K. Where these memory allocated for? Can we do something to decrease this variable? Thanks.