Postgres Pro
Downloads
Home   >   mailing lists

Re: Priority table or Cache table - Mailing list pgsql-hackers

From Beena Emerson
Subject Re: Priority table or Cache table
Date
Msg-id CAOG9ApE4Qu7fuoOEFRUiG0xFZYqNtscNgH2s2O8Q2iGgeoO66A@mail.gmail.com
Whole thread Raw
In response to Re: Priority table or Cache table  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: Priority table or Cache table
List pgsql-hackers
Tree view
On Tue, Jun 3, 2014 at 9:50 AM, Haribabu Kommi <kommi.haribabu@gmail.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



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: IMPORT FOREIGN SCHEMA statement
Next
From: Robert Haas
Date:
Subject: Re: pgaudit - an auditing extension for PostgreSQL