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
ar
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
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 s
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-ti
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 th
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 o
> 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
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. For
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
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.
> ==start==
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 on
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 s
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
--
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
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 expe
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 bro
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 shar
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 get
Hi,
I was reading a lot on the specs that was used by those who runs
postgres. I was wondering is the a more structured method of
determining what is the required hardware specs? The project that i am
doing can populate about few millions records a day (worst case).
Based on what i read, this
I recommend IBM equipment, but in the spirit of caveat emptor I should let
you know I work for IBM... :-)
Seriously, I've been using IBM laptops and desktops for about 5 years, even
before I started working for them. They tend to be a little more expensive
than Dell, but I think they use bee
--- Shridhar Daithankar <__> wrote:
> 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
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 on 1850s
> and 28
Brian Hirt <[EMAIL PROTECTED]> writes:
> it's more like:
> declare
> foo_date date;
> begin
> select some_date into foo_date from some_table where something =
> something_else;
> select blah from redir_log where redir_timestamp >= foo_date::timestamp
> without time zone at time
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 people,
On Dec 1, 2004, at 1:06 PM, Tom Lane wrote:
That seems like the hard way to express a timestamp constant. Why not
I realized after i sent this message that i might get this responese. I should have mentioned this was from within a stored pl/pgsql function, and the date wasn't a constant, but a
Brian Hirt wrote:
I have a query that fetches information from a log, based on an indexed
column. The timestamp in the table is with time zone, and the server
time zone is not GMT. However, i want all of the timestamps for a
particular day in GMT. If i simply use a date constant, the inde
I have a query that fetches information from a log, based on an indexed column. The timestamp in the table is with time zone, and the server time zone is not GMT. However, i want all of the timestamps for a particular day in GMT. If i simply use a date constant, the index is used, but the incor
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
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 thinking that even with a
> better server, the re
Just as an update, We installed RHE Update4 beta kernel on a box and it
seems to have solved our issues.
Woody
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3550 x813
www.iglass.net
---(end of broadcast)--
Hi!
I am using PostgreSQL with a proprietary ERP software in Brazil. The
database have around 1.600 tables (each one with +/- 50 columns).
My problem now is the time that takes to restore a dump. My customer
database have arount 500mb (on the disk, not the dump file) and I am
making the dump wit
On Wed, 2004-12-01 at 15:03 +0900, Hyun-Sung, Jang wrote:
>
> < lots of information about seq scan vs index scan >
>
Hi,
Just because it has an ID that is the largest in the set, does not mean
it will be at the last position in the on-disk tables. And similarly,
the lowest numbered ID does not
From: "BBI Edwin Punzalan" <[EMAIL PROTECTED]>
> Thanks but whatever it does, it didn't work. :
> Do you think upgrading will fix this problem?
are you sure there is a problem here to solve ?
> Seq Scan on chatlogs (cost=0.00..27252.86 rows=271882 width=212) (actual
> time=12.24..13419.36 row
33 matches
Mail list logo
