On Mar 21, 2007, at 5:22 PM, Heikki Linnakangas wrote:

Grzegorz Jaskiewicz wrote:
On Mar 19, 2007, at 11:16 AM, Heikki Linnakangas wrote:
Grzegorz Jaskiewicz wrote:
On Mar 16, 2007, at 10:12 PM, Heikki Linnakangas wrote:
You'll obviously need to run it with the patch applied. I'd suggest to enable stats_block_level to see the effect on buffer cache hit/miss ratio.
groupeditems-42-pghead.patch.gz is enough, or it needs maintain_cluster_order_v5.patch ??

No, it won't make a difference unless you're inserting to the table, and the inserts are not in cluster order.
well, that's okay than. I see really good improvement in terms of speed and db size (which reflects obviously in i/o performance). Let me know if further testing can be done. I would happily see it in mainline.

If you have a real-world database you could try it with, that would be nice. The test I sent you is pretty much a best-case scenario, it'd be interesting to get anecdotal evidence of improvements in real applications.

Sure, I'll check it with my network statistics thingie. 30GB db atm, with milions of rows. (traffic analysies for wide network , ethernet level, from/to/protocol/size kinda of thing). Loads of updates on 2 tables (that's where I also see HOT would benefit me).

Grzegorz Jaskiewicz

C/C++ freelance for hire

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to