Re: Terrible Write Performance of a Stored Procedure - Mailing list pgsql-performance

On Friday 26 June 2009, Brian Troutwine <goofyheadedpunk@gmail.com> wrote:
>  CREATE TABLE amazon_items (
>         asin         char(10) PRIMARY KEY,
>         locale       varchar(10) NOT NULL DEFAULT 'US',
>         currency_code char(3) DEFAULT 'USD',
>         isbn         char(13),
>         sales_rank   integer,
>         offers       text,
>         offer_pages  integer DEFAULT 10,
>         offers_last_updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
>         UNIQUE (asin, locale)
>  );
>

Indexes are good things. Try them. Particularly on the isbn field.

--
Overshoot = http://www.theoildrum.com/files/evoltuion_timeline.JPG