On 27/11/2003 08:08 Chris Travers wrote:
Hi;
I am trying to determine if there is anything I can do with MySQL that I
can't do with PostgreSQL. HEAP tables are the last one I can't figure
out.
HEAP tables are MySQL tables which reside in memory and are visible
across
sessions. For obvious reason
Hi;
I am trying to determine if there is anything I can do with MySQL that I
can't do with PostgreSQL. HEAP tables are the last one I can't figure out.
HEAP tables are MySQL tables which reside in memory and are visible across
sessions. For obvious reasons, this violates the D in ACID.
In many
Hi all;Since we are on the
topic of what prompted us to use PostgreSQL, I figured Iwould share my
experiences as well, and some additional thoughts that I had.I chose
PostgreSQL about 2 years ago when I realized that the application Iwas
building needed something more robust than MySQL. I fo
Cross-posted to "comp.databases.postgresql.advocacy" because
PostgreSQL could be very helpful to MySQL DBAs who wish to optimize their
databases -- just convert it to PostgreSQL on a test system and use EXPLAIN
and ANALYZE to identify the weaknesses.
Even if these MySQL DBAs don
How does the performance compare using models mimicked from Oracle? Is
there any information anywhere on that?
Marek Lewczuk wrote:
Użytkownik Robert Treat napisał:
On Tue, 2003-11-25 at 08:07, Marek Lewczuk wrote:
Yes. I think the gist of your post was "out of the box postgresql
performed like
>> I'm curious as to what type of application you run and
what first
>> prompted you to switch to postgresql?
I would like to add my 2 cents to this although I have not
been asked by anyone about this :-)
If I remember correctly the fact about 7 years ago...
when PostgreSQL already supported
-
Użytkownik Robert Treat napisał:
On Tue, 2003-11-25 at 08:07, Marek Lewczuk wrote:
Yes. I think the gist of your post was "out of the box postgresql
performed like garbage compared to mysql, but then i spent some time
tweaking and tuning, taking advantage of indexes, and now it performs so
quickly
Robert Treat wrote:
Yes. I think the gist of your post was "out of the box postgresql
performed like garbage compared to mysql, but then i spent some time
tweaking and tuning, taking advantage of indexes, and now it performs so
quickly that i am unable to make any changes within mysql to match
post
And ofcourse, you ran ANALYZE before doing any timings, right?
On Tue, Nov 25, 2003 at 01:08:55PM +0100, Marek Lewczuk wrote:
> Hello,
> I have changed DB from MySQL to PostgreSQL. When I have run my
> application on PostgreSQL it was disaster - it was much slower than
> MySQL...
>
> I have tri
Użytkownik Martijn van Oosterhout napisał:
And ofcourse, you ran ANALYZE before doing any timings, right?
Of course.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello,
I have changed DB from MySQL to PostgreSQL. When I have run my
application on PostgreSQL it was disaster - it was much slower than
MySQL...
I have tried to change PG configuration file etc.. no luck. After many
long days of thinking what is wrong I have made several tests with
"EXPLAIN"
11 matches
Mail list logo
