Re: Benchmark Data requested
От
Matthew
Тема
Re: Benchmark Data requested
Дата
Msg-id
Pine.LNX.4.64.0802051554010.20402@aragorn.flymine.org
Ответ на
Re: Benchmark Data requested (Richard Huxton)
Список
Дерево обсуждения
Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Mark Wong <markwkm@gmail.com>
Re: Benchmark Data requested Gregory Stark <stark@enterprisedb.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested "Claus Guttesen" <kometen@gmail.com>
Re: Benchmark Data requested Luke Lonergan <llonergan@greenplum.com>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Luke Lonergan <llonergan@greenplum.com>
Re: Benchmark Data requested Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Mark Wong <markwkm@gmail.com>
Dell Perc/6 Craig James <craig_james@emolecules.com>
Re: Dell Perc/6 Tore Halset <halset@pvv.ntnu.no>
Re: Dell Perc/6 "Merlin Moncure" <mmoncure@gmail.com>
Re: Dell Perc/6 Dave Cramer <pg@fastcrypt.com>
Re: Dell Perc/6 Tore Halset <halset@pvv.ntnu.no>
Re: Dell Perc/6 Tore Halset <halset@pvv.ntnu.no>
Re: Dell Perc/6 Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested --- pgloader CE design ideas Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested --- pgloader CE design ideas Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested --- pgloader CE design ideas Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested --- pgloader CE design ideas Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested --- pgloader CE design ideas Mark Lewis <mark.lewis@mir3.com>
Re: Benchmark Data requested --- pgloader CE design ideas Kenneth Marshall <ktm@rice.edu>
Re: Benchmark Data requested --- pgloader CE design ideas Matthew <matthew@flymine.org>
Re: Benchmark Data requested --- pgloader CE design ideas "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested --- pgloader CE design ideas Luke Lonergan <llonergan@greenplum.com>
Re: Benchmark Data requested "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested NikhilS <nikkhils@gmail.com>
Re: Benchmark Data requested "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Benchmark Data requested Richard Huxton <dev@archonet.com>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Richard Huxton <dev@archonet.com>
Re: Benchmark Data requested Simon Riggs <simon@2ndquadrant.com>
Re: Benchmark Data requested Dimitri Fontaine <dfontaine@hi-media.com>
Re: Benchmark Data requested Richard Huxton <dev@archonet.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested Matthew <matthew@flymine.org>
Re: Benchmark Data requested Richard Huxton <dev@archonet.com>
Re: Benchmark Data requested Matthew <matthew@flymine.org>
Re: Benchmark Data requested Richard Huxton <dev@archonet.com>
Re: Benchmark Data requested Matthew <matthew@flymine.org>
Re: Benchmark Data requested Matthew <matthew@flymine.org>
Re: Benchmark Data requested Matthew <matthew@flymine.org>
Re: Benchmark Data requested Matthew <matthew@flymine.org>
Re: Benchmark Data requested Gregory Stark <stark@enterprisedb.com>
Re: Benchmark Data requested "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Re: Benchmark Data requested Greg Smith <gsmith@gregsmith.com>
Re: Benchmark Data requested Luke Lonergan <llonergan@greenplum.com>
Re: Benchmark Data requested Greg Smith <gsmith@gregsmith.com>
On Tue, 5 Feb 2008, Richard Huxton wrote:
>> Why would you need to lock the table?
>
> Because you're not really writing the WAL, which means you can't let anyone
> else get their data into any of the blocks you are writing into. You'd
> basically want to write the disk blocks then "attach" them in some way.
So what's wrong with "reserving" the space using the WAL, then everyone
else will know. After all, when you write the data to the WAL, you must
have an idea of where it is meant to end up. My suggestion is that you go
through all the motions of writing the data to the WAL, just without the
data bit.
Matthew
--
Failure is not an option. It comes bundled with your Microsoft product.
-- Ferenc Mantfeld
В списке pgsql-performance по дате отправления