Re: Dealing with big tables - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: Dealing with big tables
Date
Msg-id 1d4e0c10712020355j133e0d31n653a531da1834c80@mail.gmail.com
Whole thread Raw
In response to Dealing with big tables  ("Mindaugas" <ml@kilimas.com>)
List pgsql-performance
On Dec 2, 2007 11:26 AM, Mindaugas <ml@kilimas.com> wrote:
>   I execute simple query "select * from bigtable where From='something'". Query returns like 1000 rows and takes 5++
secondsto 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

pgsql-performance by date:

Previous
From: "Mindaugas"
Date:
Subject: Re: Dealing with big tables
Next
From: Gregory Stark
Date:
Subject: Re: Dealing with big tables