Re: Slow Inserts on 1 table?

John D. Burger wrote:
>>> 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.

Your running 7.2? That is all kinds of level of... huh? Why?

Sincerely,

Joshua D. Drake

>
> - John D. Burger
> MITRE
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/