Re: MySQL is faster than PgSQL but a large margin in

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: MySQL is faster than PgSQL but a large margin in
Date: 2005-12-23 16:16:14
Message-ID: A02A5B37-A959-4AE3-8A53-95462F72F5F6@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2005-12-23 16:23:28 Re: What's the best hardver for PostgreSQL 8.1?
Previous Message Tom Lane 2005-12-23 15:54:48 Re: Order by behaviour