Hi
I have discovered an issue on my Postgresql database recently installed : it
seems that the optimizer can not, when possible, simplify and rewrite a simple
query before running it. Here is a simple and reproducible example :
my_db=# create table test (n numeric);
CREATE
my_db=# insert into
De : Richard Huxton [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 6 février 2008 10:47
À : SURANTYN Jean François
Cc : pgsql-performance@postgresql.org
Objet : Re: [PERFORM] Optimizer : query rewrite and execution plan ?
SURANTYN Jean François wrote:
> my_db=# explain select * from test where n = 1;
&
