Re: [PERFORM] Table Statistics with pgAdmin III

2007-07-25 Thread Dave Page
Campbell, Lance wrote: All of the fields are zero except for the three I listed in my posting. Do you have the stats collector enabled, and row & block level stats turned on? Regards, Dave. ---(end of broadcast)--- TIP 4: Have you searched our

Re: [PERFORM] Table Statistics with pgAdmin III

2007-07-24 Thread Campbell, Lance
PROTECTED] On Behalf Of Dave Page Sent: Tuesday, July 24, 2007 12:50 PM To: Jean-Max Reymond Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Table Statistics with pgAdmin III > --- Original Message --- > From: Jean-Max Reymond <[EMAIL PROTECTED]> > To: pg

Re: [PERFORM] Table Statistics with pgAdmin III

2007-07-24 Thread Dave Page
> --- Original Message --- > From: Jean-Max Reymond <[EMAIL PROTECTED]> > To: pgsql-performance@postgresql.org > Sent: 24/07/07, 18:23:53 > Subject: Re: [PERFORM] Table Statistics with pgAdmin III > > Campbell, Lance a écrit : > > I have installed pgAdm

Re: [PERFORM] Table Statistics with pgAdmin III

2007-07-24 Thread Jean-Max Reymond
Campbell, Lance a écrit : I have installed pgAdmin III 1.6. In the tool when you click on a particular table you can select a tab called “Statistics”. This tab has all kinds of info on your table. For some reason the only info I see is for table size, toast table size and indexes size. Is t

[PERFORM] Table Statistics with pgAdmin III

2007-07-24 Thread Campbell, Lance
I have installed pgAdmin III 1.6. In the tool when you click on a particular table you can select a tab called "Statistics". This tab has all kinds of info on your table. For some reason the only info I see is for table size, toast table size and indexes size. Is there a reason that the other 1