Re: [PERFORM] more on high load on postgres 7.4.16

2007-04-06 Thread Geoffrey
Stefan Kaltenbrunner wrote: Geoffrey wrote: We are trying to attack this problem from multiple avenues, thus I'm starting a separate thread. This is with regard to the problem posted via thread: http://archives.postgresql.org/pgsql-performance/2007-04/msg00120.php One thing we are s

[PERFORM] more on high load on postgres 7.4.16

2007-04-06 Thread Geoffrey
cal/pcm170/libcompress.so #8 0x00bec527 in exit () from /lib/tls/libc.so.6 #9 0x0816a52f in proc_exit () -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin

Re: [PERFORM] SCSI vs SATA

2007-04-06 Thread Geoffrey
it, but it might just be that my UPS guy is clumsier than theirs. Good point. Folks must realize that carriers handle computer hardware the same way they handle a box of marshmallows or ball bearings.. A box is a box is a box. -- Until later, Geoffrey Those who would give up essential Libe

Re: [PERFORM] SCSI vs SATA

2007-04-06 Thread Geoffrey
read that much of the damage that causes hard drive infant mortality is related to shipping. Doh, of course. Maybe I'd better go to bed now... regards, tom lane You actually sleep? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase

Re: [PERFORM] which Xeon processors don't have the context switching problem

2007-03-05 Thread Geoffrey
Joshua D. Drake wrote: Geoffrey wrote: Guillaume Smet wrote: On 2/23/07, Geoffrey <[EMAIL PROTECTED]> wrote: As I've heard. We're headed for 8 as soon as possible, but until we get our code ready, we're on 7.4.16. You should move to at least 8.1 and possibly 8.2. It

Re: [PERFORM] which Xeon processors don't have the context switching problem

2007-02-23 Thread Geoffrey
Guillaume Smet wrote: On 2/23/07, Geoffrey <[EMAIL PROTECTED]> wrote: As I've heard. We're headed for 8 as soon as possible, but until we get our code ready, we're on 7.4.16. You should move to at least 8.1 and possibly 8.2. It's not a good idea to upgrade only to

Re: [PERFORM] which Xeon processors don't have the context switching problem

2007-02-23 Thread Geoffrey
Joshua D. Drake wrote: Josh Berkus wrote: Geoffrey, I recall a reference on the list indicating that newer Xeon processors don't suffer from the context switching problem reported last year. Just to be clear, it's a software problem which affects all architectures, including AMD

Re: [PERFORM] which Xeon processors don't have the context switching problem

2007-02-23 Thread Geoffrey
Josh Berkus wrote: Geoffrey, I recall a reference on the list indicating that newer Xeon processors don't suffer from the context switching problem reported last year. Just to be clear, it's a software problem which affects all architectures, including AMD and Sparc. It's

[PERFORM] which Xeon processors don't have the context switching problem

2007-02-23 Thread Geoffrey
reference? Is this in any way related to the version of Postgresql one is running? We're headed for 8, but have a bit of work before we can get there. We are currently on 7.4.16. Thanks for any info. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a lit

Re: [PERFORM] trouble with a join on OS X

2007-02-02 Thread Geoffrey
Joshua D. Drake wrote: Luke Lonergan wrote: \o /tmp/really_big_cursor_return ;) Tough crowd :-D Yeah well Andrew probably would have said use sed and pipe it through awk to get the data you want. Chances are, if you're using awk, you shouldn't need sed. :) -- Until later, Geoff

Re: [PERFORM] High update activity, PostgreSQL vs BigDBMS

2007-01-02 Thread Geoffrey
hat not be the same as ext2? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PERFORM] Unsubscribe

2006-10-04 Thread Geoffrey
est response, you'd find a lot of these folks are just plain lazy. They don't want to recall how to unsubscribe and figure sending mail to the list will get the required result. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary

Re: [PERFORM] Unsubscribe

2006-10-03 Thread Geoffrey
uwcssa wrote: Please unsubscribe me! Thank you! Also, it would be better to have a message foot saying how to unsubscribe. It would be better if you would have paid attention when you subscribed as to how to unsubscribe. -- Until later, Geoffrey Those who would give up essential

Re: [PERFORM] Unsubscribe

2006-09-13 Thread Geoffrey
http://www.postgresql.org/community/lists/ http://www.postgresql.org/community/lists/subscribe -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin ---(end of

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Geoffrey
ossible for this. There's always system(3) fork(), exec()... -- Until later, Geoffrey Any society that would give up a little liberty to gain a little security will deserve neither and lose both. - Benjamin Franklin ---(end of broadcast)--- TIP

