Re: Fail to create PK or index for large table in Windows

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Pavel <ospavelmail(at)gmail(dot)com>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Fail to create PK or index for large table in Windows
Date: 2018-11-19 19:51:49
Message-ID: CAEepm=0v_XycY=-ZePX1QEOw5SgNm-WLpqA-RTznpaf1oUDfAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Nov 16, 2018 at 2:10 PM Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> <thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> https://ci.appveyor.com/project/macdice/postgres/builds/20341645/artifacts
>
> I'm not sure how easy this will be to work with if you're used to one
> of those installers. Hopefully all the libraries needed are present
> and you can just unzip it and run "initdb.exe -D pgdata",
> "postgres.exe -D pgdata" -- but I have no personal experience of
> PostgreSQL on Windows so I'm guessing here. Pavel, if you have time
> to try testing the bug fix that was committed, that'd be great. If it
> goes well, perhaps we could consider making bleeding edge builds
> available all the time.

A couple of people wrote to me off-list to say they'd like to test the
11 stable branch, not the master branch, and would like a build.
Thanks for testing! Presumably they might want to test against their
existing pgdata where they've seen the problem. Fair enough -- but
please do use a *copy* of your pgdata directory, not your production
system, if it's a database you care about! These builds are for
testing only, though the the stable 11 branch offers a preview of what
will probably ship in 11.2.

Here's the REL_11_STABLE branch built for Windows as of a couple minutes ago:

https://ci.appveyor.com/project/macdice/postgres/builds/20412803/artifacts

--
Thomas Munro
http://www.enterprisedb.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-11-19 22:12:53 Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT
Previous Message Jakub Janeček 2018-11-19 13:32:43 Re: BUG #15486: PG11 jit on 50x slower than jit off