Re: Slow Inserts on 1 table?

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow Inserts on 1 table?
Date: 2005-08-02 18:09:14
Message-ID: a9d3aac60713b43972cbf81eea0077e6@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> The only annoyance is that the interface I use most often, Python's
>> pgdb, runs everything in a transaction, and you can't analyze in a
>> transaction.
>
> Hm? We've allowed ANALYZE inside a transaction for a long time.

I'm stuck with using 7.2, for now, and I get this:

ERROR: ANALYZE cannot run inside a BEGIN/END block

I'll be happy to find out that this restriction's been removed in later
versions.

- John D. Burger
MITRE

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Havasvölgyi Ottó 2005-08-02 18:10:12 Re: feeding big script to psql
Previous Message Dr NoName 2005-08-02 18:05:24 Re: indexes are farked