[GENERAL] SSL ques

when I install sysbench-0.4.8, after the make command: /usr/bin/ld: warning: libssl.so.6, needed by /opt/PostgreSQL/9.0/lib/libpq.so, not found (try using -rpath or -rpath-link) /usr/bin/ld: warning: libcrypto.so.6, needed by /opt/PostgreSQL/9.0/lib/libpq.so, not found (try using -rpath or -

[GENERAL] SSL ques

when I install sysbench-0.4.8, after the make command: /usr/bin/ld: warning: libssl.so.6, needed by /opt/PostgreSQL/9.0/lib/libpq.so, not found (try using -rpath or -rpath-link) /usr/bin/ld: warning: libcrypto.so.6, needed by /opt/PostgreSQL/9.0/lib/libpq.so, not found (try using -rpath or -

Re: [GENERAL] strange row count estimates with conditions on multiple column

Dne 17.11.2010 06:58, Tom Lane napsal(a): >> BTW I think the default estimate used to be 1000, so it was changed in >> one of the 8.x releases? Can you point me to the docs? I've even tried >> to find that in the sources, but unsuccessfully. > > It's DEFAULT_RANGE_INEQ_SEL, and AFAIR it hasn't cha

[GENERAL] postgre...@fosdem 2011 - Reminder: call for papers ending soon!

FOSDEM is one of the biggest Free and Open Source events held annually in Brussels, Belgium, and attended by around 4000 people. As in recent years, the PostgreSQL project will have a devroom where we will be presenting a number of talks. The event will be held on the 5 - 6th February 2011.

Re: [GENERAL] Using regexp_replace to remove small words

Hi Peter, your REGEX is exactly what we were trying to find. Thank you very much! Rodrigo. -- *Rodrigo Mendonça** Diretor de Tecnologia Tel: 31 3025 3550 / Cel: 31 8489 3119 rodr...@vivver.com.br / direto...@vivver.com.br*

Re: [GENERAL] GiST indexing question

Dear Yeb, Thanks for the answer. On Sat, Dec 11, 2010 at 3:10 PM, Yeb Havinga wrote: > On 2010-12-11 06:09, Greg Landrum wrote: >> I guess I must be doing something stupid, but neither the docs nor the >> internet have been particularly helpful in letting me know what. > > Yeah, a hint might hel

Re: [GENERAL] GiST indexing question

On 2010-12-11 06:09, Greg Landrum wrote: I'm now trying to add an equality operator (==) as follows: CREATE OPERATOR == ( LEFTARG = mol, RIGHTARG = mol, PROCEDURE = mol_eq, COMMUTATOR = '=', NEGATOR = '<>', RESTRICT = eqsel, JOIN = eqjoinsel ); Are you sure th

Re: [GENERAL] pg_dump order of rows

2010/12/11 jan > we are seeking for a solution to make the dumop (e.g. the backup) more > random > Can you please explain why? ( just curious, this seems a very strange requirement ) you _could_ _try_ to use postgres feature of synchronised seqscans to achieve this, but I'm not sure if it will

Re: [GENERAL] Asynchronous query execution

thanks to all of you. Regards, CPK On 12/8/10, Merlin Moncure wrote: > On Wed, Dec 8, 2010 at 8:40 AM, John R Pierce wrote: >> On 12/08/10 5:35 AM, c k wrote: >>> >>> Hello, >>> I would like to know how can we execute the queries asynchronously? >>> If we use and execute plpgsql functions they