Skip site navigation (1) Skip section navigation (2)

Re: Trouble with plan statistics for behaviour for query.

From: Trevor Campbell <tcampbell(at)atlassian(dot)com>
To: Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>
Cc: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>, Craig James <cjames(at)emolecules(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Trouble with plan statistics for behaviour for query.
Date: 2012-06-05 03:49:24
Message-ID: 4FCD81C4.9030807@atlassian.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
> Actually, I'm rather surprised to see 'real' there: if you're using setObject with a Long, I would imagine that turns 
> into a bigint (which I believe the server knows how to coerce to numeric).
The (real) is just my fault in testing.  I just copy/pasted from elsewhere and it is not what is coming from the JDBC 
driver,  I don't know how to see what the driver is actually sending.

In response to

pgsql-performance by date

Next:From: Andrew JaimesDate: 2012-06-05 12:48:41
Subject: Sequencial scan in a JOIN
Previous:From: Trevor CampbellDate: 2012-06-05 01:25:56
Subject: Re: Trouble with plan statistics for behaviour for query.

pgsql-general by date

Next:From: David JohnstonDate: 2012-06-05 05:05:56
Subject: Re: Return equal number of rows with same column value
Previous:From: Trevor CampbellDate: 2012-06-05 01:25:56
Subject: Re: Trouble with plan statistics for behaviour for query.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group