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

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 (view raw or flat)
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

pgsql-performance by date

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

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