Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL a slow DB?

From: <operationsengineer1(at)yahoo(dot)com>
To: ebcorder(at)rockwellcollins(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL a slow DB?
Date: 2006-03-23 22:14:51
Message-ID: 20060323221452.85671.qmail@web33305.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> Hi All
> 
> I started using PostgreSQL\Postgis in January.   
> Lately I have been
> reading on the internet many rumblings about
> PostgreSQL being slower than
> MySQL/SQLLite etc etc.  Comparisons made were
> routine inserts , updates,
> and deletes.   Is any of this true?   If so,are
> there methods to speed
> things up?    I used the Explain Analyze command on
> portgesSQL it seemed
> fast although I have not run any other DB's.
> I know when comparison tests are performed they can
> be tilted on these
> internet sites.  But I see so many people declaring
> PostgreSQL to be the
> slowest I am thinking where there is smoke there's
> fire.
> 
> 
> Elwood Cordery
> Rockwell Collins
> Contract Software Engineer
> 319-295-8248

you've been using PGSQL for almost 3 months now.  do
*you* think it is slow for your application and
hardware?

for my intranet application, pgsql is blazing fast -
at least with several hundred rows and complex
selects.  the data will grow over time, however, it
isn't like i have 2 million rows, but i do have some
reasonably advanced selects (or so it seems to me!).

mysql has a reputation for being slightly faster for
simple tasks.  i'm not sure how true that is now that
they have stapled on a lot of advanced db features
that postgresql had integrated from the beginning.

did you see that sony online entertainment chose
postgresql for their gaming site?

http://www.enterprisedb.com/news_events/press_releases/03_20_06b.do

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

Responses

pgsql-novice by date

Next:From: Greg Sabino MullaneDate: 2006-03-24 02:50:08
Subject: Re: Bytea and perl
Previous:From: Sean DavisDate: 2006-03-23 21:24:09
Subject: Re: foreign key data type dereferencing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group