Re: MySQL is faster than PgSQL but a large margin in - Mailing list pgsql-performance

From Vivek Khera
Subject Re: MySQL is faster than PgSQL but a large margin in
Date
Msg-id A02A5B37-A959-4AE3-8A53-95462F72F5F6@khera.org
Whole thread Raw
In response to Re: MySQL is faster than PgSQL but a large margin in  (Juan Casero <caseroj@comcast.net>)
List pgsql-performance
On Dec 22, 2005, at 9:44 PM, Juan Casero wrote:

> Agreed.  I have a 13 million row table that gets a 100,000 new
> records every
> week.   There are six indexes on this table.   Right about the time
> when it

i have some rather large tables that grow much faster than this (~1
million per day on a table with > 200m rows) and a few indexes.
there is no such slowness I see.

do you really need all those indexes?


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Order by behaviour
Next
From: Vivek Khera
Date:
Subject: Re: What's the best hardver for PostgreSQL 8.1?