Re: Slow insert performace, 8.3 Wal related?

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow insert performace, 8.3 Wal related?
Date: 2009-01-13 16:10:21
Message-ID: 200901130810.21115@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Monday 12 January 2009, Bill Preston <billpreston(at)crownepointe(dot)net>
wrote:
> As to the second example with the delete. There are no foreign keys.
> For the index. If the table has fields a,b,c and d.
> We have a btree index (a,b,c,d)
> and we are saying DELETE FROM table_messed_up WHERE a=x.
>

Is there anything special about this table? Does it have like a hundred
indexes on it or something? Because deleting 8k rows from a normal table
should never take more than a couple of seconds.

--
Alan

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Frost 2009-01-13 22:34:42 strange index behaviour with different statistics target
Previous Message Kevin Grittner 2009-01-13 15:40:35 Re: dbt-2 tuning results with postgresql-8.3.5