[PERFORM] Six PostgreSQL questions from a pokerplayer

2009-07-05 Thread Patvs
I use poker software (HoldemManager) to keep track of the statistics (and show nice graphs) of millions of poker hand histories. This software (also PokerTracker 3) imports all the poker hands in PostgreSQL. The software runs on Windows) only. All of its users have NORMAL PCs. From single-core

Re: [PERFORM] Six PostgreSQL questions from a pokerplayer

2009-07-05 Thread Craig Ringer
On Sat, 2009-07-04 at 11:51 -0700, Patvs wrote: I can see two databases in my pgAdmin: postgres and HoldemManager. All the poker data (about 30 GB of data) is in the HoldemManager database. Does the quote above (if true?) means, having a 2 Ghz single core or a Xeon 2x quadcore (8x 2 Ghz

[PERFORM] Bundling postgreSQL with my Java application

2009-07-05 Thread Saurabh Dave
Hi, We are bundling PostgreSQL 8.3.7 with our Java based application. We observe that in some systems the Database access becomes very slow after running it for couple of days. We understand that postgresql.conf needs to be adjusted as per the system specification where postgreSQL is running.

Re: [PERFORM] Bundling postgreSQL with my Java application

2009-07-05 Thread Mark Mielke
On 07/06/2009 01:48 AM, Saurabh Dave wrote: We are bundling PostgreSQL 8.3.7 with our Java based application. We observe that in some systems the Database access becomes very slow after running it for couple of days. We understand that postgresql.conf needs to be adjusted as per the system