Query results differ depending on operating system (using GIN)
in [PgSql]
|
Prev: [HACKERS] Query results differ depending on operating system (usingGIN)
Next: lock_timeout GUC patch - Review
From: Thom Brown on 20 Jul 2010 06:04 On 20 July 2010 10:41, Artur Dabrowski <ad(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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Artur Dabrowski on 20 Jul 2010 06:14 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(a)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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Thom Brown on 20 Jul 2010 06:21 On 20 July 2010 11:14, Artur Dabrowski <ad(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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Robert Haas on 20 Jul 2010 10:22
On Tue, Jul 20, 2010 at 5:41 AM, Artur Dabrowski <ad(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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |