Re: Another weird one with an UPDATE

From: David Griffiths <dgriffiths(at)boats(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Another weird one with an UPDATE
Date: 2003-10-13 19:04:18
Message-ID: 012b01c391bc$d06e6200$6501a8c0@griffiths2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> And what about commercial_entity.user_account_id. Is it indexed and what
> is its data type (i.e. does it match numeric(10,0))?

Yup - all columns in the statement are indexed, and they are all
numeric(10,0).

> Also, have you run VACUUM ANALYZE lately?

Yup - just before the last run.

Will get together my tuning data now.

David

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sean Chittenden 2003-10-13 19:04:46 Re: go for a script! / ex: PostgreSQL vs. MySQL
Previous Message James Rogers 2003-10-13 18:43:43 Re: One or more processor ?