On Thu, 2003-11-06 at 10:35, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
- Hash Join (cost=3D1230.79..60581.82 rows=3D158 width=3D54)=
(actual time=3D1262.35..151200.29 rows=3D1121988 loops=3D1)
Hash Cond: (outer.account_id =3D inner.account_id)
- Hash Join
Rod Taylor [EMAIL PROTECTED] writes:
- Hash Join (cost=3D1230.79..60581.82 rows=3D158 width=3D54)=
(actual time=3D1262.35..151200.29 rows=3D1121988 loops=3D1)
Hash Cond: (outer.account_id =3D inner.account_id)
- Hash Join (cost=3D1226.78..52863.43 rows=3D1542558 w=
idth=3D50) (actual
On Thu, 2003-11-06 at 10:35, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
- Hash Join (cost=3D1230.79..60581.82 rows=3D158 width=3D54)=
(actual time=3D1262.35..151200.29 rows=3D1121988 loops=3D1)
Hash Cond: (outer.account_id =3D inner.account_id)
- Hash Join
On Wed, 5 Nov 2003, Rod Taylor wrote:
Since this is a large query, attachments for the explains / query.
Configuration:
dev_iqdb=# select version();
version
I'm not sure if that will actually change the default_statistics_target of
the tables you're analyzing, I think it will only apply to newly created
tables.
I believe you have to alter table alter column set statistics 1000 for
each column you want a statistic of 1000. You might wanna
Rod Taylor [EMAIL PROTECTED] writes:
I'm not sure if that will actually change the default_statistics_target
Hmm.. I was under the impression that it would work for any tables that
haven't otherwise been overridden.
It will. I think Scott is recalling the original circa-7.2
implementation,
On Wed, 2003-11-05 at 18:57, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
I'm not sure if that will actually change the default_statistics_target
Hmm.. I was under the impression that it would work for any tables that
haven't otherwise been overridden.
It will. I think Scott
Rod Taylor [EMAIL PROTECTED] writes:
Effectively, the planner has amazingly inaccurate row estimates.
It seems the key estimation failure is in this join step:
- Hash Join (cost=1230.79..60581.82 rows=158 width=54) (actual
time=1262.35..151200.29 rows=1121988 loops=1)
On Wed, 5 Nov 2003, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
I'm not sure if that will actually change the default_statistics_target
Hmm.. I was under the impression that it would work for any tables that
haven't otherwise been overridden.
It will. I think Scott is
On Wed, 2003-11-05 at 19:18, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
Effectively, the planner has amazingly inaccurate row estimates.
It seems the key estimation failure is in this join step:
- Hash Join (cost=1230.79..60581.82 rows=158 width=54) (actual
10 matches
Mail list logo