Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL does CAST implicitely between int and a domain derived from int - Mailing list pgsql-performance

From Jean-Michel Pouré
Subject Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Date
Msg-id 1251412232.25813.1.camel@acer
Whole thread Raw
In response to Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Tree view 
Le jeudi 27 août 2009 à 13:35 -0400, Robert Haas a écrit :
> SELECT MIN(tid), MAX(tid), SUM(1) FROM term_node;
> SHOW default_statistics_target;

SELECT MIN(tid), MAX(tid), SUM(1) FROM term_node;
6;56;67479

SHOW default_statistics_target;
100

For information, if some hackers are interested and they belong to the
community for a long time, I can provide tables with data.

Kind regards,
Jean-Michel
Attachment

pgsql-performance by date:

Previous
From: Guillaume Smet
Date:
Subject: Re: Performance regression between 8.3 and 8.4 on heavy text indexing
Next
From: Jean-Michel Pouré
Date:
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int