Обсуждение: 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@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
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
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
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
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
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