| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Tatsuo Ishii" <ishii(at)postgresql(dot)org> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: avoiding WAL logging in 8.3 |
| Date: | 2007-07-24 06:30:50 |
| Message-ID: | 1185258650.4263.32.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2007-07-24 at 13:04 +0900, Tatsuo Ishii wrote:
> I noticed in 8.3 there are chances where we can avoid WAL logging. For
> example, 8.3's pgbench was modified to use TRUNCATE right before
> COPY. Is there any documentation which describes that kind of
> techniques? If there's none, I would volunteer the work to create such
> a documentation since I think this is valuable information for DBAs
> who wish to migrate to 8.3.
The Performance Tips section has been modified to describe this. Would
you like me to add something elsewhere also? Multiple entry points to
information helps everybody, so I'll happily add more.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-07-24 06:41:39 | Re: Reviewing new index types (was Re: [PATCHES]Updatedbitmap indexpatch) |
| Previous Message | ITAGAKI Takahiro | 2007-07-24 05:00:43 | Re: autovacuum default parameters (was Re: 8.2 is 30% better in pgbench than 8.3) |