On 11/22/10, Tom Lane wrote:
> Jon Nelson writes:
>> Here is the problem: When I started benchmarking this application, I
>> noticed it (postgresql) started chewing up inodes on the logical
>> volume which houses /var/lib/pgsql. It chewed up a few thousand
>> inodes, and then a few thousand more
Jon Nelson writes:
> Here is the problem: When I started benchmarking this application, I
> noticed it (postgresql) started chewing up inodes on the logical
> volume which houses /var/lib/pgsql. It chewed up a few thousand
> inodes, and then a few thousand more, and then there were no more.
> I
I have an application which, during the normal course of its
operation, creates a single temporary table.
BEGIN;
-- bunch of stuff here
CREATE TEMPORARY TABLE results ON COMMIT DROP AS SELECT
-- a bit more stuff here
ROLLBACK;
In this case, *every* transaction ends in a rollback.
Here is the pr
