pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL performance
7+ messages / 7 participants
[nested] [flat]

* PostgreSQL performance
@ 2003-02-27 07:09 Aris Wendy <aris_postgre@telkom.net>
  0 siblings, 0 replies; 7+ messages in thread

From: Aris Wendy @ 2003-02-27 07:09 UTC (permalink / raw)
  To: pgsql-admin

Dear Master 

I have already installed postgreSQL-7.3.1 in debian woody kernel 2.4.18. I got 
some curiousity. 
1. I don't have wal_files in my postgresql.conf.
2. There is no SHMMIN,SHMSEG,SEMMNI,SEMMNS,SEMMSL,SEMMAP,SEMVMX in 
/proc/sys/kernel because I want to tune up my postgreSQL server.
3. I used HP LC Netserver P133 RAM 128, and I still used postgresql.conf 
(original). When update 2 tables in the same schema and I do it 30 times with 
the same query. The tables have 45 fields and 19000 records. Look at the 
bellow. I used vmstat command :

(at first when I turn on my PC)
   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     0  85724   1360  27652   0   0    13     1  104     7   1   0 99

(at firs time I used my database : psql csa)
   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      0  52848   1464  59396   0   0    10     4  104     5   1   0 99

(at first time I update my table)
 procs                      memory    swap          io     system         cpu
 r  b  w   swpd   free   buff  cache  si  so    bi    bo   in    cs  us  sy id
 1  0  0      0  40772   1476  70052   0   0    10     9  104     5   2   0 98

(at 11 times)
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      0   6536    456 106920   0   0    35   289  112    19  31   4 64

(at 12 times)
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    132   6548    456 106924   0   0    34   303  113    19  32   5 63

(at 30 times)
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    972   6436    488 108080   0   0    99   385  119    26  25   5 71

In my postgresql.conf : autocommit=true (by default) .....so if there is 
autcommit mode why potgreSQL still used memory and virtual memory to get 
transaction.

TIA

Best Reagards
Aris Wendy



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

* PostgreSQL Performance
@ 2004-06-09 14:34 Milosz Miecznik <michoo.inne@mga.com.pl>
  2004-06-09 16:38 ` Re: PostgreSQL Performance Scott Marlowe <smarlowe@qwest.net>
  2004-06-11 14:57 ` Re: PostgreSQL Performance Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Milosz Miecznik @ 2004-06-09 14:34 UTC (permalink / raw)
  To: pgsql-admin

Hi!

I have very important question about performance of PostgreSQL Database. How
it will work with:
- about 3000000 insert operation per day,
- about 1000000 selects per day,
- about 100 still connected users?
What hardware platform shall I use for such big database (RAM, No. of CPUs,
Hard discs capasity...?)
What operating system  shall I use? (I think about RedHat 8.x)

Can You help and reply to me, please.
Milosz Miecznik




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

* Re: PostgreSQL Performance
  2004-06-09 14:34 PostgreSQL Performance Milosz Miecznik <michoo.inne@mga.com.pl>
@ 2004-06-09 16:38 ` Scott Marlowe <smarlowe@qwest.net>
  1 sibling, 0 replies; 7+ messages in thread

From: Scott Marlowe @ 2004-06-09 16:38 UTC (permalink / raw)
  To: Milosz Miecznik <michoo.inne@mga.com.pl>; +Cc: pgsql-admin

On Wed, 2004-06-09 at 08:34, Milosz Miecznik wrote:
> Hi!
> 
> I have very important question about performance of PostgreSQL Database. How
> it will work with:
> - about 3000000 insert operation per day,
> - about 1000000 selects per day,
> - about 100 still connected users?
> What hardware platform shall I use for such big database (RAM, No. of CPUs,
> Hard discs capasity...?)
> What operating system  shall I use? (I think about RedHat 8.x)

In acceptance testing on a dual 2.8 GHz P4 with 2 gigs ram and a pair of
UWSCSI drives running under an LSI/MegaRAID320 controller, with
pg_autovacuum running in the background, I was able to handle 10,000,000
transactions in 12 hours.  That was with 250 simo connections running
40,000 transactions each.

Now, how big are your inserts?  If they're reasonable small, like
financial info, then you can easily handle 3M inserts a day.  If they're
really complex and have lots of constraints or FKs to deal with, then
maybe not.   But a Dual P4 with 2 gigs ram and a pair of mirrored hard
drives is kinda an entry level db server nowadays.  A machine with more
disk bandwidth could probably handle quite a bit more.




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

* Re: PostgreSQL Performance
  2004-06-09 14:34 PostgreSQL Performance Milosz Miecznik <michoo.inne@mga.com.pl>
@ 2004-06-11 14:57 ` Gaetano Mendola <mendola@bigfoot.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Gaetano Mendola @ 2004-06-11 14:57 UTC (permalink / raw)
  To: Milosz Miecznik <michoo.inne@mga.com.pl>