Re: [PERFORM] solutions for new Postgresql application testing

2005-11-01 Thread Geoffrey
Merlin Moncure wrote: Geoffrey wrote: We are going live with a application in a few months that is a complete rewrite of an existing application. We are moving from an existing proprietary database to Postgresql. We are looking for some insight/suggestions as to how folks test Postgresql in

[PERFORM] solutions for new Postgresql application testing

2005-11-01 Thread Geoffrey
ation as we really want high level stuff at this time. Thanks for any pointers or suggestions. -- Until later, Geoffrey ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [PERFORM] Whence the Opterons?

2005-05-09 Thread Geoffrey
John A Meinel wrote: Geoffrey wrote: Mischa Sandberg wrote: After reading the comparisons between Opteron and Xeon processors for Linux, I'd like to add an Opteron box to our stable of Dells and Sparcs, for comparison. IBM, Sun and HP have their fairly pricey Opteron systems. The IT people ar

Re: [PERFORM] Whence the Opterons?

2005-05-08 Thread Geoffrey
hases off ebay. Anyone care to suggest any other vendors/distributors? Looking for names with national support, so that we can recommend as much to our customers. Monarch Computer http://www.monarchcomputer.com/ They have prebuilt and custom built systems. -- Until later, Geo

Re: [PERFORM] Intel SRCS16 SATA raid?

2005-04-14 Thread Geoffrey
, but it costs nearly 300% more ($538 cdw.com, $180 newegg.com). True, but that's a one time expense (300%) for a 44% gain ALL the time. '44% better' is nothing to sneeze at. I'd easily pay the price for the gain in a large server env. -- Until later, Geoffrey --

Re: [PERFORM] [NOVICE] \d output to a file

2004-12-15 Thread Geoffrey
les as well I think. Alternately you could do something like: for table in $( outputfile -- Until later, Geoffrey ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PERFORM] Alternatives to Dell?

2004-12-02 Thread Geoffrey
x. It's unlikely you'll get that kind of service from any of the big guys. As far as Dell is concerned, I've heard nothing but problems from other folks using their boxes, both servers and desktops. My personal experience reflects the same. -- Until later, Geoffrey -

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
even offer Opteron). You can do the same with Monarch Computers. A 4u quad opteron. You can also pay a lot more, depends on the configuration. They have a very nice site for building a system as you want. -- Until later, Geoffrey ---(end of

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
Linux Journal for a while and a couple of their boxes have been reviewed there. As a matter of fact, in the December issue, they did a review of a dual operton from Monarch. http://www.monarchcomputer.com/ -- Until later, Geoffrey ---(end of broadcast)--

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
Iain wrote: I always say 'If you pay for quality it only hurts once', but then again I don't equate high price with high quality ;-) True, but if you do your research, you'll more likely to get high quality with high price then you are high quality with low price. -- U

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
ver market share. Something to be said for the old saying, 'you get what you pay for.' -- Until later, Geoffrey ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAI

Re: [PERFORM] fsync vs open_sync

2004-09-05 Thread Geoffrey
icial position on Reiser file systems, I do know that it is the default when installing, so I'd suggest you might check into it. -- Until later, Geoffrey Registered Linux User #108567 AT&T Certified UNIX System Programmer - 1995 -

Re: [PERFORM] PostgreSQL and Linux 2.6 kernel.

2004-04-15 Thread Geoffrey
ot;Tom Lane"; my @morepgGurus; my $howmany = 10; while($howmany--) { push @morepgGurus, $pgGuru; } -- Until later, Geoffrey Registered Linux User #108567 Building secure systems in spite of Microsoft ---(end of broadcast)--- TI

Re: [PERFORM] good pc but bad performance,why?

2004-04-08 Thread Geoffrey
tems as ext2 and they will function just as ext2. -- Until later, Geoffrey Registered Linux User #108567 Building secure systems in spite of Microsoft ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister co

Re: [PERFORM] PostgreSQL data on a NAS device ?

2003-10-21 Thread Geoffrey
ant to our client. * I need to install and configure a 64bit Linux flavour which I don't know (yet) See http://www.monarchcomputer.com/ they custom build operton systems and preload them with Linux. You don't pay the Microsoft tax. -- Until later, Geoffrey [EMAIL PROTECTED] --