Postgres Pro
Downloads
Home   >   mailing lists

Thread: Missing archive entry

Missing archive entry

From
Bruce Momjian
Date:
I did a search for pgbench and Google found the article I was looking
for:


http://groups-beta.google.com/group/pgsql.performance/browse_frm/thread/eafbb7cc58a4afcc/aafb8805c8d13232?q=postgresql+pgbench+lane&_done=%2Fgroups%3Fq%3Dpostgresql+pgbench+lane%26start%3D0%26scoring%3Dd%26hl%3Den%26num%3D30%26c2coff%3D1%26&_doneTitle=Back+to+Search&&d#aafb8805c8d13232

but our own archives search did not:

    http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=pg_bench+&ul=&dp=0&o=0&ps=10&s=date

I did a search for 'pgbench'.  Do we not archive entries from December
20?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Missing archive entry

From
Bruce Momjian
Date:
Bruce Momjian wrote:
> I did a search for pgbench and Google found the article I was looking
> for:
>
>
http://groups-beta.google.com/group/pgsql.performance/browse_frm/thread/eafbb7cc58a4afcc/aafb8805c8d13232?q=postgresql+pgbench+lane&_done=%2Fgroups%3Fq%3Dpostgresql+pgbench+lane%26start%3D0%26scoring%3Dd%26hl%3Den%26num%3D30%26c2coff%3D1%26&_doneTitle=Back+to+Search&&d#aafb8805c8d13232
>
> but our own archives search did not:
>
>     http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=pg_bench+&ul=&dp=0&o=0&ps=10&s=date
>
> I did a search for 'pgbench'.  Do we not archive entries from December
> 20?

FYI, here is the actual entry in our archives that search didn't find:

    http://search.postgresql.org/pgsql-performance/2004-12/msg00256.php

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Missing archive entry

From
Oleg Bartunov
Date:
Bruce,

it's because search engine based on inverted indices doesn't
suited for online updating, even if indices are kept in PG.

This is what we try to overcome in pgsql.ru - all messages are indexed online.
Try

http://www.pgsql.ru/db/mw/index.html?section=-1&word=pgbench&action=Search&sdb_d=23&sdb_m=11&sdb_y=2004&sde_d=23&sde_m=12&sde_y=2004&weight=0&format=0&order=1

     Oleg

On Thu, 23 Dec 2004, Bruce Momjian wrote:

> I did a search for pgbench and Google found the article I was looking
> for:
>
>
http://groups-beta.google.com/group/pgsql.performance/browse_frm/thread/eafbb7cc58a4afcc/aafb8805c8d13232?q=postgresql+pgbench+lane&_done=%2Fgroups%3Fq%3Dpostgresql+pgbench+lane%26start%3D0%26scoring%3Dd%26hl%3Den%26num%3D30%26c2coff%3D1%26&_doneTitle=Back+to+Search&&d#aafb8805c8d13232
>
> but our own archives search did not:
>
>     http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=pg_bench+&ul=&dp=0&o=0&ps=10&s=date
>
> I did a search for 'pgbench'.  Do we not archive entries from December
> 20?
>
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: Missing archive entry

From
Tom Lane
Date:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I did a search for pgbench and Google found the article I was looking
> for:
> but our own archives search did not:

>     http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=pg_bench+&ul=&dp=0&o=0&ps=10&s=date

Possibly if you searched for "pgbench" you would find it.  The URL shows
that you searched for "pg_bench".

(It's also possible that the search indexer is running a little behind.)

            regards, tom lane

Re: Missing archive entry

From
Bruce Momjian
Date:
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I did a search for pgbench and Google found the article I was looking
> > for:
> > but our own archives search did not:
>
> >     http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=pg_bench+&ul=&dp=0&o=0&ps=10&s=date
>
> Possibly if you searched for "pgbench" you would find it.  The URL shows
> that you searched for "pg_bench".

I checked that.  Both pgbench and pg_bench are in the article, and I
tried both.  What bothers me is that 90% of the time I look for
something the archiver doesn't have it but google does.  Why do I bother
trying the archiver except to find it isn't working and get upset?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Missing archive entry

From
John Hansen
Date:
On Thu, 2004-12-23 at 23:44, Bruce Momjian wrote:
> I did a search for pgbench and Google found the article I was looking
> for:
>
>
http://groups-beta.google.com/group/pgsql.performance/browse_frm/thread/eafbb7cc58a4afcc/aafb8805c8d13232?q=postgresql+pgbench+lane&_done=%2Fgroups%3Fq%3Dpostgresql+pgbench+lane%26start%3D0%26scoring%3Dd%26hl%3Den%26num%3D30%26c2coff%3D1%26&_doneTitle=Back+to+Search&&d#aafb8805c8d13232
>
> but our own archives search did not:
>
>     http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=pg_bench+&ul=&dp=0&o=0&ps=10&s=date

Fixed....

> I did a search for 'pgbench'.  Do we not archive entries from December
> 20?

... John