Re: [PERFORM] SQL Performance Guidelines

2005-01-27 Thread Dustin Sallings
p settings ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- SPY My girlfriend asked me which one I like better. pub 1024/3CAE01D5 1994/11/03 Dustin Sallings |Key fingerprint = 87 02 57 08 02 D0

Re: [PERFORM] psql large RSS (1.6GB)

2004-10-30 Thread Dustin Sallings
nderlying protocol on its own. -- SPY My girlfriend asked me which one I like better. pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]> |Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE L___ I

Re: [PERFORM] can't handle large number of INSERT/UPDATEs

2004-10-25 Thread Dustin Sallings
ouble scaling a database application, much of the performance win can be in trying to be a little smarter about how and when the database is accessed. -- SPY My girlfriend asked me which one I like better. pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]&g

[PERFORM] inconsistent/weird index usage

2004-10-01 Thread Dustin Sallings
to be making pretty good index selection currently...but I always want more! :) Does anyone have any suggestions as to how to get this to do what I want? Of course, ideally, it would ignore five of the tables altogether. :) -- SPY My girlfriend aske