Re: [PERFORM] Value of Quad vs. Dual Processor machine

, RAM and I/O are most important. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA As I like to joke, I may have invented it, but Microsoft made it popular David Bradley, regarding Ctrl-Alt-Del

Re: [PERFORM] Tuning for mid-size server

. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA Fear the Penguin!! ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] go for a script! / ex: PostgreSQL vs. MySQL

to set config values in some obscure units rather than bytes is an ugly braindamage which should be easy to fix. But it's too user-friendly to do it this way! -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA When Swedes

[PERFORM] basket, eggs NAS (was eggs Re: [NOVICE] Ideal Hardware?)

are easily available) disk subsystem for however many smaller CPU-boxes you get. (They could be kept un-shared by making separate partitions, and each machine only mounts one partition.) -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson

Re: [PERFORM] SQL slower when running for the second time

minutes, and I should retunr faster than the first time. Does anyone have a advice ? Is it a query or insert/update? -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA Vanity, my favorite sin. Larry/John/Satan

Re: [PERFORM] opinion on RAID choice

_not_ want to use RAID 5 with Veritas. Why should Veritas care? Or is it that Veritas has a high overhead of small block writes? -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA Millions of Chinese speak Chinese, and it's

Re: [PERFORM] Selecting random rows efficiently

of the keys at random then directly fetch that row. are there any other ways to do this? i need to keep the load down :) Thanks, Richard Are you really in Micronesia? -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA

Re: [PERFORM] How to force Nested Loop plan?

(32 bit) scalars are faster than bit (64 bit) scalars on x86 h/w. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA Adventure is a sign of incompetence Stephanson, great polar explorer ---(end

Re: [PERFORM] How to force Nested Loop plan?

. This is the first query where we ran out of ideas to try. Dumb question: given your out-of-the-box satisfaction, could it be that postgresql.conf hasn't been tweaked? -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA

Re: [PERFORM] Hardware recommendations to scale to silly load

PA-RSC- 8700, ultraSparcs, Power series and if possible itanium. IMO, Opti will compete in *both* markets. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA Adventure is a sign of incompetence Stephanson, great polar

Re: [PERFORM] Hardware recommendations to scale to silly load

boxes and run VMS and high-end Unix , but Opti can't? Nothing. If a company with enough engineering talent wants to do it, it can happen. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA For me and windows it became

Re: [PERFORM] Hardware recommendations to scale to silly load

large buffers and hashed indexes, with the table tuples stored on the same page as the hashed index keys, to make such accesses *blazingly* fast. Many thanks for reading this far. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson

Re: [PERFORM] Hardware recommendations to scale to silly load

after dinosaur customers had it on boxen that academics, analysts and young whippersnappers said were supposed to be extinct 20 years ago. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA Knowledge should be free for all

Re: [PERFORM] The results of my PostgreSQL/filesystem performance

) would perform. Thanks for the results! -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA Oh, great altar of passive entertainment, bestow upon me thy discordant images at such speed as to render linear thought impossible

Re: [PERFORM] The results of my PostgreSQL/filesystem performance

they are and hopefully everyone can learn a few things from them. Intelligent feedback is welcome. http://www.potentialtech.com/wmoran/postgresql.php I notice that the Linux FSs weren't tested with noatime. Any reason? -- - Ron

Re: [PERFORM] Perfomance Tuning

-- +---+ | Ron Johnson, Jr.Home: [EMAIL PROTECTED] | | Jefferson, LA USA| | | | Man, I'm pretty. Hoo Hah

Re: [PERFORM] Perfomance Tuning

horizontal partitioning, and as a precursor to that, tablespaces? -- +---+ | Ron Johnson, Jr.Home: [EMAIL PROTECTED] | | Jefferson, LA USA

Re: [PERFORM] Perfomance Tuning

(e.g. things introduced in 2.4.x won't really be stable until 2.6.x) -- and even there one is taking a risk[1]. Dudes, seriously - switch to FreeBSD :P But, like, we want a *good* OS... 8-0 -- +---+ | Ron Johnson, Jr.Home

Re: [PERFORM] PostgreSQL performance problem - tuning

on disk caching. Why should I duplicate their efforts? Thus, give PG only a little RAM, and let the OS' disk cache hold the rest. -- +---+ | Ron Johnson, Jr.Home: [EMAIL PROTECTED] | | Jefferson, LA USA

Re: [PERFORM] How number of columns affects performance

On Fri, 2003-08-01 at 12:14, Francisco J Reyes wrote: On Fri, 1 Aug 2003, Ron Johnson wrote: Do all 100 fields *really* all refer to the same *one* entity, with no repeating values, etc? Yes all fields belong to the same entity. I used 100 as an example it may be something like 60 to 80

Re: [PERFORM] How number of columns affects performance

increase performance. And the answer is sometimes, -- +-+ | Ron Johnson, Jr.Home: [EMAIL PROTECTED] | | Jefferson, LA USA

Re: [PERFORM] Tuning PostgreSQL

, and speed, important enough? -- +-+ | Ron Johnson, Jr.Home: [EMAIL PROTECTED] | | Jefferson, LA USA

Re: [PERFORM] Tuning PostgreSQL

-- +-+ | Ron Johnson, Jr.Home: [EMAIL PROTECTED] | | Jefferson, LA USA | | | | I'm not a vegetarian because I love animals, I'm a vegetarian

Re: [PERFORM] Hardware performance

enough, you can make everything redundant and burden-sharing (i.e., not just waiting for the master system to die). (And with some enterprise FC controllers, you can mirror the disks many kilometers away.) -- +-+ | Ron Johnson, Jr