your help.
-Tim
On Tue, Apr 4, 2023 at 10:55 AM Tim Slechta wrote:
>
>
> On Tue, Apr 4, 2023 at 9:57 AM Tom Lane wrote:
>
>> Tim Slechta writes:
>> > The test data below is from a non-virtualized (client system and
>> database
>> > server) Postgres 14
The test data below is from a non-virtualized (client system and database
server) Postgres 14 environment, with no replication, no high availability,
and with no load balancing. This environment has older and slower disk
drives, and the test is driven by a single client process.
In this case 24%
t;pipworkspaceobject_5" btree (rwso_threadu)
"pipworkspaceobject_6" btree (rowning_projectu)
Access method: heap
Options: autovacuum_analyze_scale_factor=0.0,
autovacuum_analyze_threshold=500
On Thu, Oct 28, 2021 at 1:15 AM Tom Lane wrote:
> Tim Slechta writes:
> > Wh
Why does the planner not use an index when a view is involved?
1) A description of what you are trying to achieve and what results you
expect.
Why don't plans use indexes when views are involved? A similar query on
the underlying table leverages the appropriate index.
== Point 1. The following q
