Re: [GENERAL] manual and autovacuum

On Sat, Feb 1, 2014 at 2:16 PM, prashant Pandey wrote: > Thankyou for your reply. I just want to know that what are the strting > recommended value for the vacuum parameters. The defaults values. Or at least, I will trust such values as good starting values. > As in what values are > unacceptabl

Re: [GENERAL] manual and autovacuum

Thankyou for your reply. I just want to know that what are the strting recommended value for the vacuum parameters. As in what values are unacceptable and cause problems to our database and which values will work for a normal database Regards. On 1 Feb 2014 15:15, "Luca Ferrari" wrote: > On Sat,

Re: [GENERAL] manual and autovacuum

On Sat, Feb 1, 2014 at 9:20 AM, prashant Pandey wrote: > I am looking for actual value. And please if you mention the database > condition along with the recommendation ,it will be helpfull. Maybe the question has to be reversed: what is the condition you are aiming at optimizing? Luca -- Sen

[GENERAL] manual and autovacuum

Hi all, I am working on a postgresql performance tuning tool for my project. Having done a lot of research and googling for manual and autovacuum parameters ,I have met a dead end. Could you tell me what are the recommended value for all the manual and autovacuum parameters. I am looking for a

[GENERAL] Manual for small project

Hello. I have to prepare manual to simple database in postgresql 8.4.4, Winxp+sp2. I want to store doc pages in comment field, format html. Is a better idea to store documentation ? thanks for answer -- pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Manual

Manual in spanish please -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] manual Installation for thread safety

On Wed, 2008-07-09 at 12:51 -0700, [EMAIL PROTECTED] wrote: > In order to use the --enable-thread-safety build switch I need to do a > manual build... UNLESS there is a way of doing this from the RPM > command line, which I have not been able to find. Did you install redhat-rpm-config RPM? -HTH.

Re: [GENERAL] manual Installation for thread safety

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > In order to use the --enable-thread-safety build switch I need to do a > manual build... UNLESS there is a way of doing this from the RPM command > line, which I have not been able to find. Uh ... whose RPM are you using? All the PG RPMs I know of

[GENERAL] manual Installation for thread safety

In order to use the --enable-thread-safety build switch I need to do a manual build... UNLESS there is a way of doing this from the RPM command line, which I have not been able to find. Where do I get 8.2.5-1? This version came with my installation of Fedora 8 so I presume it is the version I sho

Re: [GENERAL] Manual Vaccum very slow with Autovaccum enabled

"Andy Dale" <[EMAIL PROTECTED]> writes: > Hi, > > I am working with a 3 Postgresql databases, 1 is configured with autovaccum > enabled with the following settings: > > vacuum_cost_delay = 200 # 0-1000 milliseconds > vacuum_cost_limit = 100 # 0-1 credits ... >

[GENERAL] Manual Vaccum very slow with Autovaccum enabled

Hi, I am working with a 3 Postgresql databases, 1 is configured with autovaccum enabled with the following settings: vacuum_cost_delay = 200 # 0-1000 milliseconds vacuum_cost_page_hit = 6# 0-1 credits #vacuum_cost_page_miss = 10 # 0-1 credits #vacuu

Re: [GENERAL] Manual Installation of PostgreSQL on Windows

Thanks, It looks like a possible solution Mic andrey dmitrenko wrote: > Hello. > I think this short manual can help you > http://archives.postgresql.org /pgsql-hackers-win32/2005-07/msg00022.php > > I've installed version

Re: [GENERAL] Manual Installation of PostgreSQL on Windows

Hello.I think this short manual can help youhttp://archives.postgresql.org /pgsql-hackers-win32/2005-07/msg00022.phpI've installed version  8.1.4 without win-service registration and automatic account creation, if you meant this.--Sorry for poor English. On 6/9/06, Michael Louie Loria <[EMAIL PRO

[GENERAL] Manual Installation of PostgreSQL on Windows

Hello, Does anybody have a link or tutorial of Manual Installation of PostgreSQL on Windows? I'd like to install it manually rather than automatically. Thanks, Mic signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Manual record locking

On Mon, 8 Dec 2003, Josué Maldonado wrote: > Hello list, > > Is there a way to manual/explicit lock a record from within a plpgsql > function? SELECT ... FOR UPDATE -- Nigel Andrews ---(end of broadcast)--- TIP 5: Have you checked our extens

[GENERAL] Manual pages added to book

I have added the PostgreSQL manual pages to the appendix of my book. I will be adding an index once the publisher is done proofreading it. All reports I get are that it looks good. Addison-Wesley will be printing this book directly from a Latex-generated Postscript file that I provide. I have a