Josh Berkus wrote:
> Particularly, the difficulty is that this application gets many small
> requests during the day (100 simultaneous uses) and shares a server
> with Apache. So I have to be concerned about how much memory each
> connection soaks up, during the day. At night, the maintainence
Joe,
> I think we'd need more information to be of any help -- schema,
> functions, explain output, etc.
Yeah, I know. I'm just looking for general tips here ... I need to do
the actual optimization interactively.
Particularly, the difficulty is that this application gets many small
reque
Josh Berkus wrote:
> The problem: The update series (done as a function) takes 10-15
> minutes. During this time, the CPU is never more than 31% busy, only
> 256mb of 512 is in use, and the disk channel is only 25% - 50%
> saturated.As such, is seems like we could run things faster.
>
> What
Folks,
I'm doing some massive data transformations on Postgresql, and they're
a lot slower than they should be. I'm looking for some tips on
improving things. If the PGSQL-PERFORMANCE list was ever created,
please tell me and I'll go over there.
The update: A series of 7 update statements wh
