pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
queries per second
3+ messages / 3 participants
[nested] [flat]

* queries per second
@ 2001-12-15 05:23 Timur V. Irmatov <thor@sarkor.com>
  2001-12-15 06:11 ` Re: queries per second Horst Herb <hherb@malleenet.net.au>
  2001-12-15 23:34 ` Re: queries per second Chris Ruprecht <chrup999@yahoo.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Timur V. Irmatov @ 2001-12-15 05:23 UTC (permalink / raw)
  To: pgsql-sql

Hello, All!

I'd like to know the approximate number of simple queries (update a
row, select just one row) PostgreSQL is able to perform per second?
(Machine is PII-Celeron 600 with 256 RAM)
These queries will be combined by 2-3 in transactions.

Thanks in advance.
Timur.




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

* Re: queries per second
  2001-12-15 05:23 queries per second Timur V. Irmatov <thor@sarkor.com>
@ 2001-12-15 06:11 ` Horst Herb <hherb@malleenet.net.au>
  1 sibling, 0 replies; 3+ messages in thread

From: Horst Herb @ 2001-12-15 06:11 UTC (permalink / raw)
  To: pgsql-sql

On Saturday 15 December 2001 16:23, Timur V. Irmatov wrote:

> I'd like to know the approximate number of simple queries (update a
> row, select just one row) PostgreSQL is able to perform per second?
> (Machine is PII-Celeron 600 with 256 RAM)
> These queries will be combined by 2-3 in transactions.

You will probably get the most accurate answer to your question by simply 
trying it out yourself on your machine (while verying performance 
sensitive parameters such as buffer allocation). Will probably take you 
less time than reading answers on this list.

Horst



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

* Re: queries per second
  2001-12-15 05:23 queries per second Timur V. Irmatov <thor@sarkor.com>
@ 2001-12-15 23:34 ` Chris Ruprecht <chrup999@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Chris Ruprecht @ 2001-12-15 23:34 UTC (permalink / raw)
  To: Timur V. Irmatov <thor@sarkor.com>; +Cc: pgsql-sql

Hello Timur,

At 10:23 +0500 12/15/2001, Timur V. Irmatov wrote:
>Hello, All!
>
>I'd like to know the approximate number of simple queries (update a
>row, select just one row) PostgreSQL is able to perform per second?
>(Machine is PII-Celeron 600 with 256 RAM)
>These queries will be combined by 2-3 in transactions.

This is very dependent on what type of queries you are doing. You can 
have many queries requesting data which is already in a buffer, so 
that no disk read access is required or you can have reads, which 
actually require disk access. If you database is small and you have 
enough memory, you might have all the data in memory at all times - 
access would be very fast then, you might get 100+ queries/second.
If you need to read a disk, you are dependant an you hardware. I have 
opted for an UltraSCSI-160 controller with UltraSCSI-160 drives, the 
fastest option you can get on a PC type platform. I process about 
75'000 records every night (they get downloaded from another server). 
For each record I process, the program makes about 4 - 10 queries to 
put the new record into the correct 'slot'. The entire process takes 
about 3 minutes. I'm running this on an 850 MHz AMD Athlon machine 
with 768 MB of RAM.
Hope this gives you a little indication about the speed.

Best regards,
Chris
-- 
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




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


end of thread, other threads:[~2001-12-15 23:34 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-15 05:23 queries per second Timur V. Irmatov <thor@sarkor.com>
2001-12-15 06:11 ` Horst Herb <hherb@malleenet.net.au>
2001-12-15 23:34 ` Chris Ruprecht <chrup999@yahoo.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