* 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
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
On Fri, Jan 15, 2010 at 8:43 AM, Ivan Voras ivo...@freebsd.org 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
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
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
