. This is not
sophisticated box - about 3 yr old, 2Mbytes RAM.
- Miles
Date: Wed, 18 Mar 2009 12:53:45 -0700
Subject: Performance Spamassin PostgreSQL vs MySQL
From: mussa...@csz.com
To: mysql@lists.mysql.com
We are using the PostgreSQL currently to store the Bayes information. It
seems to periodically spend
actually tested the
PostgreSQL vs MySQL versions. We are currently running a uniprocessor
system (Linux version 2.6.18-6-vserver-amd64 (Debian 2.6.18.dfsg.1-24).
System appears disk limited, we have the files on hardware raid 0 and have
moved nearly everything else off that set (they are the fastest
We are using the PostgreSQL currently to store the Bayes information. It
seems to periodically spend a lot of time 'vacumming' which of course
drives up disk load. The system admin has adjusted it so it only does
this at low load. I'm curious if anyone has actually tested the
PostgreSQL vs
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
the package which
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer
Hello List:
I hope my question does not start war of the posts. This question is
genuine. Please answer objectively:
I am test setting a Master Server (MS) with CentOS 4.3, freeRADIUS, DNS,
Apache, (mySQL PostgreeSQL), PHP, Postfix, etc. This Master Server will
have all the software I we
stable where I will switch over fully to MySQL
Rob
stone.wang wrote:
How do you think about PostgreSQL and mysql? want to know which is good? How to
choose database for the web?
--
Reclaim Your Inbox!
http://www.mozilla.org/products/thunderbird
--
MySQL General Mailing List
For list
Hi Stone,
if you ask me which is bettet your car or mine, i'll answer mine.
Your question can't be answered here because it's not technical but political.
Better close this thread.
Mathias
Selon stone.wang [EMAIL PROTECTED]:
How do you think about PostgreSQL and mysql? want to know which
Does any one know how PostgreSQL compares to MySQL regarding stability
and maintenance?
I have been using MySQL for about two years, and it has proved to be
very stable and requires almost zero maintenance.
FB
Hi Stony,
I didn't use PostgreSQL before, so couldn't comment. For MySQL, you
Félix Beltrán wrote:
Does any one know how PostgreSQL compares to MySQL regarding stability
and maintenance?
I have been using MySQL for about two years, and it has proved to be
very stable and requires almost zero maintenance.
It really depends on what you are using it for. Stability
As previously posted to this list.
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
On 6/24/05, stone.wang [EMAIL PROTECTED] wrote:
How do you think about PostgreSQL and mysql? want to know which is good? How
to choose database for the web?
--
MySQL General
How do you think about PostgreSQL and mysql? want to know which is good? How to
choose database for the web?
PostgreSQL and mysql? want to know which is good?
How to choose database for the web?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:24 +0800, Patrick Hsieh wrote:
I am planing to transfer data from postgresql to mysql. Is there any
useful tools, scripts or utilities to achieve this?
pg_dump
First dump the schema, edit that until you have something MySQL
understands. Then dump the data using the -d option so you
now I managed to dump table schema with pg_dump. However,
is there any schema converting tool available? I don't want to edit
each table schema to make it mysql-compliant.
Download yourself a trial of Database Workbench
at www.upscene.com
It has a Schema Migrator tool that allows you to
Hello list,
I am planing to transfer data from postgresql to mysql. Is there any
useful tools, scripts or utilities to achieve this? Any infomation is
highly appreciated!
---
Patrick Hsieh() [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED] | ICQ: 97133580
Skype: pahud_at_pahud.net | YIM: pahudnet
On Mon, 18 Oct 2004 18:08:24 +0800, Patrick Hsieh wrote:
I am planing to transfer data from postgresql to mysql. Is there any
useful tools, scripts or utilities to achieve this?
pg_dump
First dump the schema, edit that until you have something MySQL
understands. Then dump the data using
:
I am planing to transfer data from postgresql to
mysql. Is there any
useful tools, scripts or utilities to achieve
this?
pg_dump
First dump the schema, edit that until you have
something MySQL
understands. Then dump the data using the -d option
so you have full
inserts instead
On Tue, 10 Aug 2004 23:40:39 +0200
Jochem van Dieten [EMAIL PROTECTED] wrote:
On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Well, since you admitted to being a newbie, I would suggest that
you learn with MySQL. It supports several types of data storage
On Tue, 10 Aug 2004 23:34:49 +0200
Jochem van Dieten [EMAIL PROTECTED] wrote:
On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
One area where MySQL beat Postgres is in Windows installation.
Installing postgres on Windohs is like pulling your fingernails
off slowly.
It is more
On Wed, 11 Aug 2004 10:00:32 -0500, Josh Trutwin wrote:
On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten wrote:
On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
MySQL's command line interface and programming API also are nicer
for newer users. Why in the world do I need to
Hi all, mr.super newbie here, what is the best for cold fusion development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
EWAGW wrote:
Hi all, mr.super newbie here, what is the best for cold fusion development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
No need for flames. I think the two are converging.
PostgreSQL started out with a
On Tue, 10 Aug 2004 15:35:20 -0500, EWAGW [EMAIL PROTECTED] wrote:
Hi all, mr.super newbie here, what is the best for cold fusion development?
The best depends on the requirements. You have not told us any
requirements, except that you work with ColdFusion. If that is
*really* the only
3:45 PM
Subject: Re: Difference between PostgreSQL and MySQL
EWAGW wrote:
Hi all, mr.super newbie here, what is the best for cold fusion
development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
No need
Well, since you admitted to being a newbie, I would suggest that you learn
with MySQL. It supports several types of data storage (memory only, ISAM,
full-relational) and both transacted and non-transacted execution models.
That's just about everything you could want a database to do.
On Tue, 10 Aug 2004 16:45:29 -0400
Brad Tilley [EMAIL PROTECTED] wrote:
No need for flames. I think the two are converging.
One area where MySQL beat Postgres is in Windows installation. Installing postgres on
Windohs is like pulling your fingernails off slowly. I hear they are close to full
Subject: Re: Difference between PostgreSQL and MySQL
Well, since you admitted to being a newbie, I would suggest that you learn
with MySQL. It supports several types of data storage (memory only, ISAM,
full-relational) and both transacted and non-transacted execution models.
Ehm
No need for flames. I think the two are converging.
One area where MySQL beat Postgres is in Windows installation. Installing
postgres on Windohs is like pulling your fingernails off slowly. I hear
they are close to full Windows support though in the 8.x branch.
FYI:
Thanks a lot Shawn, Josh and Brad for your great advice. The command line
interface you talk about is that in MySQL administrator?
MySQL's command line interface and programming API also are nicer for newer
users. Why in the world do I need to remember to type \d to show my
tables?
That
Thank Jochem as well interesting reply got me thinking
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 3:51 PM
Subject: Re: Difference between PostgreSQL and MySQL
On Tue, 10 Aug 2004 15:35:20 -0500, EWAGW [EMAIL
.
I hear they are close to full Windows support though in the 8.x branch.
The current BETA offers identical features on Windows and Linux. But
don't use beta software in production (neither PostgreSQL nor MySQL).
MySQL's command line interface and programming API also are nicer for newer users
On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Well, since you admitted to being a newbie, I would suggest that you learn
with MySQL. It supports several types of data storage (memory only, ISAM,
full-relational) and both transacted and non-transacted execution
Thanks Emmett and Martijn!!
- Original Message -
From: EWAGW [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 4:31 PM
Subject: Re: Difference between PostgreSQL and MySQL
Thank Jochem as well interesting reply got me thinking
- Original Message
At 03:35 PM 8/10/2004, you wrote:
Hi all, mr.super newbie here, what is the best for cold fusion development?
I know that NASA uses MySQL but I have also been told that more
'professionals'(???) use PostgreSQL. Let the flaming begin!!
One thing that wasn't mentioned is MySQL requires a license
Foundation or a lawyer as appropriate.
Lachlan
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 11 August 2004 7:58 AM
To: [EMAIL PROTECTED]
Subject: Re: Difference between PostgreSQL and MySQL
At 03:35 PM 8/10/2004, you wrote:
Hi all, mr.super newbie here, what
Hi.
Could you please stop to post your message repeatedly with only some
minutes in between?
I never used INTERSECT, so I don't know... does it do anything a
normal join doesn't? Like
SELECT *
FROM table1 t1, table2 t2, table3 t3
WHERE t1.id=t2.id AND t2.id=t3.id
Bye,
Benjamin.
sorry guys, it isn't intended to post a message
repeatedly. Yahoo keeps telling me that the message
was not delievered due to some sort of size problem.
Anyway, I'm still seeking a solution to my problem and
would appreciate any of your help. Thanks
--- Benjamin Pflugmann [EMAIL PROTECTED]
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java
Hello,
I was wondering if anybody new of any articles out there that benchmarked
mysql and postgresql recently.I have a few that have favored and have
not seen any other ones that favor mysql accept for the benchmarks on the
mysql website
Thanks
Randy
Hi Jani and Owen,
Owen if you are dumping the data using pg_dump, I think I may be
able to help. First suggestion is to dump the data and the data
schema separetly. use,
for schema: pg_dump -sxnc -f/tmp/schema.dump databasename
for data: pg_dump -qxnd -f/tmp/data.dump databasename
The data
To whom ever can help:
I have a database dumped from PostgreSQL to a text file , is there any
method used to convert this to MySQL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
[EMAIL PROTECTED] writes:
To whom ever can help:
I have a database dumped from PostgreSQL to a text file , is there any
method used to convert this to MySQL?
Yes, please use mysqlimport. See mysqlimport --help for information,
more detailed information can be found from the MySQL
46 matches
Mail list logo