Re: Various performance questions - Mailing list pgsql-performance

From Tarhon-Onu Victor
Subject Re: Various performance questions
Date
Msg-id Pine.LNX.4.58.0310271708470.8898@blackblue.iasi.rdsnet.ro
Whole thread Raw
In response to Various performance questions  (Dror Matalon <dror@zapatec.com>)
Responses Re: Various performance questions  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
On Sun, 26 Oct 2003, Dror Matalon wrote:

> Here's the structure of the items table
[snip]
>  pubdate       | timestamp with time zone |
> Indexes:
>     "item_channel_link" btree (channel, link)
>     "item_created" btree (dtstamp)
>     "item_signature" btree (signature)
>     "items_channel_article" btree (channel, articlenumber)
>     "items_channel_tstamp" btree (channel, dtstamp)
>
>
> 5. Any other comments/suggestions on the above setup.

    Try set enable_seqscan = off; set enable_indexscan = on; to
force the planner to use one of the indexes. Analyze the queries from
your application and see what are the most used columns in WHERE clauses
and recreate the indexes. select count(*) from items where channel <
5000; will never use any of the current indexes because none matches
your WHERE clause (channel appears now only in multicolumn indexes).

--
Any views or opinions presented within this e-mail are solely those of
the author and do not necessarily represent those of any company, unless
otherwise expressly stated.

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: Various performance questions
Next
From: Christopher Kings-Lynne
Date:
Subject: Linux Filesystem Shootout