I have a function where in
In a cursor loop I
1. create a temp table (on commit drop)
2. insert data into it
3. Run Analyze on the table
Select/update outside the loop.
This has been running fine for a while on multiple setups, large and small
volumes. The setups all have
"Mahadevan, Mridula" writes:
> This has been running fine for a while on multiple setups, large and small
> volumes. The setups all have the same hardware configuration.
> On one particular setup with about 200k records and this analyze runs for
> 45min and then times out(statement timeout is s
sql-performance@postgresql.org
Subject: Re: [PERFORM] Analyze on temp table taking very long
"Mahadevan, Mridula" writes:
> This has been running fine for a while on multiple setups, large and small
> volumes. The setups all have the same hardware configuration.
> On one partic
