Re: [DOCS] Added documentation about caching, reliability
Peter Eisentraut wrote: > Am Mittwoch, 28. September 2005 20:26 schrieb Bruce Momjian: > > I also renamed the chapter "Reilability" rather than "WAL." > > Considering that the chapter is, in fact, all about WAL, I don't think this > is > a good move. Reliability is a concern that is not only addressed by the WAL > system. Please change it back. Well, now the chapter is about WAL and reliability, so I thought reliability hit both topics. Also, maybe we should consider moving this FAQ item into the docs: 3.7) What computer hardware should I use? Because PC hardware is mostly compatible, people tend to believe that all PC hardware is of equal quality. It is not. ECC RAM, SCSI, and quality motherboards are more reliable and have better performance than less expensive hardware. PostgreSQL will run on almost any hardware, but if reliability and performance are important it is wise to research your hardware options thoroughly. Our email lists can be used to discuss hardware options and tradeoffs. Anyway, I thought the previous chapter title, WAL, was weird because it was hard to know why an administrator would care about WAL --- there was no lead-in to the term. This way, it is all under reliability, and can add to it. -- Bruce Momjian| http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] Added documentation about caching, reliability
Bruce Momjian wrote: > Well, now the chapter is about WAL and reliability, so I thought > reliability hit both topics. Also, maybe we should consider moving > this FAQ item into the docs: > > 3.7) What computer hardware should I > use? Hardware choice and configuration are important topics, but neither of these are strongly tied to either WAL or Reliability. Reliability is the property (not a "feature") of a system to do what you meant for it to do. Certainly WAL contributes to that by increasing tolerance against hardware failures, but it still seems to be a rather far-fetched connection to pair these two. I could see hardware issues being discussed in chapter 16, since we already have operating system and kernel configuration there, and it's the chapter a user will read when setting up a server system. I was never all that happy with the WAL chapter, since, as you say, it doesn't seem to be a first-class user-level feature. I'd be happy to integrate it into another chapter, but I'm not sure where. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] Added documentation about caching, reliability
Peter Eisentraut wrote: > Bruce Momjian wrote: > > Well, now the chapter is about WAL and reliability, so I thought > > reliability hit both topics. Also, maybe we should consider moving > > this FAQ item into the docs: > > > > 3.7) What computer hardware should I > > use? > > Hardware choice and configuration are important topics, but neither of > these are strongly tied to either WAL or Reliability. Reliability is > the property (not a "feature") of a system to do what you meant for it > to do. Certainly WAL contributes to that by increasing tolerance > against hardware failures, but it still seems to be a rather > far-fetched connection to pair these two. > > I could see hardware issues being discussed in chapter 16, since we > already have operating system and kernel configuration there, and it's > the chapter a user will read when setting up a server system. > > I was never all that happy with the WAL chapter, since, as you say, it > doesn't seem to be a first-class user-level feature. I'd be happy to > integrate it into another chapter, but I'm not sure where. Sure, I am looking for suggestions. My relabeling at least fixes that, but feel free to move things around and relabel them. -- Bruce Momjian| http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] INSTALL file nits
Rich, I just grabbed a copy of PostgreSQL from http://www.apple.com/downloads/macosx/unix_open_source/postgresql.html There's a much *bigger* issue than the ones you mention. That's PostgreSQL 7.3, 3 years old. I've written Apple several times about updating it, but no response. I suggest getting your PostgreSQL from Entropy.ch instead. --Josh ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [DOCS] INSTALL file nits
Actually, it's version 8.0.3, as of 2005.09.21. Izzat OK? -r At 9:27 AM -0700 9/29/05, Josh Berkus wrote: There's a much *bigger* issue than the ones you mention. That's PostgreSQL 7.3, 3 years old. I've written Apple several times about updating it, but no response. -- email: [EMAIL PROTECTED]; phone: +1 650-873-7841 http://www.cfcl.com- Canta Forda Computer Laboratory http://www.cfcl.com/Meta - The FreeBSD Browser, Meta Project, etc. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [DOCS] INSTALL file nits
Rich, > Actually, it's version 8.0.3, as of 2005.09.21. Izzat OK? Oh, cool! They updated it! They just didn't mail me I suppose. Oh, I see. This isn't an Apple Download, it's just a link to source downloads off of our site. I think you're correct, the best thing would be to add something to the docs about "installing on OSX". Could you write such a thing? You've posted most of it, but if you could do a HOWTO-style that would be keen. Of course, we still recommend entropy.ch: http://www.entropy.ch/software/macosx/postgresql/ --Josh -- __Aglio Database Solutions___ Josh BerkusConsultant [email protected] Ph: 415-752-2500Fax: 415-752-2387 2166 Hayes Suite 200San Francisco, CA ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] INSTALL file nits
Rich, All, Even better, Dru seems to have an installer: http://pgsqlformac.sourceforge.net/ I'm going to contact him about mirroring his installer through the FTP sites. --Josh -- __Aglio Database Solutions___ Josh BerkusConsultant [email protected] Ph: 415-752-2500Fax: 415-752-2387 2166 Hayes Suite 200San Francisco, CA ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] INSTALL file nits
Hi, On Thu, 29 Sep 2005, Josh Berkus wrote: Even better, Dru seems to have an installer: http://pgsqlformac.sourceforge.net/ I'm going to contact him about mirroring his installer through the FTP sites. Inviting Dru to pgfoundry is better I think, that will make it easier to mirror the installer from our FTP and the mirrors like other pgfoundry projects. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
