| From: | Robert Abraham <robert(dot)abraham86(at)googlemail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Patch for ginCombineData |
| Date: | 2015-08-05 10:17:50 |
| Message-ID: | CABQqHAWYXW+NzAYw4uG_FnbjrdEFyRaigLRkQ7AzAtS6AbHnfA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
we are using gin indexes on big tables. these tables happen to have several
billion rows.
the index creation fails in ginCombineData in src/backend/access/ginbulk.c
because repalloc is limited to 1 gb.
this limitation makes no sense in this context (compare comments in
src/include/utils/memutils.h).
To overcome this limitation on tables with lots of rows repalloc_huge is
used.
The test suite still succeeds on my machine.
Find the patch attached,
Kind regards,
Robert Abraham
| Attachment | Content-Type | Size |
|---|---|---|
| gin_combiner_repalloc_huge.patch | text/x-patch | 702 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stepan Rutz | 2015-08-05 10:24:08 | Add column-name hint to log messages generated by inserts when varchars don't fit |
| Previous Message | Amit Langote | 2015-08-05 07:58:04 | Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types |