| From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Index trouble with 8.3b4 |
| Date: | 2008-01-14 17:59:45 |
| Message-ID: | 478BA311.6030909@theendofthetunnel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
> I wrote:
>> I think it's okay for CREATE INDEX CONCURRENTLY to use bulk-read access
>> strategy (that is, seqscan using a limited number of buffers), but it
>> has to be able to force the scan to start at page zero.
>
> I've committed a patch to do that. Please test CVS HEAD and see if you
> still see problems.
With some limited testing it seems both cases are indeed fixed. I was
unable to reproduce either with current CVS HEAD. Though I'll run some
further tests tomorrow to back that up.
Thanks for your time and prompt responses.
--
Best regards,
Hannes Dorbath
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2008-01-14 19:02:46 | COUNT() with ORDER BY |
| Previous Message | Andrej Ricnik-Bay | 2008-01-14 17:04:42 | Members-choice award at LinuxQuestions.org |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-14 18:46:17 | pgsql: Fix an ancient oversight in libpq's handling of V3-protocol COPY |
| Previous Message | Ron Mayer | 2008-01-14 17:17:10 | Re: Postgresql Materialized views |