On Friday 26 June 2009, Brian Troutwine <goofyheadedp...@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
