Re: Performance issue on temporary relations - Mailing list pgsql-hackers

From 章晨曦
Subject Re: Performance issue on temporary relations
Date
Msg-id tencent_09C7F95D15C3704D34085BC7@qq.com
Whole thread Raw
In response to Re: Performance issue on temporary relations  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Performance issue on temporary relations
List pgsql-hackers
> I do not think this is something we ought to consider.  It might help
> certain corner use-cases, but it's probably a net loss for most.
> In particular, I don't think that creating thousands of temp tables in
> a session but then touching only a few of them in any one transaction
> is a very plausible usage pattern.

Acturely, we just facing such problem in some real systems. More than 3,700
temporary tables created! I accept such case is not that common, but it does exist.

Regards,
Jet

Halo Tech (www.halodbtech.com)
openHalo (www.openhalo.org)

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: fix misspelling of "tranche" in dsa.h
Next
From: Filip Janus
Date:
Subject: Re: Proposal: Adding compression of temporary files