Ok Vick, thanks, and sorry for the off-list message.
regards,
Carl
2011/4/8 Vick Khera
>
> On Fri, Apr 8, 2011 at 9:53 AM, Gipsz Jakab wrote:
>
>> Thanks Vick, I'll try it tonight. I will give 1024 shared_buffers and
>> maintenance_work_mem, and 102 MB of work_mem.
>>
>> A question: I didn't us
I think, the main problem is the following: all of the user are autheticated
in the psql with the same username, and the thing, that you've mentioned,
the locks (I will talk with the programmer, or create new users in the psql,
and modify the ODBC settings at the client side). How can I setup a sho
Thanks Vick, I'll try it tonight. I will give 1024 shared_buffers and
maintenance_work_mem, and 102 MB of work_mem.
A question: I didn't use (it's marked with #) the effective_planner (or any
other planner method or config option). Is it ok, when I turn it on with
that parameter: 1036MB?
DROP/ADD
On Fri, Apr 8, 2011 at 9:53 AM, Gipsz Jakab wrote:
> Thanks Vick, I'll try it tonight. I will give 1024 shared_buffers and
> maintenance_work_mem, and 102 MB of work_mem.
>
> A question: I didn't use (it's marked with #) the effective_planner (or any
> other planner method or config option). Is i
On Fri, Apr 8, 2011 at 3:00 AM, Gipsz Jakab wrote:
> After the settings in the postgresql.conf our system is much faster, and no
> more error messages in the postgres.log, but If I try to drop a table, or
> add a new one, our system is stopping, until I kill the process, which is
> dropping or add
On Fri, Apr 8, 2011 at 4:00 AM, Gipsz Jakab wrote:
> My question is the following: if this is a dedicated database server, with
> maximum 30 users (but they are using ODBC with Microsoft Acces, and each of
> them generating 4-6 connection at the same time), and other 200 people will
> use this se
