| From: | PFC <lists(at)boutiquenumerique(dot)com> |
|---|---|
| To: | "Oliver Crosby" <ryusei(at)gmail(dot)com>, "Sven Willenberger" <sven(at)dmv(dot)com> |
| Cc: | "Dawid Kuroczko" <qnex42(at)gmail(dot)com>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, jd(at)commandprompt(dot)com, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Looking for tips |
| Date: | 2005-07-19 23:01:56 |
| Message-ID: | op.st6nlincth1vuj@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
You could have a program pre-parse your log and put it in a format
understandable by COPY, then load it in a temporary table and write a part
of your application simply as a plpgsql function, reading from this table
and doing queries (or a plperl function)...
> So... (bear with me here.. trying to make sense of this)..
> With triggers there's a way I can do the parsing I need to on a log
> file and react to completed events in non-sequential order (you can
> ignore that part.. it's just how we piece together different related
> events) and then have perl/DBD::Pg invoke a copy command (which, from
> what I can tell, has to operate on a file...) and the copy command can
> feed the ID I need back to perl so I can work with it...
> If that doesn't hurt my brain, then I'm at least kinda confused...
> Anyway. Heading home now. I'll think about this more tonight/tomorrow.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2005-07-20 00:39:33 | Re: COPY FROM performance improvements |
| Previous Message | Mark Wong | 2005-07-19 22:51:33 | Re: COPY FROM performance improvements |