Re: Priority table or Cache table

On Tue, Jun 3, 2014 at 9:50 AM, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
wrote:

> Sorry for the late reply. Thanks for the test.
> Please find the re-based patch with a temp fix for correcting the problem.
> I will a submit a proper patch fix later.
>
>
Please note that the new patch still gives assertion error:

TRAP: FailedAssertion("!(buf->freeNext != (-2))", File: "freelist.c", Line:
178)
psql:load_test.sql:5: connection to server was lost

Hence, the patch was installed with assertions off.

I also ran the test script after making the same configuration changes that
you have specified. I found that I was not able to get the same performance
difference that you have reported.

Following table lists the tps in each scenario and the % increase in
performance.

Threads Head Patched Diff
1 1669 1718 3%
2 2844 3195 12%
4 3909 4915 26%
8 7332 8329 14%

Kindly let me know if I am missing something.

--
Beena Emerson