Re: [ADMIN] Setting up High Availability Group of PostgreSQL instances using RedHat Cluster Suite

Hi, On Sun, 2012-12-16 at 03:25 +0500, Terry Khatri wrote: > I am having an issue with postgres service on redhat cluster suite > (Rehl6), the service gets started on 2 nodes out of 3, is that the > right behaviour ? Depends. > I would like it to be restricted to 1 node at a time becuase I

Re: [ADMIN] Does index based on text with 'en_US.utf8' collation support like query?

Hello, On Dec 25, 2012, at 1:37 PM, Haifeng Liu wrote: > > Hi, > > I found that queries like "select * from tbl where col1 like 'abc%'" will use > index only when the col1(and the index) use 'C' collation. If I use 'default' > which is 'en_US.utf8' in my database, the equation condition wil

[ADMIN] Does index based on text with 'en_US.utf8' collation support like query?

Hi, I found that queries like "select * from tbl where col1 like 'abc%'" will use index only when the col1(and the index) use 'C' collation. If I use 'default' which is 'en_US.utf8' in my database, the equation condition will use the index but like query will not. I also tried to specify the c