[GENERAL] Scaling PostgreSQL-9

2010-09-28 Thread sandeep prakash dhumale
Hello All, Need some help in scaling PostgreSQL: I have a table with 400M records with 5 int columns having index only on 1 column. Rows are updated by a perl script which takes 10k numbers in one transactions and fires single single update in a loop on database keeping track of the result re

[GENERAL] Re: Re: [GENERAL] [SQL] Tsearch not searching 'Y'

2010-04-29 Thread sandeep prakash dhumale
On Thu, 29 Apr 2010 19:27:33 +0530 wrote >On Thu, Apr 29, 2010 at 01:13:40PM -0000, sandeep prakash dhumale wrote: >> Hello All, >> >> I am trying to get tsearch working for my application but I am facing a >> problem when alphabet 'Y' is the in the ts

[GENERAL] Tsearch not searching 'Y'

2010-04-29 Thread sandeep prakash dhumale
Hello All, I am trying to get tsearch working for my application but I am facing a problem when alphabet 'Y' is the in the tsquery. can anyone please share some light on it. # SELECT 'hollywood'::tsvector @@ to_tsquery('holly:*'); ?column? -- f (1 row) SELECT 'hollywood'::tsvector