Re: Multi-threading friendliness

Поиск
Список
Период
Сортировка
Искать
От
James Mansion
Тема
Re: Multi-threading friendliness
Дата
Msg-id
4766E4A5.40405@mansionfamily.plus.com
Ответ на
Список
Дерево обсуждения
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 "Luke Lonergan" <LLonergan@greenplum.com>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Simon Riggs <simon@2ndquadrant.com>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark <stark@enterprisedb.com>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 "Luke Lonergan" <llonergan@greenplum.com>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood <markir@paradise.net.nz>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark <stark@enterprisedb.com>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood <markir@paradise.net.nz>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark <stark@enterprisedb.com>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood <markir@paradise.net.nz>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark <stark@enterprisedb.com>
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 "Luke Lonergan" <llonergan@greenplum.com>
hardware and For PostgreSQL Ketema Harris <ketema@ketema.net>
Re: hardware and For PostgreSQL Joe Uhl <joeuhl@gmail.com>
Re: hardware and For PostgreSQL "Joshua D. Drake" <jd@commandprompt.com>
Re: hardware and For PostgreSQL Ron St-Pierre <ron.pgsql@shaw.ca>
Re: hardware and For PostgreSQL Paul Lambert <paul.lambert@autoledgers.com.au>
Re: hardware and For PostgreSQL Magnus Hagander <magnus@hagander.net>
Re: hardware and For PostgreSQL Joe Uhl <joeuhl@gmail.com>
libgcc double-free, backend won't die Craig James <craig_james@emolecules.com>
Re: libgcc double-free, backend won't die Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: libgcc double-free, backend won't die Craig James <craig_james@emolecules.com>
Re: libgcc double-free, backend won't die Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: libgcc double-free, backend won't die Craig James <craig_james@emolecules.com>
Re: libgcc double-free, backend won't die Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: libgcc double-free, backend won't die Craig James <craig_james@emolecules.com>
Re: libgcc double-free, backend won't die Tom Lane <tgl@sss.pgh.pa.us>
Re: libgcc double-free, backend won't die Craig James <craig_james@emolecules.com>
Re: libgcc double-free, backend won't die Tom Lane <tgl@sss.pgh.pa.us>
Re: libgcc double-free, backend won't die Craig James <craig_james@emolecules.com>
Re: libgcc double-free, backend won't die Tom Lane <tgl@sss.pgh.pa.us>
Re: hardware and For PostgreSQL "Scott Marlowe" <scott.marlowe@gmail.com>
Re: hardware and For PostgreSQL Ben <bench@silentmedia.com>
Craig James wrote:
> Don't confuse thread-friendly with a threaded implemetation of 
> Postgres itself.  These are two separate questions.  Thread-friendly 
> involves compile/link options that don't affect the Postgres source 
> code at all.
Indeed.  I'm specifically not suggesting that Postgres should offer an 
API that can be called from
anything except the initial thread of its process - just that library 
subsystems might want to use
threads internally and that should be OK. Or rather, it should be 
possible to build Postgres
so that its OK.  Even if there's a small slowdown, the benefit of 
running the full JVM or CLR
might outweigh that quite easily *in some circumstances*.

I've also hinted that at some stage you might want to thread some parts 
of the implementation,
but I'm not suggesting that would be an early target.  It seems to me 
sensible to make it
straightforward to take baby steps in that direction in future would be 
a reasonable thing to
do.  As would being friendly to dynamically loaded C++ code.  If you 
create the framework,
(and we're talking the barest of scaffolding) then others can work to 
show the cost/benefit.

I fail to see why this would be a controversial engineering approach.

James

В списке pgsql-performance по дате отправления
От: Craig James
Дата:
От: Robert Bernabe
Дата:
FAQ