| From: | Michael Nolan <htfoot(at)gmail(dot)com> |
|---|---|
| To: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
| Cc: | Sidney Cadot <sidney(at)jigsaw(dot)nl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Searchable chess positions in a Postgress DB |
| Date: | 2012-04-13 00:07:33 |
| Message-ID: | CAOzAquJX5DZBu+oYD16=J7EZOp1j=umfsUoQxZAqkVvOvifW1A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Apr 12, 2012 at 4:50 PM, Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz
> wrote:
> On 11/04/12 21:24, Gavin Flower wrote:
>
> On 11/04/12 19:15, Sidney Cadot wrote:
>
> Dear all,
>
> As a hobby project, I am toying around with a database containing
> about 5 million chess games. On average, these games have about 80
> positions (~ 40 moves by both black and white), which means there are
> about 400 million chess positions in there.
>
>
>
If you haven't done so already, you should read through the literature on
chess and computers. I'm quite a few years out of date, but there's been a
lot of research into efficient ways to store and search chess positions,
and some of it may have dealt with SQL database structures.
--
Mike Nolan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | raghu ram | 2012-04-13 04:38:28 | Re: Re: Hot Standby - ERROR: canceling statement due to conflict with recovery |
| Previous Message | Gavin Flower | 2012-04-12 21:50:37 | Re: Searchable chess positions in a Postgress DB |