Re: [PERFORM] Visual Explain

2004-06-17 Thread Adam Witney
Will this run on other platforms? OSX maybe? I've known about this tool for a while, but it seems many people do not know of its existence and I think it would be useful to a lot of people who have a hard time reading explain analyze output. (And even those who can read them without

Re: [PERFORM] Visual Explain

2004-06-17 Thread Paul Thomas
On 17/06/2004 12:10 Adam Witney wrote: Will this run on other platforms? OSX maybe? It's a Java app so it runs on any any platform with a reasonably modern Java VM. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited |

Re: [PERFORM] Visual Explain

2004-06-17 Thread Jeff
On Jun 17, 2004, at 7:10 AM, Adam Witney wrote: Will this run on other platforms? OSX maybe? I've run it on both linux (rh8) and osx (panther). its java so it *should* run anywhere. It isn't the fastest beast in the world though. takes a bit of time to render the plan. -- Jeff Trout [EMAIL

Re: [PERFORM] Visual Explain

2004-06-17 Thread Vitaly Belman
Is it possible to download the Visual Explain only (link)? I only see that you can donwload the whole ISO (which I hardly need). On Thu, 17 Jun 2004 13:52:15 +0100, Paul Thomas [EMAIL PROTECTED] wrote: On 17/06/2004 12:10 Adam Witney wrote: Will this run on other platforms? OSX maybe?

Re: [PERFORM] Visual Explain

2004-06-17 Thread Vitaly Belman
I see. Thanks :). On Thu, 17 Jun 2004 18:35:11 +0100, Paul Thomas [EMAIL PROTECTED] wrote: On 17/06/2004 17:54 Vitaly Belman wrote: Is it possible to download the Visual Explain only (link)? I only see that you can donwload the whole ISO (which I hardly need). You can get it from CVS

[PERFORM] Slow vacuum performance

2004-06-17 Thread Patrick Hatcher
Pg: 7.4.2 RedHat 7.3 Ram: 8gig I have 6 million row table that I vacuum full analyze each night. The time seems to be streching out further and further as I add more rows. I read the archives and Josh's annotated pg.conf guide that setting the FSM higher might help. Currently, my memory