hi,
i have a query that uses a Hash-Join, but it would be faster with Nested-Loop,
and i don't know how to persuade postgresql to do it.
details:
postgresql-8.2 + tsearch2
i have 2 tables, one for people, and one that does a many-to-many
link between people:
CREATE TABLE personlink (
id in
On Sun, Aug 23, 2009 at 1:25 PM, Jaime
Casanova wrote:
> On Thu, Aug 20, 2009 at 11:38 PM, Jeff Janes wrote:
>>> -- Forwarded message --
>>> From: Jaime Casanova
>>> To: psql performance list
>>> Date: Wed, 19 Aug 2009 19:25:11 -0500
>>> Subject: [PERFORMANCE] how to set wal_buffe
On Thu, Aug 20, 2009 at 9:50 PM, Jaime
Casanova wrote:
> in a web app we have a query that we want to show in limited results
> at a time, this one executes in 10 seconds if i use limit but executes
> in 300ms if i remove it.
> why is that happening? the query is using and index for avoiding the
>
On Thu, Aug 20, 2009 at 11:38 PM, Jeff Janes wrote:
>> -- Forwarded message --
>> From: Jaime Casanova
>> To: psql performance list
>> Date: Wed, 19 Aug 2009 19:25:11 -0500
>> Subject: [PERFORMANCE] how to set wal_buffers
>> Hi,
>>
>> Our fine manual says:
>> """
>> The amount of
Hi Gaël,
On Fri, Aug 21, 2009 at 3:37 PM, Gaël Le Mignot wrote:
> With 8.3 ::
>
> Limit (cost=752.67..752.67 rows=1 width=24)
> (11 rows)
>
> With 8.4 ::
> (8 rows)
Could you provide us the EXPLAIN *ANALYZE* output of both plans?
From what I can see, one of the difference is that the estimat