--- Stephen Frost <[EMAIL PROTECTED]> wrote:
> (perhaps a
> pastebin like http://pgsql.privatepaste.com) instead of or in addition
> to sending it in the email.
It this new? I don't remember seeing this used before.
Regards,
Richard Broersma Jr.
---(end of broadcast)
Stephen Frost wrote:
> * Jeff Frost ([EMAIL PROTECTED]) wrote:
> > Here are the plans:
>
> It's probably just me but, honestly, I find it terribly frustrating to
> try and read a line-wrapped explain-analyze output... I realize it
> might not be something you can control in your mailer, but you m
On Sat, 6 Oct 2007, Tom Lane wrote:
"Jeff Frost" <[EMAIL PROTECTED]> writes:
Before analyze it seems to choose Bitmap Heap Scan on episodes
current_episode, but after it chooses Index Scan Backward using
index_episodes_on_publish_on on episodes current_episode.
Have you tried raising the stat
"Jeff Frost" <[EMAIL PROTECTED]> writes:
> Before analyze it seems to choose Bitmap Heap Scan on episodes
> current_episode, but after it chooses Index Scan Backward using
> index_episodes_on_publish_on on episodes current_episode.
Have you tried raising the stats target for "episodes"? Seems lik
On Fri, 5 Oct 2007, Stephen Frost wrote:
* Jeff Frost ([EMAIL PROTECTED]) wrote:
Here are the plans:
It's probably just me but, honestly, I find it terribly frustrating to
try and read a line-wrapped explain-analyze output... I realize it
might not be something you can control in your mailer
On 10/5/07, Stephen Frost <[EMAIL PROTECTED]> wrote:
> ... (perhaps a pastebin like http://pgsql.privatepaste.com) ...
This is cool.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index
* Jeff Frost ([EMAIL PROTECTED]) wrote:
> Here are the plans:
It's probably just me but, honestly, I find it terribly frustrating to
try and read a line-wrapped explain-analyze output... I realize it
might not be something you can control in your mailer, but you might
consider putting the various
