hmmm, I think spilling over to disk for temporary tables is handled by
an entirely different branch in the PG source code. In fact, some other
folks have chimed in and said log_temp_files doesn't relate to temp
files at all use by temporary tables, just queries as you mentioned
below elsewhere
On Thu, 2021-07-08 at 17:22 -0400, MichaelDBA wrote:
> I got a question about PG log lines with temporary file info like this:
>
> case 1: log line with no contextual info
> 2021-07-07 20:28:15 UTC:10.100.11.95(50274):myapp@mydb:[35200]:LOG:
> temporary file: path "base/pgsql_tmp/pgsql_tmp35200.0
Hi all,
I think that global indexes could be useful sometimes. That is why Oracle
implements them.
Just to mention two benefits that could be required by a lot of people:
- Global uniqueness which shouldn't be in conflict with partitioning
- Performance! Well, when index is on a column which is no
