* A database that is of small to medium size (5 - 10 GB)?
* Around 10 clients that perform constant write operations to the database
(UPDATE/INSERT)
* Around 10 clients that occasionally read from the database
* Around 6000 tables in your database
* A problem with tuning it all
* Migration to ne
> 2) Which Windows OS would you recommend? (currently 2008 x64 Server)
Would not recommend Windows OS.
BTW, I'd be interested to know the NTFS fragmentation stats of your
database file.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
El 15/01/2010 14:43, Ivan Voras escribió:
hi,
You wrote a lot of information here so let's confirm in a nutshell
what you have and what you are looking for:
* A database that is of small to medium size (5 - 10 GB)?
* Around 10 clients that perform constant write operations to the
database (U
On Fri, Jan 15, 2010 at 8:43 AM, Ivan Voras wrote:
> Have you tried decreasing random_page_cost in postgresql.conf? Or setting
> (as a last resort) enable_seqscan = off?
If you need to set enable_seqscan to off to get the planner to use
your index, the chances that that index are actually going t
hi,
You wrote a lot of information here so let's confirm in a nutshell what
you have and what you are looking for:
* A database that is of small to medium size (5 - 10 GB)?
* Around 10 clients that perform constant write operations to the
database (UPDATE/INSERT)
* Around 10 clients that occ