Are you using the default settings in postgresql.conf? If so you will need to
tinker with the memory settings such as shared_buffers (I've currently set
mine to 1000 but am still learning and testing).
The default configuration is designed to ensure that postgres will start up
on as many installations as possible. It is not configured for performance -
that is left as an exercise for the DBA based on his/her individual
requirements. Search the archives for lots of tips.
Cheers,
Steve
On Wednesday 12 March 2003 6:27 am, Stefan Sturm wrote:
> Hello,
>
> we have a performance problem with PostgreSQL 7.2.4. But first I try to
> explain our situation:
>
> We have an online game. This game is a fantasy game, where you can buy
> and sell players for your team.
> All players for the teams are stored in one table. So in this table we
> have just one primary key and to foreign keys.
> When we have around 500 Users at one time on the maschine, the game is
> slowing down(Time for one spage up to 1minute and more). And I think
> the problem is this table. There are a lot of reading and writing
> connections to this table.
>
> So now my question: What can I do to increase the performance?
>
> Thanks and greetings,
>
> Stefan Sturmn
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
