From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | Memphisto <szoli(at)netvisor(dot)hu> |
Cc: | PostgreSQL general mailinglist <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] on PostgreSQL performance optimization. |
Date: | 1998-12-19 11:43:51 |
Message-ID: | 367B9177.A6860062@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Memphisto wrote:
>
> Hi,
>
> For a month I was working on a NS-proxy parser that moved all necessary
> information into a postgreSQL relation. The problem is that this app is
> run every midnight so supposed to be process the information relatively
> fast. It isn't. Today's proxy log is 3041705 bytes and the app is still
> working on it.
> I'd like to know how to optimize the performance of it. The app does not
> consume too much CPU time, while postgreSQL does. How could I find out if
> what is suboptimal - the scheme of relations or the SQL queries I wrote,
> etc.
First, do you use BEGIN/END to run many queries in one transaction?
Two fsync per query (without BEGIN/END) is great overhead...
And, as usual, man vacuum -:)
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Paulo da Silva | 1998-12-19 17:52:21 | Is there a port to Windows95/98? |
Previous Message | Memphisto | 1998-12-19 10:21:44 | on PostgreSQL performance optimization. |