Re: what's going on here? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: what's going on here?
Date
Msg-id Pine.BSF.4.21.0103091217570.81537-100000@megazone23.bigpanda.com
Whole thread Raw
In response to what's going on here?  (Ben <bench@silentmedia.com>)
Responses Re: what's going on here?
List pgsql-general
Has vacuum analyze been run on both recently?  What is the maximum number
of rows with a particular stream value, and how many does each of 1 and 2
actually have?

> Interestingly, the sequential scan on playlist claims to be returning 2000
> results for stream=1 and only 200 for stream=2. I'm not sure which part of
> the where clause this guess comes from, because the playlist table has
> equal numbers of entries for both streams.



pgsql-general by date:

Previous
From: Ben
Date:
Subject: what's going on here?
Next
From: Ben
Date:
Subject: Re: what's going on here?