From: | "Martin Scholes" <marty(at)iicolo(dot)com> |
---|---|
To: | "Martin Scholes" <marty(at)iicolo(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: WAL Bypass for indexes |
Date: | 2006-04-05 16:40:28 |
Message-ID: | TRQ1fnRR4VkP.pWbp5wwT@mail.iicolo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I wrote:
> I will run multiple tests and post the actual numbers.
I did run more extensive tests and did not bother writing down the numbers, and here's why: the unmodified Pg ran pgbench with a whopping average of 6.3% time in IO wait.
If I was able to totally eliminate that time (which is impossible), then the best we could hope for is a 7% increase in performance by skipping WAL of indexes.
On a related note, we currently have some indexes that are unsafe during recovery (GIST and Hash come to mind).
In the spirit of making Pg "safe at any speed," would it make sense to put some code in the recovery section that rebuilds all indexes whose integrity cannot be assured?
M
From | Date | Subject | |
---|---|---|---|
Next Message | mark | 2006-04-05 16:46:18 | Re: Stats collection on Windows |
Previous Message | Tom Lane | 2006-04-05 16:09:07 | Re: WAL Bypass for indexes |