| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: modeling parallel contention (was: Parallel Append implementation) |
| Date: | 2017-05-08 01:30:29 |
| Message-ID: | CAKJS1f99yJ3wWS38KsP2_WXMTMr9RVEG1SrpNF=683MaVkAxxg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 5 May 2017 at 14:54, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> Just for fun, check out pages 42 and 43 of Wei Hong's thesis. He
> worked on Berkeley POSTGRES parallel query and a spin-off called XPRS,
> and they got linear seq scan scaling up to number of spindles:
>
> http://db.cs.berkeley.edu/papers/ERL-M93-28.pdf
That's interesting. I'd no idea that work was done. Actually, I didn't
really know that anyone had thought to have more than one processor
back then :-)
And I also now know the origins of the tenk1 table in the regression
database. Those 10,000 rows were once used for benchmarking! I'm glad
we're all using a couple more rows these days.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2017-05-08 01:39:00 | Re: modeling parallel contention (was: Parallel Append implementation) |
| Previous Message | Thomas Munro | 2017-05-08 01:22:52 | Re: Declarative partitioning - another take |