| From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
|---|---|
| To: | moises <moises(at)cedaivc(dot)co(dot)cu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Transaction Speed |
| Date: | 2006-07-20 21:18:01 |
| Message-ID: | 44BFF309.4000104@sun.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
moises wrote:
> Can any body talk me how many transactions make postgres in a second?
>
It depends on many things
1) speed of hardware/OS/number of disks/type of disks, if you use RAID
or not ...
2) number concurrent access
3) size of processed data in one transaction
4) database model
...
It not possible determine. You must take some machine and perform some
own test.
>
>
>
> I’m very interesting in this data, because I want to use postgres for a
> real time database for process control.
I'm not sure if postgres is good database for real time application. You
need know maximal response time for realtime application and I afraid
that postgres is not good choice for RTA. (MySQL, Firebird, Oracle ...
have same limitation ...)
Zdenek
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua Reich | 2006-07-20 21:21:17 | Using EXPLAIN in regressions? |
| Previous Message | Adnan DURSUN | 2006-07-20 21:04:34 | Re: Transaction Speed |