Re: Updates, deletes and inserts are very slow. What can I do make them bearable?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Gary Chambers <gwchamb(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Updates, deletes and inserts are very slow. What can I do make them bearable?
Date: 2010-10-21 03:52:51
Message-ID: AANLkTim0tmx3AHe+kMFKdj4Vegwh2VMSA6Ms3kASE-z4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

To follow up...

I did a full vacuum analyze on both tables and re-ran the query. Same
story. I ended the query after eight minutes.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vishnu S. 2010-10-21 04:04:31 How to Rejoin a Node after failover [Postgre SQL replication using Slony-I]
Previous Message Tom Lane 2010-10-21 03:50:57 Re: Cannot Start Postgres After System Boot