Re: Postgreql 8.0.3 temporary Table Strange behaviour

From: Dany De Bontridder <dany(at)alchimerys(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgreql 8.0.3 temporary Table Strange behaviour
Date: 2006-04-24 20:15:41
Message-ID: 200604242215.42230.dany@alchimerys.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-04-24 20:23:15 Re: Problems logging in
Previous Message Shane Ambler 2006-04-24 20:12:15 Re: Database Selection