Christophe Musielak <[EMAIL PROTECTED]> writes:
>-> Seq Scan on threads t
> (cost=0.00..19431.23
> rows=82667 width=583)
> Filter: (((mailbox_id = 2) OR
> (mailbox_id
> = 3) OR (mailbox_id = 5) OR (mailbox_id = 20) OR (mailbox_id = 21)
Just to cover the ovbious solution ...
How often do you run "vacuum analyze" on this database? If the data has been
around for a long time, have you considered using CLUSTER to physically reorder
the tables?
Christophe Musielak <[EMAIL PROTECTED]> wrote:
> Hi,
>
> We're working since 4 years on
Christophe Musielak wrote:
Hi,
We're working since 4 years on Postgres for a e-crm web based
application that deals with emails.
A few immediate observations:
1. Try not to reply to an existing message when posting a new question,
it can mess up threaded views.
2. The performance list is probably
