Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to figure out why these queries are so slow - Mailing list pgsql-general

From Thom Brown
Subject Re: Trying to figure out why these queries are so slow
Date
Msg-id AANLkTikLVKUu9p7g7hk8vVsSP-c4Pchowc=nPZ53-=4z@mail.gmail.com
Whole thread Raw
In response to Trying to figure out why these queries are so slow  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Trying to figure out why these queries are so slow
List pgsql-general
Tree view 
On 5 October 2010 10:20, Tim Uckun <timuckun@gmail.com> wrote:
> The database machine is a linode host.

Good choice ;)

Obvious question, but I'll ask it: Have you run ANALYZE or VACUUM
ANALZYE on the database?  Also being able to see the query plan would
help.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

pgsql-general by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: streaming replication question
Next
From: Tim Uckun
Date:
Subject: Re: Trying to figure out why these queries are so slow