Re: [HACKERS] Query results differ depending on operating system (using GIN)
On Tue, 20 Jul 2010, Robert Haas wrote: On Tue, Jul 20, 2010 at 5:41 AM, Artur Dabrowski a...@astec.com.pl wrote: I have been redirected here from pg-general. I tested full text search using GIN index and it turned out that the results depend on operating system. Not all the rows are found when executing some of queries on pg server installed on Win XP SP3 and CentOS 5.4, while everything seems to be fine on Ubuntu 4.4.1. More details and tested queries are described here: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-ts29172750.html I hope you can help with this weird problem. This seems like it's definitely a bug, but I don't know much about the GIN code. Copying Oleg and Teodor... On my machine I didn't reproduce the problem with Artur's dump. I think the problem could be with package, since I use only compiled version. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Query results differ depending on operating system (using GIN)
On 20 July 2010 10:41, Artur Dabrowski a...@astec.com.pl wrote: Hello, I have been redirected here from pg-general. I tested full text search using GIN index and it turned out that the results depend on operating system. Not all the rows are found when executing some of queries on pg server installed on Win XP SP3 and CentOS 5.4, while everything seems to be fine on Ubuntu 4.4.1. More details and tested queries are described here: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-ts29172750.html I hope you can help with this weird problem. Regards Artur -- Could you please clarify what you mean by Ubuntu 4.4.1? Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Query results differ depending on operating system (using GIN)
Thom, please have a look at this message of Oleg Bartunov for details of this operating system: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-tc29172750.html#a29212846 Artur Thom Brown wrote: Could you please clarify what you mean by Ubuntu 4.4.1? Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- View this message in context: http://old.nabble.com/Query-results-differ-depending-on-operating-system-%28using-GIN%29-tp29213082p29213340.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Query results differ depending on operating system (using GIN)
On 20 July 2010 11:14, Artur Dabrowski a...@astec.com.pl wrote: Thom, please have a look at this message of Oleg Bartunov for details of this operating system: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-tc29172750.html#a29212846 Artur Ah, so gcc 4.4.1 on Ubuntu or derivative thereof. Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Query results differ depending on operating system (using GIN)
On Tue, Jul 20, 2010 at 5:41 AM, Artur Dabrowski a...@astec.com.pl wrote: I have been redirected here from pg-general. I tested full text search using GIN index and it turned out that the results depend on operating system. Not all the rows are found when executing some of queries on pg server installed on Win XP SP3 and CentOS 5.4, while everything seems to be fine on Ubuntu 4.4.1. More details and tested queries are described here: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-ts29172750.html I hope you can help with this weird problem. This seems like it's definitely a bug, but I don't know much about the GIN code. Copying Oleg and Teodor... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers