The ANALYSE did the trick... Thanks! Will also read through the
archives...
-Erik
On lunes, dici 1, 2003, at 15:04 Europe/Madrid, Andrew Sullivan wrote:
On Mon, Dec 01, 2003 at 02:40:30PM +0100, Erik Norvelle wrote:
it=> explain select * from indethom where clavis < 25;
What's the percentage o
On Mon, Dec 01, 2003 at 02:40:30PM +0100, Erik Norvelle wrote:
>
> it=> explain select * from indethom where clavis < 25;
What's the percentage of the table where clavis < 25? Have you
ANALYSEd recently? What does the pg_stats view tell you about this
table?
> Feel free to point me to any F
Greetings:
Apologies if this question has already been answered, but I was unable to locate a prior answer in the archives...
I have a table with approximately 10 million records, called "indethom", and with an INTEGER column called "clavis" which is set up as a primary key. When I try to perfor