Milosz Miecznik wrote:
> Hi!
> 
> I have very important question about performance of PostgreSQL Database. How
> it will work with:
> - about 3000000 insert operation per day,
> - about 1000000 selects per day,
> - about 100 still connected users?
> What hardware platform shall I use for such big database (RAM, No. of CPUs,
> Hard discs capasity...?)
> What operating system  shall I use? (I think about RedHat 8.x)

I don't have 3000000 insert per day, but 3000000 update per day for
the rest I have more then your numbers and in 3 years I had no one
singol data loss or performance problem.


regards
Gaetano Mendola




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

* PostgreSQL Performance
@ 2005-01-11 20:48 BASEI, Sidnei R. <basei@sreb.com.br>
  0 siblings, 0 replies; 7+ messages in thread

From: BASEI, Sidnei R. @ 2005-01-11 20:48 UTC (permalink / raw)
  To: pgsql-admin

Hi all

Actually I have the Oracle Database. I am searching about others 
Databases Soluctions.

I have a server with 2 processors (XEON 2.8) and 2Gb of RAM memory.

The size of my actual Database is 5Gb and the it has 300 simultaneous 
access.

The postgreSQL provide a good performance to my application?
How I could search about?
Thank you very much...

[]´s
Sidnei



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

* Re: PostgreSQL Performance
@ 2005-01-11 21:44 Goulet, Dick <DGoulet@vicr.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Goulet, Dick @ 2005-01-11 21:44 UTC (permalink / raw)
  To: BASEI, Sidnei R. <basei@sreb.com.br>; pgsql-admin

Sidnei,

	You'll find PostGreSql and Oracle to be kindred spirits.  Similar, but different at the same time.  I  find performance very good, although you'll need to tweak the system memory parameters from the defaults and the postgresql.conf file.


Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: BASEI, Sidnei R. [mailto:basei@sreb.com.br] 
Sent: Tuesday, January 11, 2005 3:48 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL Performance

Hi all

Actually I have the Oracle Database. I am searching about others 
Databases Soluctions.

I have a server with 2 processors (XEON 2.8) and 2Gb of RAM memory.

The size of my actual Database is 5Gb and the it has 300 simultaneous 
access.

The postgreSQL provide a good performance to my application?
How I could search about?
Thank you very much...

[]´s
Sidnei

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



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

* Re: PostgreSQL Performance
@ 2005-01-11 21:47 Gregory S. Williamson <gsw@globexplorer.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Gregory S. Williamson @ 2005-01-11 21:47 UTC (permalink / raw)
  To: BASEI, Sidnei R. <basei@sreb.com.br>; pgsql-admin

Sidnei,

In principle, yes, postgres can do quite well (we use 2 CPU boxes with 2 gigs of RAM for most of our production servers), but a lot would depened on what sort of use your database gets -- all read and bulk updates ?  Or lots of updates ?  Are the queries complex ?  etc., etc.  How fast are the disk drives, and how many of them are ?

If you give people a bit more information you'll get more useful answers.

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:	BASEI, Sidnei R. [mailto:basei@sreb.com.br]
Sent:	Tue 1/11/2005 12:48 PM
To:	pgsql-admin@postgresql.org
Cc:	
Subject:	[ADMIN] PostgreSQL Performance
Hi all

Actually I have the Oracle Database. I am searching about others 
Databases Soluctions.

I have a server with 2 processors (XEON 2.8) and 2Gb of RAM memory.

The size of my actual Database is 5Gb and the it has 300 simultaneous 
access.

The postgreSQL provide a good performance to my application?
How I could search about?
Thank you very much...

[]´s
Sidnei

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend






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


end of thread, other threads:[~2005-01-11 21:47 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-27 07:09 PostgreSQL performance Aris Wendy <aris_postgre@telkom.net>
2004-06-09 14:34 PostgreSQL Performance Milosz Miecznik <michoo.inne@mga.com.pl>
2004-06-09 16:38 ` Re: PostgreSQL Performance Scott Marlowe <smarlowe@qwest.net>
2004-06-11 14:57 ` Re: PostgreSQL Performance Gaetano Mendola <mendola@bigfoot.com>
2005-01-11 20:48 PostgreSQL Performance BASEI, Sidnei R. <basei@sreb.com.br>
2005-01-11 21:44 Re: PostgreSQL Performance Goulet, Dick <DGoulet@vicr.com>
2005-01-11 21:47 Re: PostgreSQL Performance Gregory S. Williamson <gsw@globexplorer.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