Re: Dealing with big tables

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: Mindaugas <ml(at)kilimas(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Dealing with big tables
Date: 2007-12-02 11:55:34
Message-ID: 1d4e0c10712020355j133e0d31n653a531da1834c80@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Dec 2, 2007 11:26 AM, Mindaugas <ml(at)kilimas(dot)com> wrote:
> I execute simple query "select * from bigtable where From='something'". Query returns like 1000 rows and takes 5++ seconds to complete. As far as I understand the query is slow because:

Can you post an EXPLAIN ANALYZE? Which version of PostgreSQL do you use?

--
Guillaume

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-12-02 12:07:37 Re: Dealing with big tables
Previous Message Mindaugas 2007-12-02 11:37:56 Re: Dealing with big tables