Re: [GENERAL] [PERFORM] pg_restore taking 4 hours!

2004-12-01 Thread Tom Lane
Shridhar Daithankar [EMAIL PROTECTED] writes: On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote: I need to find a solution for this because I am convincing customers that are using SQL Server, DB2 and Oracle to change to PostgreSQL but this customers have databases of 5GB!!! I am

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Matthew Marlowe
Josh, Steve: I have also been looking at non-dell server vendors due to recent concerns about the PERC RAID Controllers. That said, I believe IBM just shoots itself in the foot via its sales/pricing practices Price out a PE2850 w/ 8GB RAM and 6 18GB Drives on the Dell website and you'll

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
Matthew Marlowe wrote: I just don't think IBM makes it easy for new customers to buy their equipment and if I went with them, I'd always have the lingering suspicion that I was paying too much. I really hope they change some day... Until then, I just see Dell winning more of the server market

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Iain
I always say 'If you pay for quality it only hurts once', but then again I don't equate high price with high quality ;-) - Original Message - From: Geoffrey [EMAIL PROTECTED] Something to be said for the old saying, 'you get what you pay for.' ---(end of

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Joshua D. Drake
Thing is, some companies are required to use 1st-tier or at least 2nd-tier vendors for hardware; they won't home-build. For those people, what vendors do others on this list recommend? What have been your good/bad experiences? Well this is almost as bad as vi/emacs ;) but I have had good

Re: [PERFORM] query with timestamp not using index

2004-12-01 Thread Tom Lane
Brian Hirt [EMAIL PROTECTED] writes: select count(*) from redir_log where redir_timestamp = '10/14/2004'::timestamp without time zone at time zone 'GMT'; That seems like the hard way to express a timestamp constant. Why not select count(*) from redir_log where redir_timestamp = '10/14/2004

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 Joshua D. Drake
Go the IBM website, try to find a comparative x86 system and spec it out. The list pricing is in the $12-16K range. Yes, I know I could get a good discount if I developed a relationship with an IBM reseller here..and perhaps the end pricing would be in the $10-12K rangebut the Dell way just

Re: Off-list Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Sven Willenberger
Josh Berkus wrote: Jeff, I'm curious about the problem's you're seeing with Dell servers since we're about to buy some 750s, 2850s and 1850s. The problems I've been dealing with have been on the *650s. They're the ones you name. FYI ... the 750s, 1850s and 2850s use Intel chipsets (E7520

Re: [PERFORM] Using LIMIT is much faster even though, searching

2004-12-01 Thread Josh Berkus
Hyun-Sung, do you need all of verbose information?? VACUUM FULL ANALYZE VERBOSE give me a lot of infomation, so i just cut zipcode parts. Oh, sorry. I meant just VACUUM FULL ANALYZE VERBOSE zipcode, not the whole database. Should have been clearer.

Re: [PERFORM] pg_restore taking 4 hours!

2004-12-01 Thread Josh Berkus
Rodrigo, Our machine it's a Dell Server Power Edge 1600sc (Xeon 2,4Ghz, with 1GB memory, 7200 RPM disk). I don't think that there is a machine problem because it's a server dedicated for the database and the cpu utilization during the restore is around 30%. In addition to Tom and Shridhar's

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
Josh Berkus wrote: Folks, A lot of people have been having a devilish time with Dell hardware lately. It seems like the quality control just isn't there on the Dell servers. Thing is, some companies are required to use 1st-tier or at least 2nd-tier vendors for hardware; they won't home-build.

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Merlin Moncure
Folks, A lot of people have been having a devilish time with Dell hardware lately. It seems like the quality control just isn't there on the Dell servers. Thing is, some companies are required to use 1st-tier or at least 2nd-tier vendors for hardware; they won't home-build. For those

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Mike Rylander
On Wed, 1 Dec 2004 14:24:12 -0800, Josh Berkus [EMAIL PROTECTED] wrote: Folks, A lot of people have been having a devilish time with Dell hardware lately. It seems like the quality control just isn't there on the Dell servers. Which is a shame, because I *still* drool over a rack full of

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Frank Wiles
On Wed, 1 Dec 2004 14:24:12 -0800 Josh Berkus [EMAIL PROTECTED] wrote: Folks, A lot of people have been having a devilish time with Dell hardware lately. It seems like the quality control just isn't there on the Dell servers. I believe I had expressed some problems with Dell in the

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Bruce Momjian
Josh Berkus wrote: Folks, A lot of people have been having a devilish time with Dell hardware lately. It seems like the quality control just isn't there on the Dell servers. Was the quality ever there with Dell? Thing is, some companies are required to use 1st-tier or at least 2nd-tier

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Anjan Dave
Not in my experience for IBM, even for an order approaching 100k. The sales guy was rude, jumping on numbers, unable to talk about exactly what differentiates IBM from Dell (equivalent config) - other than the name and their 20K+ difference. We use many Dell servers, no quality issue, but as

Re: [PERFORM] Alternatives to Dell?

2004-12-01 Thread Geoffrey
Merlin Moncure wrote: For the budget or performance minded I'd suggest checking out SWT servers (http://www.swt.com) ...not sure what tier they fit into but they can get you into a quad Opteron for under 10k$ US, about half what you would pay for a comparable HP server (and Dell doesn't even offer

Re: [PERFORM] Recommended Specs

2004-12-01 Thread Josh Berkus
Hasnul, Hard disks - ?? how do i actually check how much space this records take on the hard drives? optimized queries is a must OS? linux? freebsd? solaris? cpu type? sun sparc? intel? amd? anything else? There have been treads discussing these as well. Work your way through the