Retain PREPARE or CONNECT TRIGGER

From: Justin Funk <funkju(at)iastate(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Retain PREPARE or CONNECT TRIGGER
Date: 2009-04-01 14:14:56
Message-ID: a4c12a480904010714p4e52130dj670decedcbc0c4ed@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am using rsyslog (a syslog to database application) to connect to my
postgresql database. It then executes Insert after Insert 100s a
minute.... I have been reading about the PREPARE statement and think
that could dramatically increase my insert speed. The problem is, as
you all know, that PREPARE only works for the session that it was
executed. I cannot make rsyslog prepare the statement when it start's
it's session, so how can I use the ability of "PREPARE" in this
situation?

I was thinking maybe that there would be away to trigger the prepare
statement when the rsyslog user connects. Or is there another option
like PREPARE that persists?

Thanks for your help.

Justin Funk

Browse pgsql-general by date

  From Date Subject
Next Message CM J 2009-04-01 14:15:26 Re: Postgres: Packaging & Server Startup
Previous Message Sam Mason 2009-04-01 14:00:06 Re: string_to_array with empty input