Re: Postgreql 8.0.3 temporary Table Strange behaviour - Mailing list pgsql-general

From Dany De Bontridder
Subject Re: Postgreql 8.0.3 temporary Table Strange behaviour
Date
Msg-id 200604242215.42230.dany@alchimerys.be
Whole thread Raw
In response to Re: Postgreql 8.0.3 temporary Table Strange behaviour  (Richard Huxton <dev@archonet.com>)
Responses Re: Postgreql 8.0.3 temporary Table Strange behaviour
List pgsql-general
On Monday 24 April 2006 10:43, Richard Huxton wrote:
(...)
> Do these two not solve your problem?
I knew those solutions, I was looking for a new one ;-) Because the " open in
execute" forces you to scan the whole table, that's what I wish to avoid, and
the "select count(*)" will be able to use index scan (faster) (in version
8.1 ?)


Thank you for helping,

Regards,

D.

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Database Selection
Next
From: Richard Broersma Jr
Date:
Subject: Re: Problems logging in