public inbox for [email protected]
help / color / mirror / Atom feedSearch out of sync
17+ messages / 7 participants
[nested] [flat]
* Search out of sync
@ 2006-08-27 18:10 Adrian Klaver <[email protected]>
0 siblings, 1 reply; 17+ messages in thread
From: Adrian Klaver @ 2006-08-27 18:10 UTC (permalink / raw)
To: pgsql-www
I am seeing the same behavior as reported in the message below.
http://archives.postgresql.org/pgsql-www/2006-08/msg00105.php
Is there a fix in the works?
Thank you,
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 00:10 Bruce Momjian <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 2 replies; 17+ messages in thread
From: Bruce Momjian @ 2006-08-29 00:10 UTC (permalink / raw)
To: [email protected]; +Cc: pgsql-www
Adrian Klaver wrote:
> I am seeing the same behavior as reported in the message below.
> http://archives.postgresql.org/pgsql-www/2006-08/msg00105.php
>
> Is there a fix in the works?
I just tested "index bloat" and I can confirm that the second returned
result is incorrect if you click on it. Is anyone addressing this?
--
Bruce Momjian [email protected]
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 00:53 Joshua D. Drake <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 1 reply; 17+ messages in thread
From: Joshua D. Drake @ 2006-08-29 00:53 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: [email protected]; pgsql-www
Bruce Momjian wrote:
> Adrian Klaver wrote:
>> I am seeing the same behavior as reported in the message below.
>> http://archives.postgresql.org/pgsql-www/2006-08/msg00105.php
>>
>> Is there a fix in the works?
>
> I just tested "index bloat" and I can confirm that the second returned
> result is incorrect if you click on it. Is anyone addressing this?
>
No.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 02:08 Tom Lane <[email protected]>
parent: Joshua D. Drake <[email protected]>
0 siblings, 2 replies; 17+ messages in thread
From: Tom Lane @ 2006-08-29 02:08 UTC (permalink / raw)
To: Joshua D. Drake <[email protected]>; +Cc: Bruce Momjian <[email protected]>; [email protected]; pgsql-www
"Joshua D. Drake" <[email protected]> writes:
> Bruce Momjian wrote:
>> I just tested "index bloat" and I can confirm that the second returned
>> result is incorrect if you click on it. Is anyone addressing this?
> No.
Why not? The search index needs to be rebuilt following Marc's
re-reconstruction of the archives. It didn't take too long to do
it after the first reconstruction, what's the holdup this time?
regards, tom lane
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 02:13 Joshua D. Drake <[email protected]>
parent: Tom Lane <[email protected]>
1 sibling, 0 replies; 17+ messages in thread
From: Joshua D. Drake @ 2006-08-29 02:13 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Bruce Momjian <[email protected]>; [email protected]; pgsql-www
Tom Lane wrote:
> "Joshua D. Drake" <[email protected]> writes:
>> Bruce Momjian wrote:
>>> I just tested "index bloat" and I can confirm that the second returned
>>> result is incorrect if you click on it. Is anyone addressing this?
>
>> No.
>
> Why not? The search index needs to be rebuilt following Marc's
> re-reconstruction of the archives. It didn't take too long to do
> it after the first reconstruction, what's the holdup this time?
I have restarted the search engine daemons.
The hold up is simple:
1. Our search sucks.
2. I have zero idea how our search works beyond stop/start
3. Our search sucks.
Joshua D. Drake
>
> regards, tom lane
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 02:23 Tom Lane <[email protected]>
parent: Tom Lane <[email protected]>
1 sibling, 2 replies; 17+ messages in thread
From: Tom Lane @ 2006-08-29 02:23 UTC (permalink / raw)
To: Joshua D. Drake <[email protected]>; +Cc: Bruce Momjian <[email protected]>; [email protected]; pgsql-www
"Joshua D. Drake" <[email protected]> writes:
> I am willing to put man and money resources behind our search engine, if
> I felt that our search engine was going to be productive :) but I never,
> ever use it.
It works well for me and for a lot of other people (at least when the
data is up-to-date). If you can't be bothered to maintain it, however,
I guess we need to find another host.
Any volunteers out there?
regards, tom lane
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 02:29 Joshua D. Drake <[email protected]>
parent: Tom Lane <[email protected]>
1 sibling, 1 reply; 17+ messages in thread
From: Joshua D. Drake @ 2006-08-29 02:29 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Bruce Momjian <[email protected]>; [email protected]; pgsql-www
> It works well for me and for a lot of other people (at least when the
> data is up-to-date). If you can't be bothered to maintain it, however,
> I guess we need to find another host.
I guess it depends on what you are looking for, but it rarely works for me.
>
> Any volunteers out there?
Uhh, who said I was ever the maintainer? I am the host and have never
claimed to be maintainer. I am not the only one that has root on that
machine to help maintain that box. Dave Page, Applejack and Devrim all
have root on this machine.
Please see my next post on this thread.
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 02:43 Joshua D. Drake <[email protected]>
parent: Tom Lane <[email protected]>
1 sibling, 0 replies; 17+ messages in thread
From: Joshua D. Drake @ 2006-08-29 02:43 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Bruce Momjian <[email protected]>; [email protected]; pgsql-www
Tom Lane wrote:
> "Joshua D. Drake" <[email protected]> writes:
>> I am willing to put man and money resources behind our search engine, if
>> I felt that our search engine was going to be productive :) but I never,
>> ever use it.
/me digs around in the install and finds a suspicious scripts called:
update-archives
Reading the script, it updates some date statistics in the database
which appears to in theory cause the indexer to re-fire against
archives, pgfoundry and gborg..
So time will tell. Where is that wiki so I can document this, since I am
spending my time on it, I might as well make sure someone can come
behind me.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 07:21 John Hansen <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 1 reply; 17+ messages in thread
From: John Hansen @ 2006-08-29 07:21 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; [email protected]; +Cc: pgsql-www
Index resync started, no new messages will be indexed until it's finished.
I missed the email about the archives was regenerated, and have spent hours trying to work out what had happened.
This problem would have resolved itself tho, as the archives are reindexed every 30 days anyways.
Kind regards,
John
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Bruce Momjian
> Sent: Tuesday, August 29, 2006 10:10 AM
> To: [email protected]
> Cc: [email protected]
> Subject: Re: [pgsql-www] Search out of sync
>
> Adrian Klaver wrote:
> > I am seeing the same behavior as reported in the message below.
> > http://archives.postgresql.org/pgsql-www/2006-08/msg00105.php
> >
> > Is there a fix in the works?
>
> I just tested "index bloat" and I can confirm that the second
> returned result is incorrect if you click on it. Is anyone
> addressing this?
>
> --
> Bruce Momjian [email protected]
> EnterpriseDB http://www.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 07:35 Dave Page <[email protected]>
parent: Joshua D. Drake <[email protected]>
0 siblings, 2 replies; 17+ messages in thread
From: Dave Page @ 2006-08-29 07:35 UTC (permalink / raw)
To: Joshua D. Drake <[email protected]>; Tom Lane <[email protected]>; +Cc: Bruce Momjian <[email protected]>; [email protected]; pgsql-www
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Joshua D. Drake
> Sent: 29 August 2006 03:30
> To: Tom Lane
> Cc: Bruce Momjian; [email protected]; [email protected]
> Subject: Re: [pgsql-www] Search out of sync
>
>
> > It works well for me and for a lot of other people (at
> least when the
> > data is up-to-date). If you can't be bothered to maintain
> it, however,
> > I guess we need to find another host.
>
> I guess it depends on what you are looking for, but it rarely
> works for me.
Works well for me <shrug>.
> > Any volunteers out there?
>
> Uhh, who said I was ever the maintainer? I am the host and have never
> claimed to be maintainer. I am not the only one that has root on that
> machine to help maintain that box. Dave Page, Applejack and
> Devrim all
> have root on this machine.
Unfortunately I've been on holiday. And doesn't Devrim work for you? :-)
/D
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 14:19 Devrim GUNDUZ <[email protected]>
parent: Dave Page <[email protected]>
1 sibling, 0 replies; 17+ messages in thread
From: Devrim GUNDUZ @ 2006-08-29 14:19 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; Tom Lane <[email protected]>; Bruce Momjian <[email protected]>; [email protected]; pgsql-www
Hello,
On Tue, 2006-08-29 at 08:35 +0100, Dave Page wrote:
> Unfortunately I've been on holiday. And doesn't Devrim work for
> you? :-)
Do we have a text about how search engine works? I have zero idea about
that.
... and having root does not mean that I know a lot about the search
engine :-)
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
Attachments:
[application/pgp-signature] signature.asc (189B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 14:25 Joshua D. Drake <[email protected]>
parent: Dave Page <[email protected]>
1 sibling, 0 replies; 17+ messages in thread
From: Joshua D. Drake @ 2006-08-29 14:25 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: Tom Lane <[email protected]>; Bruce Momjian <[email protected]>; [email protected]; pgsql-www
>>> Any volunteers out there?
>> Uhh, who said I was ever the maintainer? I am the host and have never
>> claimed to be maintainer. I am not the only one that has root on that
>> machine to help maintain that box. Dave Page, Applejack and
>> Devrim all
>> have root on this machine.
>
> Unfortunately I've been on holiday. And doesn't Devrim work for you? :-)
Yes, Devrim works for me :)
Joshua D. Drake
>
> /D
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 15:55 Bruce Momjian <[email protected]>
parent: John Hansen <[email protected]>
0 siblings, 2 replies; 17+ messages in thread
From: Bruce Momjian @ 2006-08-29 15:55 UTC (permalink / raw)
To: John Hansen <[email protected]>; +Cc: [email protected]; pgsql-www
John Hansen wrote:
> Index resync started, no new messages will be indexed until it's
> finished.
>
> I missed the email about the archives was regenerated, and have spent
> hours trying to work out what had happened.
>
> This problem would have resolved itself tho, as the archives are
> reindexed every 30 days anyways.
It still does not work. If you search "index bloat", the second item is
"Constraints" and there is no mention of index bloat there. Before the
reindex, the second item said index bloat, but pointed to the
"Constraints" email. Could this be caused by Marc fixing the indexes
based on pre-post July 2006 indexing needs.
--
Bruce Momjian [email protected]
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 17:33 John Hansen <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 0 replies; 17+ messages in thread
From: John Hansen @ 2006-08-29 17:33 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: [email protected]; pgsql-www
Bruce Momjian Wrote:
> It still does not work. If you search "index bloat", the
> second item is "Constraints" and there is no mention of index
> bloat there. Before the reindex, the second item said index
> bloat, but pointed to the "Constraints" email. Could this be
> caused by Marc fixing the indexes based on pre-post July 2006
> indexing needs.
No, the archives are being reindexed, and the indexer is still running.
While it's running, results will be somewhat screwed, until the reverse index is updated, which doesn't occur till it's been thru all of the pages. (some 500.000+ of them)
Be patient please.
Kind Regards,
John
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search out of sync
@ 2006-08-29 18:45 Joshua D. Drake <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 1 reply; 17+ messages in thread
From: Joshua D. Drake @ 2006-08-29 18:45 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: John Hansen <[email protected]>; [email protected]; pgsql-www
Bruce Momjian wrote:
> John Hansen wrote:
>> Index resync started, no new messages will be indexed until it's
>> finished.
>>
>> I missed the email about the archives was regenerated, and have spent
>> hours trying to work out what had happened.
>>
>> This problem would have resolved itself tho, as the archives are
>> reindexed every 30 days anyways.
>
> It still does not work. If you search "index bloat", the second item is
> "Constraints" and there is no mention of index bloat there. Before the
> reindex, the second item said index bloat, but pointed to the
> "Constraints" email. Could this be caused by Marc fixing the indexes
> based on pre-post July 2006 indexing needs.
Who knows :). I have no idea why the constraints email would show up at
all frankly.
Sincerely,
Joshua D. Drake
>
> --
> Bruce Momjian [email protected]
> EnterpriseDB http://www.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 17+ messages in thread
* Search is now in sync
@ 2006-08-30 01:19 John Hansen <[email protected]>
parent: Joshua D. Drake <[email protected]>
0 siblings, 1 reply; 17+ messages in thread
From: John Hansen @ 2006-08-30 01:19 UTC (permalink / raw)
To: pgsql-www
Search is now in sync.
... John
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Search is now in sync
@ 2006-08-30 02:05 Bruce Momjian <[email protected]>
parent: John Hansen <[email protected]>
0 siblings, 0 replies; 17+ messages in thread
From: Bruce Momjian @ 2006-08-30 02:05 UTC (permalink / raw)
To: John Hansen <[email protected]>; +Cc: pgsql-www
John Hansen wrote:
> Search is now in sync.
Yes, I can confirm. Thanks for the fix.
--
Bruce Momjian [email protected]
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 17+ messages in thread
end of thread, other threads:[~2006-08-30 02:05 UTC | newest]
Thread overview: 17+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-27 18:10 Search out of sync Adrian Klaver <[email protected]>
2006-08-29 00:10 ` Bruce Momjian <[email protected]>
2006-08-29 00:53 ` Joshua D. Drake <[email protected]>
2006-08-29 02:08 ` Tom Lane <[email protected]>
2006-08-29 02:13 ` Joshua D. Drake <[email protected]>
2006-08-29 02:23 ` Tom Lane <[email protected]>
2006-08-29 02:29 ` Joshua D. Drake <[email protected]>
2006-08-29 07:35 ` Dave Page <[email protected]>
2006-08-29 14:19 ` Devrim GUNDUZ <[email protected]>
2006-08-29 14:25 ` Joshua D. Drake <[email protected]>
2006-08-29 02:43 ` Joshua D. Drake <[email protected]>
2006-08-29 07:21 ` John Hansen <[email protected]>
2006-08-29 15:55 ` Bruce Momjian <[email protected]>
2006-08-29 17:33 ` John Hansen <[email protected]>
2006-08-29 18:45 ` Joshua D. Drake <[email protected]>
2006-08-30 01:19 ` Search is now in sync John Hansen <[email protected]>
2006-08-30 02:05 ` Re: Search is now in sync Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox