Re: [HACKERS] [GSoC08]some detail plan of improving hash index

2008-05-20 Thread Gregory Williamson
Greg Smith wrote > On Fri, 16 May 2008, Josh Berkus wrote: > > > For a hard-core benchmark, I'd try EAStress (SpecJAppserver Lite) > > This reminds me...Jignesh had some interesting EAStress results at the > East conference I was curious to try and replicate more publicly one day. > Now that

Re: [HACKERS] [GSoC08]some detail plan of improving hash index

2008-05-19 Thread Greg Smith
On Fri, 16 May 2008, Josh Berkus wrote: For a hard-core benchmark, I'd try EAStress (SpecJAppserver Lite) This reminds me...Jignesh had some interesting EAStress results at the East conference I was curious to try and replicate more publicly one day. Now that there are some initial benchmark

Re: [HACKERS] [GSoC08]some detail plan of improving hash index

2008-05-16 Thread Josh Berkus
Xiao, > Phase 1 seems extremely easy. I'm trying to do it first. > Additionally, I need a benchmark to test the performance. It seems > there's some tools list in > http://wiki.postgresql.org/wiki/Performances_QA_testing . Any advice? For a simple test, pgbench is actually going to be pretty good

Re: [HACKERS] [GSoC08]some detail plan of improving hash index

2008-05-16 Thread Kenneth Marshall
Hi Xiao Meng, I am glad that you are making some progress. I have added a couple of comments below. Your phased approach is a good way to get it in a position for testing. I had a very basic test for creation time, query time for a simple lookup, and index size that I would like to re-run when you

[HACKERS] [GSoC08]some detail plan of improving hash index

2008-05-15 Thread Xiao Meng
Hi, hackers. I'm reading the source codes of hash and reviewing Neil's old patch of improving hash index. Here is some detail plan. I'm trying to adjust Neil's patch to the current version of PostgreSQL first. I'm not quite familar with the code yet, so please make some comment. * Phase 1. Just s