Re: [ADMIN] Internal fragmentations statistics Was: VACUUM FULL memory requirements

2009-12-15 Thread Guillaume Lelarge
Le mercredi 16 décembre 2009 à 06:18:45, Gurjeet Singh a écrit : > 2009/12/15 Guillaume Lelarge > > > Le mardi 15 décembre 2009 à 00:04:47, Evan Rempel a écrit : > > > Is there a command/tool that will report on how FULL a table is > > > getting? If there is, how intrusive is it? How computationa

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009-12-15 Thread Brian Modra
2009/12/15 Su, Alan : > Brian, > > What you mentioned below is more sophisticated than what I am capable of > doing now. Could you or anyone on this email recommend other tool that meets > the following requirements: > > 1. Require less programming effort. I am trying to stay away from having to

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread ABBAS SHAKEEL
Thanks Scott, Your comments are of worth. I feel relatively clear with this concept and i stopped my mind as well from comparing inheritance concept with JAVA by saying that inheritance concept in humans, in JAVA and in Postgres is different in many aspects. I would like to share an example as

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread Scott Marlowe
On Wed, Dec 16, 2009 at 12:01 AM, ABBAS SHAKEEL wrote: > Thanks Scott > you are right . It inherits structure only and i don't know whether to call > to it an advantage or disadvantage that it query the children table as well > while select. But in case of insert and update this concepts takes a n

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread ABBAS SHAKEEL
Thanks Scott you are right . It inherits structure only and i don't know whether to call to it an advantage or disadvantage that it query the children table as well while select. But in case of insert and update this concepts takes a new turn. How inheritance effect data? Can you please briefly c

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread Scott Marlowe
On Tue, Dec 15, 2009 at 11:36 PM, ABBAS SHAKEEL wrote: > Hello > I am not an expert for database but rarely design database for Web and IVR > applications. > Today I wonder if there is any practical advantage of inheritance of Tables. > Lets take the same example that is commonly referred. > > CRE

[ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread ABBAS SHAKEEL
Hello I am not an expert for database but rarely design database for Web and IVR applications. Today I wonder if there is any practical advantage of inheritance of Tables. Lets take the same example that is commonly referred. CREATE TABLE cities ( nametext, population f

Re: [ADMIN] Internal fragmentations statistics Was: VACUUM FULL memory requirements

2009-12-15 Thread Gurjeet Singh
2009/12/15 Guillaume Lelarge > Le mardi 15 décembre 2009 à 00:04:47, Evan Rempel a écrit : > > Is there a command/tool that will report on how FULL a table is getting? > > If there is, how intrusive is it? How computationally heavy is it? > > > > We have a database that is approx 100 million rows

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009-12-15 Thread Kevin Grittner
"Su, Alan" wrote: > 1. Require less programming effort. I am trying to stay away from > having to write sophisticate programming language, such as Java or > .Net > 2. Allow to bundle SQL commands in store procedure like style. > 3. Allow to evaluate conditions of SQL result set and trigger > ale

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009-12-15 Thread Su, Alan
Brian, What you mentioned below is more sophisticated than what I am capable of doing now. Could you or anyone on this email recommend other tool that meets the following requirements: 1. Require less programming effort. I am trying to stay away from having to write sophisticate programming l

[ADMIN] encoding error in new Postgres version

2009-12-15 Thread Mark Steben
Good morning We recently (last month) upgraded from postgres 8.2 to 8.3. We run linux redhat on our production servers, although a couple Of our developers run Windows XP 32 bit. They restore a pg_dump Copy of our production database onto their local machine. In 8.2 they had no problem

Re: [ADMIN] Internal fragmentations statistics Was: VACUUM FULL memory requirements

2009-12-15 Thread Guillaume Lelarge
Le mardi 15 décembre 2009 à 00:04:47, Evan Rempel a écrit : > Is there a command/tool that will report on how FULL a table is getting? > If there is, how intrusive is it? How computationally heavy is it? > > We have a database that is approx 100 million rows with > approx 2 million insert/updates