From: Gnanakumar <gnanam@zoniac.com>
To: 'Rosser Schwarz' <rosser.schwarz@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PSQLException: ERROR: could not open relation with OID xxxx
Date: Mon, 14 Mar 2011 13:20:48 +0530
Message-ID: <006201cbe21c$8a657e20$9f307a60$@com> (raw)
In-Reply-To: <AANLkTikOgLeit=eTEtin-+XX8Rb9rKbwahuUy62q3TBf@mail.gmail.com>
References: <006d01cbdfd5$f48becb0$dda3c610$@com>
<4D79FF3D020000250003B7C6@gw.wicourts.gov>
<004f01cbe20c$f2c6a260$d853e720$@com>
<AANLkTikOgLeit=eTEtin-+XX8Rb9rKbwahuUy62q3TBf@mail.gmail.com>
> Although it's unrelated to your query about an exception being raised,
> a word of advice on temporary tables. (This may not be relevant to
> your situation, but it's no small source of pain in one of the systems
> I'm responsible for.) Significant use of temporary tables will cause
> commensurately significant bloat in your system catalogs. We have a
> system which, in the course of its "normal" operations, creates
> hundreds of temporary tables for processing, aggregation, analysis,
> and reporting.
Thank you very much for sharing your real-time experience.
Do you think that this "significantly bloated system catalogs" is caused
because of the old version 8.2.3 we're running? Will this be resolved in
latest PostgreSQL v9.0? BTW, what version of PostgreSQL are you handling?
Doc says: " Temporary tables are automatically dropped at the end of a
session, or optionally at the end of the current transaction (see ON COMMIT
below). Any indexes created on a temporary table are automatically temporary
as well."
If temporary tables and its indexes are automatically dropped at the end of
the session, why would it cause bloat in system catalogs? I hope you can
make me understand by sharing your real-time experience.
Again, thanks for your advice.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gnanam@zoniac.com, rosser.schwarz@gmail.com
Subject: Re: PSQLException: ERROR: could not open relation with OID xxxx
In-Reply-To: <006201cbe21c$8a657e20$9f307a60$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox