Re: [ADMIN] Reg - Statistics - Postgres 8.3

[Albe Laurenz]

Hariraman Jayaraj wrote:
 We are using Postgres 8.3 version, in Suse Linux Enterprise Edition
SP1. Our DB total size is around
 530 GB. we have enabled the setting related to
default_statistics_target. Kindly suggest what will be
 ideal value for default_statistics_target.
 
 We have more than 1000 relations in our db.

This parameter determines how detailed the statistics
gathered with ANALYZE (and autoanalyze) will be.

You need to increase this parameter from its default
value only if the query plans for your statements are
not good and better statistics can improve them.

There is no connection to the size of the database or
the number of tables.

Monitor for statements that take too much time; if
improving the statistics makes them faster, consider
adjusting the parameter (possibly only for a single
column with ALTER TABLE).

If you are concerned about good execution plans,
consider upgrading to a more recent version.
That would be a good idea anyway.

Yours,
Laurenz Albe


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Backup

[Lonni J Friedman]

I can generate a backup using pg_dump on a slave with 9.2.1.  No clue
if it works with 9.1.x (or older) versions though.

On Thu, Nov 29, 2012 at 5:17 PM, Sabry Sadiq ssa...@whispir.com wrote:
 Pg_dump



 Sabry Sadiq
 Systems Administrator

 Whispir
 Level 30 360 Collins Street
 Melbourne / Victoria 3000 / Australia
 GPO Box 130 / Victoria 3001 / Australia
 T +61 3 8630 9900 / M +61 428 571 636
 F +61 3 8630 9990 / E mailto:ssa...@whispir.com
 1300 WHISPIR / 1300 944 774
 www.whispir.com




 This communication contains information which is confidential and the 
 copyright of Whispir or a third party.  If you have received this email in 
 error please notify us by return email or telephone Whispir on 1300 WHISPIR 
 (1300 9447747) or +613 8630 9900 and  delete the document and delete all 
 copies immediately. If you are the intended recipient of this communication 
 you should not copy, disclose or distribute this communication without the 
 authority of Whispir. Any views expressed in this Communication are those of 
 the individual sender, except where the sender specifically states them to be 
 the views of Whispir. Except as required at law, Whispir does not represent, 
 warrant and/or guarantee that the integrity of this communication has been 
 maintained nor that the communication is free of errors, virus, interception 
 or interference.


 -Original Message-
 From: Lonni J Friedman [mailto:netll...@gmail.com]
 Sent: Friday, 30 November 2012 12:17 PM
 To: Sabry Sadiq
 Cc: pgsql-admin@postgresql.org
 Subject: Re: [ADMIN] Backup

 *how* are the backups being generated?

 On Thu, Nov 29, 2012 at 5:16 PM, Sabry Sadiq ssa...@whispir.com wrote:
 Currently backups are performed on the master database and I want to
 offload that load to the standby



 Sabry Sadiq
 Systems Administrator

 Whispir
 Level 30 360 Collins Street
 Melbourne / Victoria 3000 / Australia
 GPO Box 130 / Victoria 3001 / Australia T +61 3 8630 9900 / M +61 428
 571 636 F +61 3 8630 9990 / E mailto:ssa...@whispir.com
 1300 WHISPIR / 1300 944 774
 www.whispir.com


 -Original Message-
 From: Lonni J Friedman [mailto:netll...@gmail.com]
 Sent: Friday, 30 November 2012 12:15 PM
 To: Sabry Sadiq
 Cc: pgsql-admin@postgresql.org
 Subject: Re: [ADMIN] Backup

 I don't know, I've never tried.  If I had to guess, I'd say no, as that 
 version doesn't support cascading replication.

 You never stated, how are you currently performing backups?

 On Thu, Nov 29, 2012 at 5:13 PM, Sabry Sadiq ssa...@whispir.com wrote:
 Does it work well with version 9.1.3?



 Sabry Sadiq
 Systems Administrator

 Whispir


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] base backup requirements for PITR

[Gabriele Bartolini]

Hi Andrew,

Il 29/11/12 02:52, Andrew W. Gibbs ha scritto:

That said, I'm wondering whether I created the base backup with
reliably correct procedures or merely was lucky.
PostgreSQL documentation on how continuous archiving works is clear, but 
you need to follow exactly what it says and have a clear understanding 
and how Postgres works.


In order to simplify the management of disaster recovery solutions for 
PostgreSQL, we have recently developed and distributed an open source 
project called Barman.
I am not sure whether you have looked at it or not. In this case, I 
suggest you give it a go. More information at http://www.pgbarman.org/


It is also available as RPM and Debian/Ubuntu package and works from 
PostgreSQL 8.4 onwards.


Barman takes care of backups, works remotely and assist DBAs during 
recovery (both local to the backup server or remote).


Cheers,
Gabriele

--
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin