- Forwarded Message -
>From: Denis de Bernardy
>To: Jens Hoffrichter
>Sent: Tuesday, June 28, 2011 12:59 AM
>Subject: Re: [PERFORM] Getting rid of a seq scan in query on a large table
>
>
>> Hash Cond: (posts.poster_id = posters.poster_id)
>
>>
Jens Hoffrichter wrote:
> I'm having trouble getting rid of a sequential scan on a table
> with roughly 120k entries it.
Please post your configuration information and some information
about your hardware and OS.
http://wiki.postgresql.org/wiki/SlowQueryQuestions
Since the table scan went
Hi everyone,
I'm having trouble getting rid of a sequential scan on a table with roughly
120k entries it. Creation of an index on that particular column which
triggers the sequential scan doesn't do anything, VACUUM and ANALYZE has
been done on the table.
The table in question has the following d
