Re: Slow Inserts on 1 table? - Mailing list pgsql-general

From John D. Burger
Subject Re: Slow Inserts on 1 table?
Date
Msg-id a9d3aac60713b43972cbf81eea0077e6@mitre.org
Whole thread Raw
In response to Re: Slow Inserts on 1 table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Slow Inserts on 1 table?  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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



pgsql-general by date:

Previous
From: Dr NoName
Date:
Subject: Re: indexes are farked
Next
From: Ragnar Hafstað
Date:
Subject: Re: indexes are fucked