xhoster_at_gmail.com wrote:
>
> And while you are surfing the web, the database is still not running
> smoothly. Because the answer was not to increase maxtrans, it was
increase
> initrans and then rebuild the tables. Ah, but how much should
initrans be
> increased by? Well, I guess if we are going to demand infinite
> scalability, we better make it a few hundred, hadn't we?
<hush voice>
while you're busy doing all that, swing by the stats in
user_tables. Check the average row length, use that to
figure out rows/block average. No need to set initrans/maxtrans
to anything greater than that. And that's assuming someone
will ever update all rows concurrently in a single block.
Or better yet, use ASSM and get rid of all that s***.
</hush voice>
Received on Fri Feb 11 2005 - 00:35:49 CST
