On Thu, 17 Jun 2004, Patrick Hatcher wrote:
> 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
You could try to run normal (non full) vacuum every hour or so. If you do
normal vacuum often enou
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 se
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 fr
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 and build it yourself.
--
Paul Thomas
+--+---
On Jun 17, 2004, at 12:54 PM, 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'll need to snag it out of cvs:
http://sources.redhat.com/rhdb/cvs.html
You can checkout just visual explain so you
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 m
> Was that 15% before or after updating from CVS?
>
> The more I think about the looping aspect the less I like it, so I'd
> prefer not to pursue making the unlock change for real. But if it's
> really a 15% win then maybe we need to...
>
> regards, tom lane
After. So far
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 PROTE
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 | Softwar
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 blink
10 matches
Mail list logo
