Greg Stark wrote:
> Actually most of the estimates seem pretty good. There are some that
> are a ways off, but the real nasties seem to be these. I'm a bit
> confused because it looks like two of your joins don't have Join
> Filters -- and one of those is a left join for which I thought that
> was
Actually most of the estimates seem pretty good. There are some that
are a ways off, but the real nasties seem to be these. I'm a bit
confused because it looks like two of your joins don't have Join
Filters -- and one of those is a left join for which I thought that
was impossible.
Are you sure th
On Tue, Jun 23, 2009 at 10:54 AM, Sim Zacks wrote:
> Sim Zacks wrote:
>> Grzegorz Jaśkiewicz wrote:
>>> give us postgresql version as well, maybe show query and at least table
>>> layout.
>>>
>>
> The queries look like (The one I'm trying to run is the last one, which
> is based on all the previou
Grzegorz Jaśkiewicz wrote:
> give us postgresql version as well, maybe show query and at least table
> layout.
>
"PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC
i386-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1)"
It is a view based on 4 layers of views with a lot of tables and
functions t
Sim Zacks wrote:
> Grzegorz Jaśkiewicz wrote:
>> give us postgresql version as well, maybe show query and at least table
>> layout.
>>
>
The queries look like (The one I'm trying to run is the last one, which
is based on all the previous ones).:
CREATE OR REPLACE VIEW assembliesstockbatch AS
SE
give us postgresql version as well, maybe show query and at least table layout.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> increase default_statistics_target to 100 for instance, and retry.
I changed the setting, reloaded the configuration (without restarting
the server) ran vacuum analyze and the results were the exact same.
Any other thoughts?
Sim
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
