pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
can't handle large number of INSERT/UPDATEs
24+ messages / 12 participants
[nested] [flat]

* can't handle large number of INSERT/UPDATEs
@ 2004-10-25 20:53 Anjan Dave <adave@vantage.com>
  2004-10-25 21:19 ` Re: can't handle large number of INSERT/UPDATEs Rod Taylor <pg@rbt.ca>
  2004-10-26 02:29 ` Re: can't handle large number of INSERT/UPDATEs Dustin Sallings <dustin@spy.net>
  2004-10-26 20:50 ` Re: can't handle large number of INSERT/UPDATEs Andrew McMillan <andrew@catalyst.net.nz>
  0 siblings, 3 replies; 24+ messages in thread

From: Anjan Dave @ 2004-10-25 20:53 UTC (permalink / raw)
  To: pgsql-performance

Hi,

 

I am dealing with an app here that uses pg to handle a few thousand
concurrent web users. It seems that under heavy load, the INSERT and
UPDATE statements to one or two specific tables keep queuing up, to the
count of 150+ (one table has about 432K rows, other has about 2.6Million
rows), resulting in 'wait's for other queries, and then everything piles
up, with the load average shooting up to 10+. 

 

We (development) have gone through the queries/explain analyzes and made
sure the appropriate indexes exist among other efforts put in.

 

I would like to know if there is anything that can be changed for better
from the systems perspective. Here's what I have done and some recent
changes from the system side:

 

-Upgraded from 7.4.0 to 7.4.1 sometime ago

-Upgraded from RH8 to RHEL 3.0

-The settings from postgresql.conf (carried over, basically) are:

            shared_buffers = 10240 (80MB)

            max_connections = 400

            sort_memory = 1024

            effective_cache_size = 262144 (2GB)

            checkpoint_segments = 15

stats_start_collector = true

stats_command_string = true 

Rest everything is at default

 

In /etc/sysctl.conf (512MB shared mem)

kernel.shmall = 536870912

kernel.shmmax = 536870912

 

-This is a new Dell 6650 (quad XEON 2.2GHz, 8GB RAM, Internal HW
RAID10), RHEL 3.0 (2.4.21-20.ELsmp), PG 7.4.1

-Vaccum Full run everyday

-contrib/Reindex run everyday

-Disabled HT in BIOS

 

I would greatly appreciate any helpful ideas.

 

Thanks in advance,

 

Anjan

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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-25 20:53 can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-25 21:19 ` Rod Taylor <pg@rbt.ca>
  2 siblings, 0 replies; 24+ messages in thread

From: Rod Taylor @ 2004-10-25 21:19 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: pgsql-performance

On Mon, 2004-10-25 at 16:53, Anjan Dave wrote:
> Hi,
> 
>  
> 
> I am dealing with an app here that uses pg to handle a few thousand
> concurrent web users. It seems that under heavy load, the INSERT and
> UPDATE statements to one or two specific tables keep queuing up, to
> the count of 150+ (one table has about 432K rows, other has about
> 2.6Million rows), resulting in ¡wait¢s for other queries, and then

This isn't an index issue, it's a locking issue. Sounds like you have a
bunch of inserts and updates hitting the same rows over and over again.

Eliminate that contention point, and you will have solved your problem.

Free free to describe the processes involved, and we can help you do
that.





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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-25 20:53 can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-26 02:29 ` Dustin Sallings <dustin@spy.net>
  2 siblings, 0 replies; 24+ messages in thread

From: Dustin Sallings @ 2004-10-26 02:29 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: pgsql-performance


On Oct 25, 2004, at 13:53, Anjan Dave wrote:

> I am dealing with an app here that uses pg to handle a few thousand 
> concurrent web users. It seems that under heavy load, the INSERT and 
> UPDATE statements to one or two specific tables keep queuing up, to 
> the count of 150+ (one table has about 432K rows, other has about 
> 2.6Million rows), resulting in ‘wait’s for other queries, and then 
> everything piles up, with the load average shooting up to 10+.

	Depending on your requirements and all that, but I had a similar issue 
in one of my applications and made the problem disappear entirely by 
serializing the transactions into a separate thread (actually, a thread 
pool) responsible for performing these transactions.  This reduced the 
load on both the application server and the DB server.

	Not a direct answer to your question, but I've found that a lot of 
times when someone has trouble scaling a database application, much of 
the performance win can be in trying to be a little smarter about how 
and when the database is accessed.

--
SPY                      My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________




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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-25 20:53 can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-26 20:50 ` Andrew McMillan <andrew@catalyst.net.nz>
  2 siblings, 0 replies; 24+ messages in thread

From: Andrew McMillan @ 2004-10-26 20:50 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: pgsql-performance

On Mon, 2004-10-25 at 16:53 -0400, Anjan Dave wrote:
> Hi,
> 
>  
> 
> I am dealing with an app here that uses pg to handle a few thousand
> concurrent web users. It seems that under heavy load, the INSERT and
> UPDATE statements to one or two specific tables keep queuing up, to
> the count of 150+ (one table has about 432K rows, other has about
> 2.6Million rows), resulting in ‘wait’s for other queries, and then
> everything piles up, with the load average shooting up to 10+. 

