HI people,
I'm tuning a server that is a long time abandoned, and this server is a
little slow.
Now, in my postgresql.conf I have:
shared_buffers = 100Mb
mas_fsm_relations = 15000
mas_fsm_pages = 160
max_connections = 300
And I changin' to:
shared_buffers = 1000Mb
(The server has 2 Gb of me
yes, remove the comment character.
And further more, find my email post with subject "log_statement at
postgres.conf"
Regards,
Joko [IT/EDP]
PT. Indra Jaya Swastika
Phone: +62 31 7481388 Ext 201
http://www.ijs.co.id
Marc Fromm wrote:
We would like to log sql activity from our web pages t
Hi Rafael,
The result there means that the minimal should be 4.69Mb for
shared_buffers
As a rule of thumb the shared buffers should be between 10% - 15% of
available RAM that assuming such is a dedicated PG server.
I have worked on some servers where I set shared buffers lower than
10%, it
On Mon, Oct 6, 2008 at 5:52 AM, Rafael Domiciano
<[EMAIL PROTECTED]> wrote:
> HI people,
> I'm tuning a server that is a long time abandoned, and this server is a
> little slow.
What version pgsql is it running? If it's 7.4 or before, you should
look at upgrading it. If you can't then a shared b
Hi All,
I have use the Postgres database as a client/server architecture.
I mean I want to run the clients on different PCs and want that all
the transactions should get automatically updated in the server.
It should also take care of network disconnections and update the
server after network conn
Hello the list
I have a problem with an sql command and I not understand what is happens.
I execute this query and the result is ok :
db_stats=# SELECT code, label, typecumul FROM table_f801_cat_period
INNER JOIN table_cat_period USING (code) WHERE typecumul = 0 EXCEPT
SELECT code_base, label,
I'm using 8.3.3 version in this machine..!So, the shared_buffers set to
100Mb is ok? Or 500Mb is better?
This server we call "Reporter Server", so it's used to do heavy reports for
a few users only (I could say 5 users).
What could be the best config for my server with:
2 Gb RAM
300 GB HD
Postgres
On Mon, Oct 6, 2008 at 7:56 AM, Rafael Domiciano
<[EMAIL PROTECTED]> wrote:
> I'm using 8.3.3 version in this machine..!
> So, the shared_buffers set to 100Mb is ok? Or 500Mb is better?
> This server we call "Reporter Server", so it's used to do heavy reports for
> a few users only (I could say 5 u
On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have use the Postgres database as a client/server architecture.
> I mean I want to run the clients on different PCs and want that all
> the transactions should get automatically updated in the server.
> It s
Guy Deleeuw <[EMAIL PROTECTED]> writes:
> Now I execute this query that request one column more, the "ind" field.,
> the return of this query is bad.
You didn't say what you think is bad about it ... but in any case I'll
bet that this bit isn't doing what you want:
... AND (ind=ind) ...
On Mon, Oct 6, 2008 at 10:08 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid <[EMAIL PROTECTED]> wrote:
>> Hi All,
>>
>> I have use the Postgres database as a client/server architecture.
>> I mean I want to run the clients on different PCs and want th
On Mon, Oct 6, 2008 at 9:00 AM, Rich <[EMAIL PROTECTED]> wrote:
> On Mon, Oct 6, 2008 at 10:08 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>> On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid <[EMAIL PROTECTED]> wrote:
>>> Hi All,
>>>
>>> I have use the Postgres database as a client/server architec
Kellyton Campos Feitosa - GYN wrote:
Dears,
I need monitor a postgres database, but I don’t know which tool to use.
The tool need perform the below actions
1. show transactions pendents
2. show the statistics per session actives
3. show the statistics per database
4. show metrics
I'd say, don't overwhelm the original ask-er. Let him explain this problem
statement again.
So far we know he wants a client server.
Rashid,
Do you want thin client (like web based) or thick like X11 or Java or VB
client?
Do you want the data processing be on the server (more reliable but
slower),
Hi All,
I think there is some confusion regarding this.
I want postgres to be installed at two different PCs.Then the data
from each postgres should be automatically updated to the third PC
which we call server.
This process should be automatic. It should also take care of network
disconnection be
On Mon, Oct 6, 2008 at 1:54 PM, Mohammed Rashid <[EMAIL PROTECTED]> wrote:
> I just want to ask whether the Postgres database supports this or not?
> Or I have to write an application to do so.
Not natively. You could do it via some Slony trickery, but it would
be very advanced and difficult to m
On Oct 2, 2008, at 12:51 PM, Carol Walter wrote:
I'm trying to configure Postgres on a test box to I can the upgrade
my production box. I am getting an error as follow:
configure:17671: checking test program
configure:17686: gcc -o conftest -O2 -Wall -Wmissing-prototypes -
Wpointer-arith -Wi
HI Jeff,
Thank you for the link to explain FSM however I understand the concept where
it would be faster to know where to store data based on an insert or an
update but the results of the last few lines of the verbose I still don't get
it.
Our max_fsm_relations = 1000 and max_fsm_pages=153600
That output looks good with your settings. It means you are using 501 of the
1000 max_fsm_relations and 57328 of the 153600 max_fsm_pages.
The check_postgres.pl nagios plugin that Greg Sabino Mullane maintains
recently added a check for FSM settings. Check it out here:
http://bucardo.org/ch
On Fri, 03 Oct 2008 13:21:46 GMT, Julie Warden
<[EMAIL PROTECTED]> wrote:
>Group,
>
>I have a postgres implementation with approximately 150 databases.
>This was not my choice, but what I was given.
>
>What I need to do is backup individual databases and be able to
>restore any database along with
20 matches
Mail list logo
