| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Terrible Write Performance of a Stored Procedure |
| Date: | 2009-06-26 19:40:32 |
| Message-ID: | 200906261240.32580@hal.medialogik.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Friday 26 June 2009, Brian Troutwine <goofyheadedpunk(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2009-06-26 19:48:46 | Re: Terrible Write Performance of a Stored Procedure |
| Previous Message | Pedro Doria Meunier | 2009-06-26 19:37:37 | Re: Postgresql 8.3.7 SSL support |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2009-06-26 19:48:46 | Re: Terrible Write Performance of a Stored Procedure |
| Previous Message | Brian Troutwine | 2009-06-26 19:30:40 | Terrible Write Performance of a Stored Procedure |
