Re: [PERFORM] Problems with FTS

2011-01-11 Thread Rauan Maemirov
Hi, Kevin. Sorry for long delay. EXPLAIN ANALYZE SELECT "v"."id", "v"."title" FROM "video" AS "v" WHERE (v.active) AND (v.fts @@ 'dexter:A|season:A|seri:A|декстер:A|качество:A|сезон:A|серия:A'::tsquery and v.id <> 500563 ) ORDER BY COALESCE(ts_rank_cd( '{0.1, 0.2, 0.7, 1.0}', v.fts, 'dexter:A|sea

Re: [PERFORM] pgbench to the MAXINT

2011-01-11 Thread Euler Taveira de Oliveira
Em 10-01-2011 05:25, Greg Smith escreveu: Euler Taveira de Oliveira wrote: Em 07-01-2011 22:59, Greg Smith escreveu: setrandom: invalid maximum number -2147467296 It is failing at atoi() circa pgbench.c:1036. But it just the first one. There are some variables and constants that need to be co

Re: [PERFORM] Performance of PostgreSQL over NFS

2011-01-11 Thread Jignesh Shah
On Mon, Jan 3, 2011 at 9:28 PM, Greg Smith wrote: > Mladen Gogala wrote: >> >> Rich wrote: >>> >>> I am wondering why anyone would do that?  Too much overhead and no >>> reliable enough. >> >> Apparently, NetApp  thinks that  it is reliable. They're selling that >> stuff  for years.  I know that O

[PERFORM] Performance test of Oracle and PostgreSQL using same binary

2011-01-11 Thread Divakar Singh
Hello all, I am trying to do comparative study of PostgreSQL and Oracle. Has anybody tried to use same binary for connecting to oracle as well as PostgreSQL at the same time? I mean the program should be able to create 1 connection to oracle and 1 connection to postgreSQL at the same time. The pr