On Nov 10, 2006, at 6:35 PM, Nguyen Tam Chinh wrote:
For the pg configuration, I use this on a 4Gb box:
max_connections = 100
shared_buffers = 7 # min 16 or
max_connections*2, 8KB each
work_mem = 262144 # min 64, size in KB
Thank you very much.
On Oct 24, 2006, at 7:27 AM, Vivek Khera wrote:
I believe the front-end application is MySQL dependent, but what
is so much better about PostgreSQL? I understand that it has some
more advanced features, but if they are not used, then what is the
advantage? (I really like the InnooDB storag
On Tue, 24 Oct 2006, Vivek Khera wrote:
On Oct 24, 2006, at 12:27 PM, Nguyen Tam Chinh wrote:
The size of your DB is not all that large. There are people running
terabyte DB's under postgres. Our big DB is around 60Gb with hundreds of
millions of rows spread across dozens of tables which a
On Mon, Oct 23, 2006 at 07:01:38PM -0400, Mike Jakubik wrote:
> Greetings,
>
>I am in the process of implementing a fairly large mysql server for
> an even larger company, and naturally i want to use FreeBSD. The
> hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k
> r
; Cc: Mike Jakubik; [EMAIL PROTECTED]
> > Subject: Re: Running large DB's on FreeBSD
> >
> > On Mon, Oct 23, 2006 at 08:15:04PM -0400, David Magda wrote:
> > > As for Postgres on FreeBSD, FlighAware seems to be using it some
> some
> > > decent amount of dat
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-freebsd-
> [EMAIL PROTECTED] On Behalf Of Jim C. Nasby
> Sent: Friday, October 27, 2006 12:44 AM
> To: David Magda
> Cc: Mike Jakubik; [EMAIL PROTECTED]
> Subject: Re: Running large DB's on FreeBSD
>
On Mon, Oct 23, 2006 at 08:15:04PM -0400, David Magda wrote:
> As for Postgres on FreeBSD, FlighAware seems to be using it some some
> decent amount of data:
>
> >. Receiving the data and processing it puts them about 6 minutes
> >behind real time
> >. Generating one map can be done in about 1
EMAIL PROTECTED] On Behalf Of Kirk Strauser
> Sent: Wednesday, October 25, 2006 2:00 PM
> To: freebsd-stable@freebsd.org
> Subject: Re: Running large DB's on FreeBSD
>
> On Monday 23 October 2006 6:01 pm, Mike Jakubik wrote:
>
> > I'm not exactly informed as
On Monday 23 October 2006 6:01 pm, Mike Jakubik wrote:
> I'm not exactly informed as to the specific workload yet, however i know
> the database will have several million rows and be larger than 10GB.
No offense, but that's a pretty small database. Also, IMHO the crazy part
is using MySQL over
On Tue, 24 Oct 2006, Patrick M. Hausen wrote:
> Hello!
>
> On Mon, Oct 23, 2006 at 04:10:19PM -0700, Chuck Swiger wrote:
>
> > As for the disk configuration, using RAID-5 is one of the worst
> > possible choices for a database; using multiple RAID-1 mirrors or a
> > RAID-10 config would probably d
On Oct 24, 2006, at 12:27 PM, Nguyen Tam Chinh wrote:
The size of your DB is not all that large. There are people
running terabyte DB's under postgres. Our big DB is around 60Gb
with hundreds of millions of rows spread across dozens of tables
which are regularly joined with each other fo
On Tue, 24 Oct 2006, Vivek Khera wrote:
On Oct 23, 2006, at 7:01 PM, Mike Jakubik wrote:
So, first of all, am i crazy for choosing fbsd+mysql for this rather than
something like Solaris + Oracle? :) Secondly, i am just looking for some
suggestions, opinions, success/failure story's that ma
On Oct 23, 2006, at 7:01 PM, Mike Jakubik wrote:
So, first of all, am i crazy for choosing fbsd+mysql for this
rather than something like Solaris + Oracle? :) Secondly, i am just
looking for some suggestions, opinions, success/failure story's
that may help me out. Is anyone out there us
On Mon, Oct 23, 2006, Mike Jakubik wrote:
>I am in the process of implementing a fairly large mysql server for
> an even larger company, and naturally i want to use FreeBSD. The
> hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k
> rpm disks in a RAID5 setup. I'm not
On Oct 23, 2006, at 7:44 PM, Mike Jakubik wrote:
I believe the front-end application is MySQL dependent, but what is
so much better about PostgreSQL? I understand that it has some more
advanced features, but if they are not used, then what is the
advantage? (I really like the InnooDB stora
Mike Jakubik wrote:
> I am in the process of implementing a fairly large mysql server for
> an even larger company, and naturally i want to use FreeBSD. The
> hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k
> rpm disks in a RAID5 setup. I'm not exactly informed a
Hello!
On Mon, Oct 23, 2006 at 04:10:19PM -0700, Chuck Swiger wrote:
> As for the disk configuration, using RAID-5 is one of the worst
> possible choices for a database; using multiple RAID-1 mirrors or a
> RAID-10 config would probably do a lot better in terms of performance
> and reliabil
[ Replying offlist as pretty much all my points have already been said
by others, so I'm just trying to help reinforce what others have said ]
On Mon, 2006-10-23 at 19:01 -0400, Mike Jakubik wrote:
> I am in the process of implementing a fairly large mysql server for
> an even larger company,
On Tue, 2006-Oct-24 02:21:06 +0200, Ronald Klop wrote:
>>On Oct 23, 2006, at 4:44 PM, Mike Jakubik wrote:
>>>advanced features, but if they are not used, then what is the
>>>advantage? (I really like the InnooDB storage in MySQL)
One nice thing about MySQL is the plethora of backends - you can
p
I am in the process of implementing a fairly large mysql server for
an even larger company, and naturally i want to use FreeBSD. The
hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k
rpm disks in a RAID5 setup. I'm not exactly informed as to the specific
workload yet, ho
On Oct 24, 2006, at 1:09, Bill Moran wrote:
Well, you should be using FreeBSD+PostgreSQL, but that's just my
religion.
Is it religion when it just makes more sense? But I digress.
There are numerous reasons to prefer PostgreSQL over MySQL, a few of
which are:
- It scales well to multiple
>From Mike Jakubik <[EMAIL PROTECTED]>, Mon, Oct 23, 2006 at 07:44:45PM -0400:
> Chuck Swiger wrote:
> >On Oct 23, 2006, at 4:01 PM, Mike Jakubik wrote:
> >> So, first of all, am i crazy for choosing fbsd+mysql for this
> >>rather than something like Solaris + Oracle? :)
> >
> >Moderately...it k
On Mon, 23 Oct 2006, Bill Moran wrote:
Mike Jakubik <[EMAIL PROTECTED]> wrote:
I am in the process of implementing a fairly large mysql server for
an even larger company, and naturally i want to use FreeBSD. The
hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k
rpm d
On Tue, 24 Oct 2006 02:00:22 +0200, Chuck Swiger <[EMAIL PROTECTED]> wrote:
On Oct 23, 2006, at 4:44 PM, Mike Jakubik wrote:
Moderately...it kinda depends on the budget available. I regard
Solaris + Oracle as one of the most reliable combinations for moderate
to extreme load, for a system t
On Oct 23, 2006, at 19:10, Chuck Swiger wrote:
Moderately...it kinda depends on the budget available. I regard
Solaris + Oracle as one of the most reliable combinations for
moderate to extreme load, for a system that might well be in
operation for five to ten years. If I was going to do
On Oct 23, 2006, at 4:44 PM, Mike Jakubik wrote:
Moderately...it kinda depends on the budget available. I regard
Solaris + Oracle as one of the most reliable combinations for
moderate to extreme load, for a system that might well be in
operation for five to ten years. If I was going to do
Ronald Klop wrote:
I'm running MySQL 5 on Linux at my work (4 disk RAID 10/32G
RAM/4xsingle-core). It has a DB of > 100 GB and much more than
millions of rows and the preformance is very good with quite a lot of
users via the webserver. But I do not have any comparisons with Oracle
or other sy
Chuck Swiger wrote:
On Oct 23, 2006, at 4:01 PM, Mike Jakubik wrote:
So, first of all, am i crazy for choosing fbsd+mysql for this
rather than something like Solaris + Oracle? :)
Moderately...it kinda depends on the budget available. I regard
Solaris + Oracle as one of the most reliable c
On Tue, 24 Oct 2006 01:01:38 +0200, Mike Jakubik <[EMAIL PROTECTED]> wrote:
Greetings,
I am in the process of implementing a fairly large mysql server for
an even larger company, and naturally i want to use FreeBSD. The
hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7
On Oct 23, 2006, at 4:01 PM, Mike Jakubik wrote:
I am in the process of implementing a fairly large mysql server
for an even larger company, and naturally i want to use FreeBSD.
The hardware will be an HP DL385, 2 x dual-core Opterons, 16GB
RAM, 7 x 15k rpm disks in a RAID5 setup. I'm not
Mike Jakubik <[EMAIL PROTECTED]> wrote:
>
> I am in the process of implementing a fairly large mysql server for
> an even larger company, and naturally i want to use FreeBSD. The
> hardware will be an HP DL385, 2 x dual-core Opterons, 16GB RAM, 7 x 15k
> rpm disks in a RAID5 setup.
Genera
31 matches
Mail list logo
