| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Fast CLUSTER |
| Date: | 2007-02-07 08:28:12 |
| Message-ID: | 1170836892.3645.594.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
I've used the heap_sync() API call to improve performance of CLUSTER by
avoiding WAL when archive_command is not set.
I've refactored the heap_sync() call very slightly, to hide some of the
complexity that was previously exposed to COPY. It now syncs a TOAST
relation automatically if one exists for the table. That also fixes a
latent bug in CREATE TABLE AS SELECT which would have meant that the
TOAST table wasn't properly synced (my bug), effectively caused by the
original API design.
Patch applies cleanly, passes make check.
No user interface changes. Performance docs updated also to reflect this
change and slightly improve directly related wording.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| fast_cluster.v1.patch | text/x-patch | 9.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adriaan van Os | 2007-02-07 10:24:49 | BUG #2977: dow doesn't conform to ISO-8601 |
| Previous Message | Jeremy Drake | 2007-02-07 08:26:00 | Re: [PATCHES] writing new regexp functions |