pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedqueries 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