Re: faster search - Mailing list pgsql-performance

From Tom Lane
Subject Re: faster search
Date
Msg-id 11819.1118508572@sss.pgh.pa.us
Whole thread Raw
In response to Re: faster search  (John A Meinel <john@arbash-meinel.com>)
List pgsql-performance
John A Meinel <john@arbash-meinel.com> writes:
> I am a little surprised that it is taking 40s to scan only 400k rows,
> though.

Yeah, that seemed high to me too.  Table bloat maybe?  It would be
interesting to look at the output of "vacuum verbose test" to see
how much dead space there is.

            regards, tom lane

pgsql-performance by date:

Previous
From: Cosimo Streppone
Date:
Subject: Re: faster search
Next
From: Madison Kelly
Date:
Subject: Re: Index ot being used