Re: gjournal....

On Sun, Mar 30, 2008 at 02:06:17AM -0700, Alfred Perlstein wrote:
* Karl Denninger <karl@xxxxxxxxxxxxx> [080329 20:10] wrote:
Hi folks;

Wondering about the various pros and cons of using the "gjournal" GEOM
provider... and if you can "promote" and existing system using it, or
whether you need to build something anew.

The scenario is a fairly busy and large system with PostgreSQL database data
on it. The data is currently on a 2-disk gmirror pair to provide data
safety in the event of a disk failure.

I am using softupdates right now.

If I'm reading the docs correctly, I can't put gjournal in use on the
existing filesystem, and need to effectively build a new disk structure then
copy over the data onto it.

Can you boot from a gjournal'd root?

Ideas please, pros and cons of the various alternatives, etc..... thanks!


If you're using a database then it shouldn't matter what meta data
provider you use "all that much" with the exception of temporary
tables.

Basically, SU and gjournal both provide for meta data consistency,
something that a database rarely needs as it rarely creates/deletes
files often.


I'm looking at this more from a performance standpoint.

Is there a performance advantage to using gjournal over a "normal" UFS/UFS2
filesystem with softupdates?

--
--
Karl Denninger (karl@xxxxxxxxxxxxx) Internet Consultant & Kids Rights Activist
http://www.denninger.net My home on the net - links to everything I do!
http://scubaforum.org Your UNCENSORED place to talk about DIVING!
http://genesis3.blogspot.com Musings Of A Sentient Mind


_______________________________________________
freebsd-stable@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "freebsd-stable-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: gjournal....
    ... Wondering about the various pros and cons of using the "gjournal" GEOM ... The scenario is a fairly busy and large system with PostgreSQL database data ... provider you use "all that much" with the exception of temporary ...
    (freebsd-stable)
  • gjournal....
    ... Wondering about the various pros and cons of using the "gjournal" GEOM ... provider... ... safety in the event of a disk failure. ...
    (freebsd-stable)
  • RE: pros and cons
    ... and haven't worked with any other database (except a little data ... All I know is that the learning curve for Access is far steeper than anything ... users weigh in--although you'll probably get more pros than cons. ...
    (microsoft.public.access.gettingstarted)
  • Re: Method/Program for small "database" with some pictures entries
    ... images and the amount of data associated with each image. ... >> database file accessed through a database routine library. ...
    (comp.os.linux.misc)
  • Re: Pros n Cons - One class to hold all Data Access Method?
    ... >> What are the Pros n Cons of having ONE and ONLY ONE class to hold all ... I do not mix sql code and .net code. ... > I never allow a database to accept sql code. ...
    (microsoft.public.dotnet.languages.vc)