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

From Joshua D. Drake
Subject Re: Slow Inserts on 1 table?
Date
Msg-id 42EFB8B6.3020102@commandprompt.com
Whole thread Raw
In response to Re: Slow Inserts on 1 table?  ("John D. Burger" <john@mitre.org>)
Responses Re: Slow Inserts on 1 table?  ("John D. Burger" <john@mitre.org>)
List pgsql-general
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@postgresql.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/

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: indexes are farked
Next
From: Dr NoName
Date:
Subject: Re: indexes are fucked