Slightly off topic for this thread... I figured I give it a whirl...
I've often wondered what sort of performance increase one would get by placing
the WAL on a solid-state drive like a 2 or 4GB TiGi. Has anyone tested this
type of setup for a performance gain? For a 2GB drive it runs ~$3000. It would
really have to make a difference... I'm strongly cosidering testing this out.
CG
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alexander Cohen <alex@toomuchspace.com> writes:
> >>> Is it possible to turn WAL completely off. For good reasons, i dont
> >>> ever want to use it. How can i turn it off?
> >>
> >> You can't. The postgresql team is not in the business of producing
> >> databases that can't handle a power failure.
> >>
> >> Any hints as to what your "good reason" is?
>
> > I need a small cluster. Thats the main reason. 30 Mb with no data in it .
> > is pretty large, to me at least. And im not using it in a manner that a
> > power failure will matter.
>
> To be blunt, you don't want Postgres. Consider Berkeley DB or tinysql
> or (holds nose) MySQL. What you're after isn't within the design goals
> for this project, either as to disk footprint or disinterest in power
> failure behavior.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.orgt)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/