Re: Are indexes blown?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Shashank Tripathi" <shanx(at)shanx(dot)com>
Cc: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>, "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Are indexes blown?
Date: 2008-02-16 20:20:01
Message-ID: e373d31e0802161220w52dc8c11w5b01f9e498eca6e5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 17/02/2008, Shashank Tripathi <shanx(at)shanx(dot)com> wrote:
> On 17/02/2008, Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com> wrote:
> > On 17/02/2008, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2008-02-16 20:31:29 Re: Are indexes blown?
Previous Message Phoenix Kiula 2008-02-16 19:55:17 Re: Are indexes blown?