> 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@xxxxxxxxx> wrote: > On Friday 26 June 2009, Brian Troutwine <goofyheadedpunk@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