Hi,

We saw a similar problem here that was related to the locking that can
happen against referred tables for referential integrity.

In our case we had referred tables with very few rows (i.e. < 10) which
caused the insert and update on the large tables to be effectively
serialised due to the high contention on the referred tables.

We changed our app to implement those referential integrity checks
differently and performance was hugely boosted.

Regards,
					Andrew.
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/            PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201      MOB: +64(272)DEBIAN      OFFICE: +64(4)499-2267
                        Chicken Little was right.
-------------------------------------------------------------------------

Attachments:

  signature.asc (application/pgp-signature, 188B) download

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

* FW: can't handle large number of INSERT/UPDATEs
@ 2004-10-26 08:19 Rod Dutton <rod@e-rm.co.uk>
  0 siblings, 0 replies; 24+ messages in thread

From: Rod Dutton @ 2004-10-26 08:19 UTC (permalink / raw)
  To: 'Anjan Dave' <adave@vantage.com>; +Cc: pgsql-performance

>>Eliminate that contention point, and you will have solved your problem.

I agree,  If your updates are slow then you will get a queue building up.  

Make sure that:-
1) all your indexing is optimised.
2) you are doing regular vacuuming (bloated tables will cause a slow down
due to swapping).
3) your max_fsm_pages setting is large enough - it needs to be big enough to
hold all the transactions between vacuums (+ some spare for good measure).
4) do a full vacuum - do one to start and then do one after you have had 2&3
(above) in place for a while - if the full vacuum handles lots of dead
tuples then your max_fsm_pages setting is too low.
5) Also try reindexing or drop/recreate the indexes in question as...
"PostgreSQL is unable to reuse B-tree index pages in certain cases. The
problem is that if indexed rows are deleted, those index pages can only be
reused by rows with similar values. For example, if indexed rows are deleted
and newly inserted/updated rows have much higher values, the new rows can't
use the index space made available by the deleted rows. Instead, such new
rows must be placed on new index pages. In such cases, disk space used by
the index will grow indefinitely, even if VACUUM is run frequently. "

Are your updates directly executed or do you use stored procs?  We had a
recent problem with stored procs as they store a "one size fits all" query
plan when compiled - this can be less than optimum in some cases.

We have a similar sounding app to yours and if tackled correctly then all
the above will make a massive difference in performance.

Rod

-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Rod Taylor
Sent: 25 October 2004 22:19
To: Anjan Dave
Cc: Postgresql Performance
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs

On Mon, 2004-10-25 at 16:53, Anjan Dave wrote:
> Hi,
> 
>  
> 
> I am dealing with an app here that uses pg to handle a few thousand
> concurrent web users. It seems that under heavy load, the INSERT and
> UPDATE statements to one or two specific tables keep queuing up, to
> the count of 150+ (one table has about 432K rows, other has about
> 2.6Million rows), resulting in ?wait?s for other queries, and then

This isn't an index issue, it's a locking issue. Sounds like you have a
bunch of inserts and updates hitting the same rows over and over again.

Eliminate that contention point, and you will have solved your problem.

Free free to describe the processes involved, and we can help you do
that.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly




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

* Re: can't handle large number of INSERT/UPDATEs
@ 2004-10-26 17:42 Anjan Dave <adave@vantage.com>
  2004-10-26 17:48 ` Re: can't handle large number of INSERT/UPDATEs Rod Taylor <pg@rbt.ca>
  2004-10-26 18:27 ` Re: can't handle large number of INSERT/UPDATEs Josh Berkus <josh@agliodbs.com>
  0 siblings, 2 replies; 24+ messages in thread

From: Anjan Dave @ 2004-10-26 17:42 UTC (permalink / raw)
  To: Rod Taylor <pg@rbt.ca>; +Cc: pgsql-performance

It probably is locking issue. I got a long list of locks held when we ran select * from pg_locks during a peak time.

relation | database | transaction |  pid  |       mode       | granted 
----------+----------+-------------+-------+------------------+---------
    17239 |    17142 |             |  3856 | AccessShareLock  | t
          |          |    21196323 |  3875 | ExclusiveLock    | t
    16390 |    17142 |             |  3911 | AccessShareLock  | t
    16595 |    17142 |             |  3782 | AccessShareLock  | t
    17227 |    17142 |             |  3840 | AccessShareLock  | t
    17227 |    17142 |             |  3840 | RowExclusiveLock | t
...
...


Vmstat would show a lot of disk IO at the same time.

