Re: Slow insert performace, 8.3 Wal related? - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: Slow insert performace, 8.3 Wal related?
Date
Msg-id 200901130810.21115@hal.medialogik.com
Whole thread Raw
In response to Re: Slow insert performace, 8.3 Wal related?  (Bill Preston <billpreston@crownepointe.net>)
Responses Re: Slow insert performace, 8.3 Wal related?  (Bill Preston <billpreston@crownepointe.net>)
List pgsql-performance
On Monday 12 January 2009, Bill Preston <billpreston@crownepointe.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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Next
From: Jeff Frost
Date:
Subject: strange index behaviour with different statistics target