> Indexes are good things. Try them. Particularly on the isbn field.
I'm not sure why amazon_items.isbn should be given an index.
item_details.isbn is used in a WHERE clause and is given an index
accordingly, but not amazon_items.isbn.
Brian
On Fri, Jun 26, 2009 at 12:40 PM, Alan Hodgson<ahodgson@simkin.ca> wrote:
> 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>