Re: Are indexes blown? - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: Are indexes blown?
Date
Msg-id e373d31e0802161220w52dc8c11w5b01f9e498eca6e5@mail.gmail.com
Whole thread Raw
In response to Are indexes blown?  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: Are indexes blown?
List pgsql-general
On 17/02/2008, Shashank Tripathi <shanx@shanx.com> wrote:
> On 17/02/2008, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote:
> > On 17/02/2008, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> > > ~> top -b -d 1 | awk -f top.awk | tee topdata
> > >
> > > awk: top.awk:24:  for(i=8;i<last;i++
> > > awk: top.awk:24:                    ^ syntax error
> > > awk: top.awk:28:
> > > awk: top.awk:28:  ^ syntax error
> > > awk: top.awk:29:
> > > awk: top.awk:29:    ^ syntax error
> > > awk: top.awk:31:
> > > awk: top.awk:31: ^ syntax error
> > > awk: top.awk:31: }
> > > awk: top.awk:31:  ^ invalid char ' ' in expression
> >
> >
> > > Any ideas?
> > What OS are you on, which version of awk?  Mine
> > works on most current Linux variants with a gawk > 3.x
> > awk -W version
> > GNU Awk 3.1.5
> > Copyright (C) 1989, 1991-2005 Free Software Foundation.
> >
> > Another thought is that maybe when you copy & pasted you
> > got some special characters into the script that awk doesn't
> > like ....
> >
>
>
>
> Thanks. I am on CentOS 4 (Linux) and the awk bit is
>
>     GNU Awk 3.1.3
>     Copyright (C) 1989, 1991-2003 Free Software Foundatio
>
> Do I need to update awk?
>



My question exactly.

Anyway I downloaded the text file that was attached in this thread,
and then it works. Must have been some copy/paste problem as
suggested.

I ran it with this command:

    top -b -d 1 -n 3600 | awk -f top.awk | tee topdata

But this is kind of sitting there, hogging the command prompt. Is
there any way I can let it go on in the background?

Thanks for the awk tip. Looks like a thing I need to learn!

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Re: Are indexes blown?
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Are indexes blown?