> 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
> Elwood Cordery
> Rockwell Collins
> Contract Software Engineer
you've been using PGSQL for almost 3 months now. do
*you* think it is slow for your application and
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?
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-novice by date
|Next:||From: Greg Sabino Mullane||Date: 2006-03-24 02:50:08|
|Subject: Re: Bytea and perl|
|Previous:||From: Sean Davis||Date: 2006-03-23 21:24:09|
|Subject: Re: foreign key data type dereferencing|