[ADMIN] Help needed to set the Optimal Value for shared_buffers.

2005-07-02 Thread Kishore B
Hi, I have a couple of issues. One is regarding a file called 'fsync' and the other is related to the sharedBuffers issue. 1) I am new to administering postgresql. When I was wandering through the configuration files for the PostgreSQL, I observed the 'fsync' file. This file is almost

Re: [ADMIN] Help needed to set the Optimal Value for shared_buffers.

2005-07-02 Thread Tom Lane
Kishore B [EMAIL PROTECTED] writes: 1) I am new to administering postgresql. When I was wandering through the configuration files for the PostgreSQL, I observed the 'fsync' file. This file is almost identical to the postgresql.conf file, but with differing values for parameters and some new

[ADMIN] Help needed in setting parameters for postgresql.conf

2004-10-03 Thread Madhukar Gole
Hi I am working on a real time application.I have a table which has 1 rows and 31 columns.It is updated every 5 secs.But only a max of 5000 rows may be updated.And Updates effect only about 10 columns.The postgresql.conf file is given below.I donot know what values the parameters should

Re: [ADMIN] Help needed Please !!!!!incremental backups possible in

2003-12-19 Thread scott.marlowe
On Fri, 19 Dec 2003, Priya G wrote: Hi all,   Is Incremental backups possible in Postgres 7.3 or 7.4 Nope. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] help needed!!!

2003-09-23 Thread Priya G
Since I am a novice can you explain more about this version mismatch? From: Bruce Momjian [EMAIL PROTECTED] To: Priya G [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [ADMIN] help needed!!! Date: Mon, 22 Sep 2003 14:46:27 -0400 (EDT) Priya G wrote: [ text/html is unsupported, treating like

Re: [ADMIN] help needed!!!

2003-09-23 Thread scott.marlowe
explain more about this version mismatch? From: Bruce Momjian [EMAIL PROTECTED] To: Priya G [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [ADMIN] help needed!!! Date: Mon, 22 Sep 2003 14:46:27 -0400 (EDT) Priya G wrote: [ text/html is unsupported, treating like TEXT/PLAIN

Re: [ADMIN] help needed!!!

2003-09-23 Thread Peter Eisentraut
scott.marlowe writes: Sure, basically, modern versions of the client library can talk to older versions of the database backend up to a point (i.e. the 7.4 library in beta can go back to 6.5 or 6.4 or something like that. Support for 6.2 or thereabouts was recently dropped.) However, going

Re: [ADMIN] help needed!!!

2003-09-22 Thread Bruce Momjian
Priya G wrote: [ text/html is unsupported, treating like TEXT/PLAIN ] htmldiv style='background-color:'DIV DIVHi all,/DIV DIVnbsp;/DIV DIVnbsp;The following message was found in the postgres log/DIVpostgres[20563]: [73256] FATAL 1: invalid length of startup packet DIVnbsp;what

[ADMIN] help needed!!!

2003-09-22 Thread Priya G
Hi all, The following message was found in the postgres logpostgres[20563]: [73256] FATAL 1: invalid length of startup packet what does this mean? Thanks Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now!

Re: [ADMIN] help needed for performance tuning

2003-08-01 Thread Corey . Brune
] Subject: [ADMIN] help needed for performance tuning gresql.org

Re: [ADMIN] help needed for performance tuning

2003-08-01 Thread Priya Nair
: Friday, August 01, 2003 9:49 AM To: Priya Nair Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] help needed for performance tuning How is your query written, and are you dealing with any referential interegrity? Corey