Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Index Backward Scan fast / Index Scan slow ! (Modifié par Pailloncy Jean-Gérard) - Mailing list pgsql-performance

From Tom Lane
Subject Re: Re: Index Backward Scan fast / Index Scan slow ! (Modifié par Pailloncy Jean-Gérard)
Date
Msg-id 13680.1081803287@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index Backward Scan fast / Index Scan slow ! (Modifié par Pailloncy Jean-Gérard)  (Pailloncy Jean-Gérard <pailloncy@ifrance.com>)
List pgsql-performance
Tree view 
=?ISO-8859-1?Q?Pailloncy_Jean-G=E9rard?= <pailloncy@ifrance.com> writes:
>> In 7.4 a VACUUM should be sufficient ... or at least, if it isn't
> Atfer VACUUM:
> Better, but......

... but not much :-(.  Okay, could we see VACUUM VERBOSE results for
this table?

            regards, tom lane

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: index v. seqscan for certain values
Next
From: Tom Lane
Date:
Subject: Re: index v. seqscan for certain values