great,
thank you a lot Guillaume!
Cheers,
Boris
On 11/03/2011 12:20 PM, Guillaume Lelarge wrote:
On Thu, 2011-11-03 at 12:02 +0100, Guillaume Lelarge wrote:
On Thu, 2011-11-03 at 11:22 +0100, boris pezzatti wrote:
I tested after column types, and the colum that appears to create the
very slow behaviour is of type boolean. Retrieving only 1 column for
3000 records delays at ca. 1 minute.
Do you know any possible reason?
That's good to know. I tried with a boolean column, which gave me 7
seconds for 10000 rows. Which doesn't seem much, but it's actually 7
times more than without the boolean column.
It seems we keep executing the same SQL command, 10000 times (actually
as much as your number of rows). And that is weird.
I'll look into this.
OK, found it. We introduced some time ago a cache for type lookup. It
seems the boolean type doesn't make it to the cache. The patch is
commited. It should be available with the release of 1.14.1.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
