Postgres Pro
Downloads
Home   >   mailing lists

Re: Another weird one with an UPDATE - Mailing list pgsql-performance

From David Griffiths
Subject Re: Another weird one with an UPDATE
Date
Msg-id 012b01c391bc$d06e6200$6501a8c0@griffiths2
Whole thread Raw
In response to Another weird one with an UPDATE  (David Griffiths <dgriffiths@boats.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: James Rogers
Date:
Subject: Re: One or more processor ?
Next
From: Sean Chittenden
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL