pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Peformance of Update
2+ messages / 2 participants
[nested] [flat]

* Peformance of Update
@ 2003-08-11 11:33  whchung@popularworld.com
  0 siblings, 1 reply; 2+ messages in thread

From: whchung@popularworld.com @ 2003-08-11 11:33 UTC (permalink / raw)
  To: pgsql-performance

Hi,
    Currently we are using postgresql 7.3 with Redhat linux 9. We find that when we try to execute 200,000 update statement through JDBC, the performance of degraded obviously for each update statement when comparing with less update statement(eg. 5000). Is there any suggestion that we can improve the performance for executing update statement at postgresql ? Thanks.

Regards,
Ricky.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Peformance of Update
@ 2003-08-11 13:26  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  parent: whchung@popularworld.com
  0 siblings, 0 replies; 2+ messages in thread

From: Shridhar Daithankar @ 2003-08-11 13:26 UTC (permalink / raw)
  To: pgsql-performance

On 11 Aug 2003 at 19:33, whchung@popularworld.com wrote:
>  Currently we are using postgresql 7.3 with Redhat linux 9. We find that 
> when we try to execute 200,000 update statement through JDBC, the performance 
> of degraded obviously for each update statement when comparing with less update 
> statement(eg. 5000). Is there any suggestion that we can improve the 
> performance for executing update statementat postgresql ? Thanks.

How are you bunching your transactions? I mean how many updates per 
transaction?

And have you tried moving WAL to separate disk for such a update heavy 
environment? Have you are tuned FSM to take care of dead tuples generated in 
vacuum? Are you running autovacuum daemon?

All these things are almost a must for such update heavy environment..

Bye
 Shridhar

--
Moore's Constant:	Everybody sets out to do something, and everybody	does 
something, but no one does what he sets out to do.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-08-11 13:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-11 11:33 Peformance of Update whchung@popularworld.com
2003-08-11 13:26 ` Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox