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

2003-10-21 Thread Geoffrey
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] ---(end

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

2004-04-08 Thread Geoffrey
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 command (send unregister

Re: [PERFORM] PostgreSQL and Linux 2.6 kernel.

2004-04-15 Thread Geoffrey
@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)--- TIP 4: Don't 'kill -9

Re: [PERFORM] fsync vs open_sync

2004-09-05 Thread Geoffrey
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 ATT Certified UNIX System Programmer - 1995 ---(end of broadcast

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
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 [EMAIL PROTECTED] so

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. -- Until later, Geoffrey

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
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)--- TIP 9

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
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 broadcast

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

2004-12-15 Thread Geoffrey
think. Alternately you could do something like: for table in $(listoftables); do echo '\d' | psql done outputfile -- Until later, Geoffrey ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

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 ---(end

Re: [PERFORM] Whence the Opterons?

2005-05-08 Thread Geoffrey
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, Geoffrey

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

[PERFORM] solutions for new Postgresql application testing

2005-11-01 Thread Geoffrey
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] 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

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Geoffrey
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 9: In versions below 8.0

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

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-10-04 Thread Geoffrey
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 Safety, deserve neither Liberty nor Safety. - Benjamin Franklin

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

2007-01-02 Thread Geoffrey
that 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] 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, Geoffrey Those

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

2007-02-23 Thread Geoffrey
? 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 little temporary Safety

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 just *worse

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 and Sparc

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 8 IMHO. When I said 8, I

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's not a good idea

Re: [PERFORM] SCSI vs SATA

2007-04-06 Thread Geoffrey
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 a little temporary Safety

Re: [PERFORM] SCSI vs SATA

2007-04-06 Thread Geoffrey
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 Liberty, to purchase a little

[PERFORM] more on high load on postgres 7.4.16

2007-04-06 Thread Geoffrey
/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 ---(end

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 seeing