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
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 |