Re: Missing archive entry

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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