Is this pointing towards a disk IO issue? (to that end, other than a higher CPU speed, and disabling HT, only thing changed is that it's RAID5 volume now, instead of a RAID10)

-anjan


-----Original Message-----
From: Rod Taylor [mailto:pg@rbt.ca] 
Sent: Monday, October 25, 2004 5:19 PM
To: Anjan Dave
Cc: Postgresql Performance
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs

On Mon, 2004-10-25 at 16:53, Anjan Dave wrote:
> Hi,
> 
>  
> 
> I am dealing with an app here that uses pg to handle a few thousand
> concurrent web users. It seems that under heavy load, the INSERT and
> UPDATE statements to one or two specific tables keep queuing up, to
> the count of 150+ (one table has about 432K rows, other has about
> 2.6Million rows), resulting in ¡wait¢s for other queries, and then

This isn't an index issue, it's a locking issue. Sounds like you have a
bunch of inserts and updates hitting the same rows over and over again.

Eliminate that contention point, and you will have solved your problem.

Free free to describe the processes involved, and we can help you do
that.






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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 17:42 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-26 17:48 ` Rod Taylor <pg@rbt.ca>
  1 sibling, 0 replies; 24+ messages in thread

From: Rod Taylor @ 2004-10-26 17:48 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: pgsql-performance

On Tue, 2004-10-26 at 13:42, Anjan Dave wrote:
> It probably is locking issue. I got a long list of locks held when we ran select * from pg_locks during a peak time.
> 
> relation | database | transaction |  pid  |       mode       | granted 
> ----------+----------+-------------+-------+------------------+---------
>     17239 |    17142 |             |  3856 | AccessShareLock  | t

How many have granted = false?

> Vmstat would show a lot of disk IO at the same time.
> 
> Is this pointing towards a disk IO issue?

Not necessarily. Is your IO reaching the limit or is it just heavy?




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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 17:42 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-26 18:27 ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 24+ messages in thread

From: Josh Berkus @ 2004-10-26 18:27 UTC (permalink / raw)
  To: pgsql-performance; +Cc: Anjan Dave <adave@vantage.com>; Rod Taylor <pg@rbt.ca>

Anjan,

> It probably is locking issue. I got a long list of locks held when we ran
> select * from pg_locks during a peak time.

Do the back-loaded tables have FKs on them?     This would be a likely cause 
of lock contention, and thus serializing inserts/updates to the tables.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



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

* Re: can't handle large number of INSERT/UPDATEs
@ 2004-10-26 17:56 Anjan Dave <adave@vantage.com>
  2004-10-26 18:28 ` Re: can't handle large number of INSERT/UPDATEs Matt Clark <matt@ymogen.net>
  2004-10-26 21:53 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 24+ messages in thread

From: Anjan Dave @ 2004-10-26 17:56 UTC (permalink / raw)
  To: Rod Taylor <pg@rbt.ca>; +Cc: pgsql-performance

None of the locks are in state false actually.

I don't have iostat on that machine, but vmstat shows a lot of writes to
the drives, and the runnable processes are more than 1:

procs                      memory      swap          io     system
cpu
 r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy
wa id
 1  2      0 3857568 292936 2791876    0    0     0 44460 1264  2997 23
13 22 41
 2  2      0 3824668 292936 2791884    0    0     0 25262 1113  4797 28
12 29 31
 2  3      0 3784772 292936 2791896    0    0     0 38988 1468  6677 28
12 48 12
 2  4      0 3736256 292936 2791904    0    0     0 50970 1530  5217 19
12 49 20
 4  2      0 3698056 292936 2791908    0    0     0 43576 1369  7316 20
15 35 30
 2  1      0 3667124 292936 2791920    0    0     0 39174 1444  4659 25
16 35 24
 6  1      0 3617652 292936 2791928    0    0     0 52430 1347  4681 25
19 20 37
 1  3      0 3599992 292936 2790868    0    0     0 40156 1439  4394 20
14 29 37
 6  0      0 3797488 292936 2568648    0    0     0 17706 2272 21534 28
23 19 30
 0  0      0 3785396 292936 2568736    0    0     0  1156 1237 14057 33
8  0 59
 0  0      0 3783568 292936 2568736    0    0     0   704  512  1537  5
2  1 92
 1  0      0 3783188 292936 2568752    0    0     0   842  613  1919  6
1  1 92

-anjan

-----Original Message-----
From: Rod Taylor [mailto:pg@rbt.ca] 
Sent: Tuesday, October 26, 2004 1:49 PM
To: Anjan Dave
Cc: Postgresql Performance
Subject: RE: [PERFORM] can't handle large number of INSERT/UPDATEs

On Tue, 2004-10-26 at 13:42, Anjan Dave wrote:
> It probably is locking issue. I got a long list of locks held when we
ran select * from pg_locks during a peak time.
> 
> relation | database | transaction |  pid  |       mode       | granted

>
----------+----------+-------------+-------+------------------+---------
>     17239 |    17142 |             |  3856 | AccessShareLock  | t

How many have granted = false?

> Vmstat would show a lot of disk IO at the same time.
> 
> Is this pointing towards a disk IO issue?

Not necessarily. Is your IO reaching the limit or is it just heavy?





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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 17:56 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-26 18:28 ` Matt Clark <matt@ymogen.net>
  1 sibling, 0 replies; 24+ messages in thread

From: Matt Clark @ 2004-10-26 18:28 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: Rod Taylor <pg@rbt.ca>; pgsql-performance


>I don't have iostat on that machine, but vmstat shows a lot of writes to
>the drives, and the runnable processes are more than 1:
>
> 6  1      0 3617652 292936 2791928    0    0     0 52430 1347  4681 25
>19 20 37
>  
>
Assuming that's the output of 'vmstat 1' and not some other delay, 
50MB/second of sustained writes is usually considered 'a lot'. 



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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 17:56 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-26 21:53 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 24+ messages in thread

From: Tom Lane @ 2004-10-26 21:53 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: Rod Taylor <pg@rbt.ca>; pgsql-performance

"Anjan Dave" <adave@vantage.com> writes:
> None of the locks are in state false actually.

In that case you don't have a locking problem.

> I don't have iostat on that machine, but vmstat shows a lot of writes to
> the drives, and the runnable processes are more than 1:

I get the impression that you are just saturating the write bandwidth of
your disk :-(

It's fairly likely that this happens during checkpoints.  Look to see if
the postmaster has a child that shows itself as a checkpointer in "ps"
when the saturation is occurring.  You might be able to improve matters
by altering the checkpoint frequency parameters (though beware that
either too small or too large will likely make matters even worse).

			regards, tom lane



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

* Re: can't handle large number of INSERT/UPDATEs
@ 2004-10-26 21:13 Anjan Dave <adave@vantage.com>
  0 siblings, 0 replies; 24+ messages in thread

From: Anjan Dave @ 2004-10-26 21:13 UTC (permalink / raw)
  To: Andrew McMillan <andrew@catalyst.net.nz>; +Cc: pgsql-performance

Andrew/Josh,

Josh also suggested to check for any FK/referential integrity checks,
but I am told that we don't have any foreign key constraints.

Thanks,
anjan

-----Original Message-----
From: Andrew McMillan [mailto:andrew@catalyst.net.nz] 
Sent: Tuesday, October 26, 2004 4:51 PM
To: Anjan Dave
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs

On Mon, 2004-10-25 at 16:53 -0400, Anjan Dave wrote:
> Hi,
> 
>  
> 
> I am dealing with an app here that uses pg to handle a few thousand
> concurrent web users. It seems that under heavy load, the INSERT and
> UPDATE statements to one or two specific tables keep queuing up, to
> the count of 150+ (one table has about 432K rows, other has about
> 2.6Million rows), resulting in 'wait's for other queries, and then
> everything piles up, with the load average shooting up to 10+. 

Hi,

We saw a similar problem here that was related to the locking that can
happen against referred tables for referential integrity.

In our case we had referred tables with very few rows (i.e. < 10) which
caused the insert and update on the large tables to be effectively
serialised due to the high contention on the referred tables.

We changed our app to implement those referential integrity checks
differently and performance was hugely boosted.

Regards,
					Andrew.
------------------------------------------------------------------------
-
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/            PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201      MOB: +64(272)DEBIAN      OFFICE: +64(4)499-2267
                        Chicken Little was right.
------------------------------------------------------------------------
-





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

* Re: can't handle large number of INSERT/UPDATEs
@ 2004-10-26 21:15 Anjan Dave <adave@vantage.com>
  2004-10-26 22:37 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 24+ messages in thread

From: Anjan Dave @ 2004-10-26 21:15 UTC (permalink / raw)
  To: Matt Clark <matt@ymogen.net>; +Cc: Rod Taylor <pg@rbt.ca>; pgsql-performance

That is 1 or maybe 2 second interval.

One thing I am not sure is why 'bi' (disk writes) stays at 0 mostly,
it's the 'bo' column that shows high numbers (reads from disk). With so
many INSERT/UPDATEs, I would expect it the other way around...

-anjan



-----Original Message-----
From: Matt Clark [mailto:matt@ymogen.net] 
Sent: Tuesday, October 26, 2004 2:29 PM
To: Anjan Dave
Cc: Rod Taylor; Postgresql Performance
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs


>I don't have iostat on that machine, but vmstat shows a lot of writes
to
>the drives, and the runnable processes are more than 1:
>
> 6  1      0 3617652 292936 2791928    0    0     0 52430 1347  4681 25
>19 20 37
>  
>
Assuming that's the output of 'vmstat 1' and not some other delay, 
50MB/second of sustained writes is usually considered 'a lot'. 




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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-26 22:37 ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-26 23:04   ` Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta <curtisz@norchemlab.com>
  0 siblings, 1 reply; 24+ messages in thread

From: Tom Lane @ 2004-10-26 22:37 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: Matt Clark <matt@ymogen.net>; Rod Taylor <pg@rbt.ca>; pgsql-performance

"Anjan Dave" <adave@vantage.com> writes:
> One thing I am not sure is why 'bi' (disk writes) stays at 0 mostly,
> it's the 'bo' column that shows high numbers (reads from disk). With so
> many INSERT/UPDATEs, I would expect it the other way around...

Er ... it *is* the other way around.  bi is blocks in (to the CPU),
bo is blocks out (from the CPU).

			regards, tom lane



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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
  2004-10-26 22:37 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-26 23:04   ` Curtis Zinzilieta <curtisz@norchemlab.com>
  2004-10-27 03:21     ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 24+ messages in thread

From: Curtis Zinzilieta @ 2004-10-26 23:04 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Anjan Dave <adave@vantage.com>; Matt Clark <matt@ymogen.net>; Rod Taylor <pg@rbt.ca>; pgsql-performance


On Tue, 26 Oct 2004, Tom Lane wrote:

> "Anjan Dave" <adave@vantage.com> writes:
> > One thing I am not sure is why 'bi' (disk writes) stays at 0 mostly,
> > it's the 'bo' column that shows high numbers (reads from disk). With so
> > many INSERT/UPDATEs, I would expect it the other way around...
> 
> Er ... it *is* the other way around.  bi is blocks in (to the CPU),
> bo is blocks out (from the CPU).
> 
> 			regards, tom lane

Ummm.....

[curtisz@labsoft T2]$ man vmstat
<snip>
FIELD DESCRIPTIONS
<snip>
   IO
       bi: Blocks sent to a block device (blocks/s).
       bo: Blocks received from a block device (blocks/s).

And on my read-heavy 7.4.2 system (running on rh8 at the moment....)
(truncated for readability...)

[root@labsoft T2]# vmstat 1
   procs                      memory    swap          io     system         
 r  b  w   swpd   free   buff  cache  si  so    bi    bo   in    cs  us  
 0  0  0 127592  56832 365496 2013788   0   1     3     6    4     0   4   
 2  0  0 127592  56868 365496 2013788   0   0     0     0  363   611   1   
 1  0  0 127592  57444 365508 2013788   0   0     8   972 1556  3616  11  
 0  0  1 127592  57408 365512 2013800   0   0     0   448  614  1216   5   
 0  0  0 127592  56660 365512 2013800   0   0     0     0  666  1150   6   
 0  3  1 127592  56680 365512 2013816   0   0    16   180 1280  2050   2   
 0  0  0 127592  56864 365516 2013852   0   0    20   728 2111  4360  11   
 0  0  0 127592  57952 365544 2013824   0   0     0   552 1153  2002  10   
 0  0  0 127592  57276 365544 2013824   0   0     0   504  718  1111   5   
 1  0  0 127592  57244 365544 2013824   0   0     0   436 1495  2366   7   
 0  0  0 127592  57252 365544 2013824   0   0     0     0  618  1380   5   
 0  0  0 127592  57276 365556 2014192   0   0   360  1240 2418  5056  14   
 2  0  0 127592  56664 365564 2014176   0   0     0   156  658  1349   5   
 1  0  0 127592  55864 365568 2014184   0   0     0  1572 1388  3598   9   
 2  0  0 127592  56160 365572 2014184   0   0     0   536 4860  6621  13   

Which seems appropriate for both the database and the man page....

-Curtis





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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
  2004-10-26 22:37 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-26 23:04   ` Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta <curtisz@norchemlab.com>
@ 2004-10-27 03:21     ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-27 04:18       ` Re: can't handle large number of INSERT/UPDATEs John Meinel <john@johnmeinel.com>
  2004-10-27 05:02       ` Re: can't handle large number of INSERT/UPDATEs Iain <iain@mst.co.jp>
  0 siblings, 2 replies; 24+ messages in thread

From: Tom Lane @ 2004-10-27 03:21 UTC (permalink / raw)
  To: Curtis Zinzilieta <curtisz@norchemlab.com>; +Cc: Anjan Dave <adave@vantage.com>; Matt Clark <matt@ymogen.net>; Rod Taylor <pg@rbt.ca>; pgsql-performance

Curtis Zinzilieta <curtisz@norchemlab.com> writes:
> On Tue, 26 Oct 2004, Tom Lane wrote:
>> Er ... it *is* the other way around.  bi is blocks in (to the CPU),
>> bo is blocks out (from the CPU).

> Ummm.....
> [curtisz@labsoft T2]$ man vmstat
>        bi: Blocks sent to a block device (blocks/s).
>        bo: Blocks received from a block device (blocks/s).

You might want to have a word with your OS vendor.  My vmstat
man page says

   IO
       bi: Blocks received from a block device (blocks/s).
       bo: Blocks sent to a block device (blocks/s).

and certainly anyone who's been around a computer more than a week or
two knows which direction "in" and "out" are customarily seen from.

			regards, tom lane



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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
  2004-10-26 22:37 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-26 23:04   ` Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta <curtisz@norchemlab.com>
  2004-10-27 03:21     ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-27 04:18       ` John Meinel <john@johnmeinel.com>
  2004-10-27 06:09         ` Re: can't handle large number of INSERT/UPDATEs Matt Clark <matt@ymogen.net>
  1 sibling, 1 reply; 24+ messages in thread

From: John Meinel @ 2004-10-27 04:18 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Curtis Zinzilieta <curtisz@norchemlab.com>; Anjan Dave <adave@vantage.com>; Matt Clark <matt@ymogen.net>; Rod Taylor <pg@rbt.ca>; pgsql-performance

Tom Lane wrote:
> Curtis Zinzilieta <curtisz@norchemlab.com> writes:
> 
>>On Tue, 26 Oct 2004, Tom Lane wrote:
>>
>>>Er ... it *is* the other way around.  bi is blocks in (to the CPU),
>>>bo is blocks out (from the CPU).
> 
> 
>>Ummm.....
>>[curtisz@labsoft T2]$ man vmstat
>>       bi: Blocks sent to a block device (blocks/s).
>>       bo: Blocks received from a block device (blocks/s).
> 
> 
> You might want to have a word with your OS vendor.  My vmstat
> man page says
> 
>    IO
>        bi: Blocks received from a block device (blocks/s).
>        bo: Blocks sent to a block device (blocks/s).
> 
> and certainly anyone who's been around a computer more than a week or
> two knows which direction "in" and "out" are customarily seen from.
> 
> 			regards, tom lane
> 

Interesting. I checked this on several machines. They actually say 
different things.

Redhat 9- bi: Blocks sent to a block device (blocks/s).
Latest Cygwin- bi: Blocks sent to a block device (blocks/s).
Redhat 7.x- bi: Blocks sent to a block device (blocks/s).
Redhat AS3- bi: blocks sent out to a block device (in blocks/s)

I would say that I probably agree, things should be relative to the cpu. 
However, it doesn't seem to be something that was universally agreed 
upon. Or maybe the man-pages were all wrong, and only got updated recently.

John
=:->

Attachments:

  signature.asc (application/pgp-signature, 252B) download

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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
  2004-10-26 22:37 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-26 23:04   ` Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta <curtisz@norchemlab.com>
  2004-10-27 03:21     ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-27 04:18       ` Re: can't handle large number of INSERT/UPDATEs John Meinel <john@johnmeinel.com>
@ 2004-10-27 06:09         ` Matt Clark <matt@ymogen.net>
  2004-10-30 21:12           ` Re: can't handle large number of INSERT/UPDATEs Markus Bertheau <twanger@bluetwanger.de>
  0 siblings, 1 reply; 24+ messages in thread

From: Matt Clark @ 2004-10-27 06:09 UTC (permalink / raw)
  To: John Meinel <john@johnmeinel.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Curtis Zinzilieta <curtisz@norchemlab.com>; Anjan Dave <adave@vantage.com>; Rod Taylor <pg@rbt.ca>; pgsql-performance


>> and certainly anyone who's been around a computer more than a week or
>> two knows which direction "in" and "out" are customarily seen from.
>>
>>             regards, tom lane
>>
>
Apparently not whoever wrote the man page that everyone copied ;-)

> Interesting. I checked this on several machines. They actually say 
> different things.
>
> Redhat 9- bi: Blocks sent to a block device (blocks/s).
> Latest Cygwin- bi: Blocks sent to a block device (blocks/s).
> Redhat 7.x- bi: Blocks sent to a block device (blocks/s).
> Redhat AS3- bi: blocks sent out to a block device (in blocks/s)
>
> I would say that I probably agree, things should be relative to the 
> cpu. However, it doesn't seem to be something that was universally 
> agreed upon. Or maybe the man-pages were all wrong, and only got 
> updated recently.
>
Looks like the man pages are wrong, for RH7.3 at least.  It says bi is 
'blocks written', but an actual test like 'dd if=/dev/zero of=/tmp/test 
bs=1024 count=16384' on an otherwise nearly idle RH7.3 box gives:
   procs                      memory    swap          io     
system         cpu
 r  b  w   swpd   free   buff  cache  si  so    bi    bo   in    cs  us  
sy  id
0  0  0  75936 474704 230452 953580   0   0     0     0  106  2527   0   
0  99
 0  0  0  75936 474704 230452 953580   0   0     0 16512  376  2572   
0   2  98
 0  0  0  75936 474704 230452 953580   0   0     0     0  105  2537   
0   0 100

Which is in line with bo being 'blocks written'.

M



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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
  2004-10-26 22:37 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-26 23:04   ` Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta <curtisz@norchemlab.com>
  2004-10-27 03:21     ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-27 04:18       ` Re: can't handle large number of INSERT/UPDATEs John Meinel <john@johnmeinel.com>
  2004-10-27 06:09         ` Re: can't handle large number of INSERT/UPDATEs Matt Clark <matt@ymogen.net>
@ 2004-10-30 21:12           ` Markus Bertheau <twanger@bluetwanger.de>
  0 siblings, 0 replies; 24+ messages in thread

From: Markus Bertheau @ 2004-10-30 21:12 UTC (permalink / raw)
  To: Matt Clark <matt@ymogen.net>; +Cc: John Meinel <john@johnmeinel.com>; Tom Lane <tgl@sss.pgh.pa.us>; Curtis Zinzilieta <curtisz@norchemlab.com>; Anjan Dave <adave@vantage.com>; Rod Taylor <pg@rbt.ca>; pgsql-performance

Turns out the man page of vmstat in procps was changed on Oct 8 2002:

http://cvs.sourceforge.net/viewcvs.py/procps/procps/vmstat.8?r1=1.1&r2=1.2

in reaction to a debian bug report:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=157935

-- 
Markus Bertheau <twanger@bluetwanger.de>




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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
  2004-10-26 22:37 ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-26 23:04   ` Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta <curtisz@norchemlab.com>
  2004-10-27 03:21     ` Re: can't handle large number of INSERT/UPDATEs Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-27 05:02       ` Iain <iain@mst.co.jp>
  1 sibling, 0 replies; 24+ messages in thread

From: Iain @ 2004-10-27 05:02 UTC (permalink / raw)
  To: Curtis Zinzilieta <curtisz@norchemlab.com>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Anjan Dave <adave@vantage.com>; Matt Clark <matt@ymogen.net>; Rod Taylor <pg@rbt.ca>; pgsql-performance

Turbo linux 7 sems to be agreeing with Curtis,

bi: $B%V%m%C%/%G%P%$%9$KAw$i$l$?%V%m%C%/(B (blocks/s)$B!#(B
bo: $B%V%m%C%/%G%P%$%9$+$i<u$1<h$C$?%V%m%C%/(B (blocks/s)$B!#(B

Sorry it's in Japanese but bi says "blocks sent to block device" and bo is 
"blocks received from block device".

I don't know that much about it but the actual output seems to suggest that 
the man page is wrong. I find it just the slightest bit amusing that such 
errors in the docs should be translated faithfully when translating 
invariably introduces errors of it's own ;)

Regards
Iain


----- Original Message ----- 
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Curtis Zinzilieta" <curtisz@norchemlab.com>
Cc: "Anjan Dave" <adave@vantage.com>; "Matt Clark" <matt@ymogen.net>; "Rod 
Taylor" <pg@rbt.ca>; "Postgresql Performance" 
<pgsql-performance@postgresql.org>
Sent: Wednesday, October 27, 2004 12:21 PM
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs


> Curtis Zinzilieta <curtisz@norchemlab.com> writes:
>> On Tue, 26 Oct 2004, Tom Lane wrote:
>>> Er ... it *is* the other way around.  bi is blocks in (to the CPU),
>>> bo is blocks out (from the CPU).
>
>> Ummm.....
>> [curtisz@labsoft T2]$ man vmstat
>>        bi: Blocks sent to a block device (blocks/s).
>>        bo: Blocks received from a block device (blocks/s).
>
> You might want to have a word with your OS vendor.  My vmstat
> man page says
>
>   IO
>       bi: Blocks received from a block device (blocks/s).
>       bo: Blocks sent to a block device (blocks/s).
>
> and certainly anyone who's been around a computer more than a week or
> two knows which direction "in" and "out" are customarily seen from.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster 




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

* Re: can't handle large number of INSERT/UPDATEs
@ 2004-10-26 22:14 Anjan Dave <adave@vantage.com>
  2004-10-27 00:42 ` Re: can't handle large number of INSERT/UPDATEs Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 24+ messages in thread

From: Anjan Dave @ 2004-10-26 22:14 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Rod Taylor <pg@rbt.ca>; pgsql-performance

It just seems that the more activity there is (that is when there's a
lot of disk activity) the checkpoints happen quicker too.

Here's a snapshot from the /var/log/messages - 

Oct 26 17:21:22 vl-pe6650-003 postgres[13978]: [2-1] LOG:  recycled
transaction
log file "0000000B0000007E"
Oct 26 17:21:22 vl-pe6650-003 postgres[13978]: [3-1] LOG:  recycled
transaction
log file "0000000B0000007F"
...
Oct 26 17:26:25 vl-pe6650-003 postgres[14273]: [2-1] LOG:  recycled
transaction
log file "0000000B00000080"
Oct 26 17:26:25 vl-pe6650-003 postgres[14273]: [3-1] LOG:  recycled
transaction
log file "0000000B00000081"
Oct 26 17:26:25 vl-pe6650-003 postgres[14273]: [4-1] LOG:  recycled
transaction
log file "0000000B00000082"
...
Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [2-1] LOG:  recycled
transaction
log file "0000000B00000083"
Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [3-1] LOG:  recycled
transaction
log file "0000000B00000084"
Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [4-1] LOG:  recycled
transaction
log file "0000000B00000085"
...

I have increased them from default 3 to 15. Haven't altered the
frequency though....

Thanks,
Anjan 

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Tuesday, October 26, 2004 5:53 PM
To: Anjan Dave
Cc: Rod Taylor; Postgresql Performance
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs 

"Anjan Dave" <adave@vantage.com> writes:
> None of the locks are in state false actually.

In that case you don't have a locking problem.

> I don't have iostat on that machine, but vmstat shows a lot of writes
to
> the drives, and the runnable processes are more than 1:

I get the impression that you are just saturating the write bandwidth of
your disk :-(

It's fairly likely that this happens during checkpoints.  Look to see if
the postmaster has a child that shows itself as a checkpointer in "ps"
when the saturation is occurring.  You might be able to improve matters
by altering the checkpoint frequency parameters (though beware that
either too small or too large will likely make matters even worse).

			regards, tom lane




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

* Re: can't handle large number of INSERT/UPDATEs
  2004-10-26 22:14 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
@ 2004-10-27 00:42 ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 24+ messages in thread

From: Josh Berkus @ 2004-10-27 00:42 UTC (permalink / raw)
  To: pgsql-performance; +Cc: Anjan Dave <adave@vantage.com>; Tom Lane <tgl@sss.pgh.pa.us>; Rod Taylor <pg@rbt.ca>

Anjan,

> Oct 26 17:26:25 vl-pe6650-003 postgres[14273]: [4-1] LOG:  recycled
> transaction
> log file "0000000B00000082"
> ...
> Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [2-1] LOG:  recycled
> transaction
> log file "0000000B00000083"
> Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [3-1] LOG:  recycled
> transaction
> log file "0000000B00000084"
> Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [4-1] LOG:  recycled
> transaction
> log file "0000000B00000085"

Looks like you're running out of disk space for pending transactions.  Can you 
afford more checkpoint_segments?   Have you considered checkpoint_siblings?

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



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

* Re: can't handle large number of INSERT/UPDATEs
@ 2004-10-26 22:45 Anjan Dave <adave@vantage.com>
  0 siblings, 0 replies; 24+ messages in thread

From: Anjan Dave @ 2004-10-26 22:45 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Matt Clark <matt@ymogen.net>; Rod Taylor <pg@rbt.ca>; pgsql-performance

Ok, i was thinking from the disk perspective. Thanks!

	-----Original Message----- 
	From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
	Sent: Tue 10/26/2004 6:37 PM 
	To: Anjan Dave 
	Cc: Matt Clark; Rod Taylor; Postgresql Performance 
	Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs 
	
	

	"Anjan Dave" <adave@vantage.com> writes: 
	> One thing I am not sure is why 'bi' (disk writes) stays at 0 mostly, 
	> it's the 'bo' column that shows high numbers (reads from disk). With so 
	> many INSERT/UPDATEs, I would expect it the other way around... 

	Er ... it *is* the other way around.  bi is blocks in (to the CPU), 
	bo is blocks out (from the CPU). 

	                        regards, tom lane 



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

* Re: can't handle large number of INSERT/UPDATEs
@ 2004-10-27 03:12 Anjan Dave <adave@vantage.com>
  0 siblings, 0 replies; 24+ messages in thread

From: Anjan Dave @ 2004-10-27 03:12 UTC (permalink / raw)
  To: josh@agliodbs.com; pgsql-performance; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Rod Taylor <pg@rbt.ca>

Josh,
 
I have increased them to 30, will see if that helps. Space is not a concern. slightly longer recovery time could be fine too. Wonder what people use (examples) for this value for high volume databases (except for dump/restore)...?
 
I don't know what is checkpoint_sibling. I'll read about it if there's some info on it somewhere.
 
Thanks,
Anjan
 
-----Original Message----- 
From: Josh Berkus [mailto:josh@agliodbs.com] 
Sent: Tue 10/26/2004 8:42 PM 
To: pgsql-performance@postgresql.org 
Cc: Anjan Dave; Tom Lane; Rod Taylor 
Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs



	Anjan, 

	> Oct 26 17:26:25 vl-pe6650-003 postgres[14273]: [4-1] LOG:  recycled 
	> transaction 
	> log file "0000000B00000082" 
	> ... 
	> Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [2-1] LOG:  recycled 
	> transaction 
	> log file "0000000B00000083" 
	> Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [3-1] LOG:  recycled 
	> transaction 
	> log file "0000000B00000084" 
	> Oct 26 17:31:27 vl-pe6650-003 postgres[14508]: [4-1] LOG:  recycled 
	> transaction 
	> log file "0000000B00000085" 

	Looks like you're running out of disk space for pending transactions.  Can you 
	afford more checkpoint_segments?   Have you considered checkpoint_siblings? 

	-- 
	--Josh 

	Josh Berkus 
	Aglio Database Solutions 
	San Francisco 



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


end of thread, other threads:[~2004-10-30 21:12 UTC | newest]

Thread overview: 24+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-25 20:53 can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
2004-10-25 21:19 ` Rod Taylor <pg@rbt.ca>
2004-10-26 02:29 ` Dustin Sallings <dustin@spy.net>
2004-10-26 20:50 ` Andrew McMillan <andrew@catalyst.net.nz>
2004-10-26 08:19 FW: can't handle large number of INSERT/UPDATEs Rod Dutton <rod@e-rm.co.uk>
2004-10-26 17:42 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
2004-10-26 17:48 ` Rod Taylor <pg@rbt.ca>
2004-10-26 18:27 ` Josh Berkus <josh@agliodbs.com>
2004-10-26 17:56 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
2004-10-26 18:28 ` Matt Clark <matt@ymogen.net>
2004-10-26 21:53 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-26 21:13 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
2004-10-26 21:15 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
2004-10-26 22:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-26 23:04   ` Curtis Zinzilieta <curtisz@norchemlab.com>
2004-10-27 03:21     ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-27 04:18       ` John Meinel <john@johnmeinel.com>
2004-10-27 06:09         ` Matt Clark <matt@ymogen.net>
2004-10-30 21:12           ` Markus Bertheau <twanger@bluetwanger.de>
2004-10-27 05:02       ` Iain <iain@mst.co.jp>
2004-10-26 22:14 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
2004-10-27 00:42 ` Josh Berkus <josh@agliodbs.com>
2004-10-26 22:45 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>
2004-10-27 03:12 Re: can't handle large number of INSERT/UPDATEs Anjan Dave <adave@vantage.com>

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