On 6/8/20 3:31 PM, Ron wrote:
On 6/8/20 9:23 AM, Thorsten Schöning wrote:
Guten Tag Ron,
am Montag, 8. Juni 2020 um 15:35 schrieben Sie:
Would a set of GLOBAL temporary tables be a better fit for your problem
(eliminating the need to create temporary tables each time)?
Do you mean plain table
On 6/8/20 9:23 AM, Thorsten Schöning wrote:
Guten Tag Ron,
am Montag, 8. Juni 2020 um 15:35 schrieben Sie:
Would a set of GLOBAL temporary tables be a better fit for your problem
(eliminating the need to create temporary tables each time)?
Do you mean plain tables simply created using CREATE T
Guten Tag Thorsten Schöning,
am Montag, 8. Juni 2020 um 10:14 schrieben Sie:
> When the table needs to be created, when is it visible to other
> threads using the same transaction, before or after executing the
> additional query?
There is a misconception here: Multiple concurrent exec doesn't se
Guten Tag Ron,
am Montag, 8. Juni 2020 um 15:35 schrieben Sie:
> Would a set of GLOBAL temporary tables be a better fit for your problem
> (eliminating the need to create temporary tables each time)?
Do you mean plain tables simply created using CREATE TABLE or is there
some additional concept of
Guten Tag Daniel Verite,
am Montag, 8. Juni 2020 um 12:07 schrieben Sie:
> But a SQL session on the server takes its statements from a FIFO queue
> and processes them serially, so there's no intra-session concurrency.
> In fact multi-threaded SQL clients *must* make sure that they don't
> send con
On 6/8/20 3:14 AM, Thorsten Schöning wrote:
Hi all,
I have an app exposing web services to generate reports. Those web
services accept multiple reports per request and calculate them
concurrently. There's one transaction spanning each entire request and
used by ALL spawned threads. The app makes
> That's what I understood as well, but I'm creating those concurrently
> WITHIN one and the same session and transaction. :-)
Did I interpret this as "two different sessions via application threads within
the same transactions of PG".
Does the thread create its own PG session for each thread or
Thorsten Schöning wrote:
> > The caveat you mention about IF NOT EXISTS does not apply to
> > temporary tables, as they're not shared across sessions.[...]
>
> That's what I understood as well, but I'm creating those concurrently
> WITHIN one and the same session and transaction. :-)
Bu
Guten Tag Daniel Verite,
am Montag, 8. Juni 2020 um 11:05 schrieben Sie:
> The caveat you mention about IF NOT EXISTS does not apply to
> temporary tables, as they're not shared across sessions.[...]
That's what I understood as well, but I'm creating those concurrently
WITHIN one and the same ses
Thorsten Schöning wrote:
> I'm using "CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]" and the
> associated queries can take a long time. So the following lists some
> questions about executing those concurrently, even thouzgh I've
> already read threads like the following:
> > The bottom
Hi all,
I have an app exposing web services to generate reports. Those web
services accept multiple reports per request and calculate them
concurrently. There's one transaction spanning each entire request and
used by ALL spawned threads. The app makes sure that e.g. committing
transactions is ha
11 matches
Mail list logo
