On Wed, May 26, 2010 at 5:25 AM, Cédric Villemain <
[email protected]> wrote:
> 2010/5/25 Chirag Dave :
> >
> >
> > On Tue, May 25, 2010 at 1:48 PM, Balkrishna Sharma
> wrote:
> >>
> >> Hi,
> >> I am increasing the share
SELECT reads
> from.
>
You can also use pg_stat_database view. you can compute cache reads
percentage of the total number of reads (cache and physical) between the two
snapshots using pg_stat_database.blks_hit and pg_stat_database.blks_read.
Chirag Dave 416-673-4102
Datab
On Thu, May 13, 2010 at 5:11 PM, Plugge, Joe R. wrote:
> Nevermind ... I RTFM ...
>
> echo "alter table mytable ENABLE REPLICA TRIGGER check_lockout;" | psql
> mydb
>
This is not good idea. Always run DDL script using Slony execute script.
http://www.slony.info/documentation/ddlchanges.html
You other option is to use Slony. Create replica and in a short outage you
can move master to replica.
Chirag Dave 416-673-4102
Database Administrator, Afilias Canada Corp.
[email protected]
On Wed, May 5, 2010 at 11:27 AM, raghu ram wrote:
> Hi Postgres Guru's,
>
>
>
running, to log all slower statement.
Chirag Dave
DBA, Afilias
On Wed, Oct 8, 2008 at 8:31 AM, Rafael Domiciano <[EMAIL PROTECTED]
> wrote:
> The server is running Postgres 8.2.4When the server is doing too much
> operations like I, U or D the postgres stop a while each 5 min...!
> I
What version of postgres are you running ? and please also provide more
information about your suspected slowdown ?
On Tue, Oct 7, 2008 at 4:21 PM, Rafael Domiciano <[EMAIL PROTECTED]
> wrote:
> Hello there,
> I'm having some slowndowns in my postgresql server, and I had been reading
> someth
tats ? if table/tables are candidate for vacuuming after
crash recovery will never get auto-vac unless you do 'ANALYZE' twice.
Thanks in advance,
Chirag Dave
DBA
Afilias
Assuming you are are running 8.3, you can do this:
SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where
a.oid=b.enumtypid and a.typname='NAME_OF_ENUM';
Chirag Dave
Afilias
On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <[EMAIL PROTECTED]> wrote:
> Hi admins,
>
&g
