Re: [GENERAL] Need help for constructing query

Marco Friday 25 March 2011 14:25:47 > Hi, > > I have a table like this: > > iddatemin max value > 1 2011-03-25 20 30 17 > 3 2011-03-21 40 55 43 > 3 2011-03-23 40 55 52 > 2 2011-02-25 5 2 > 4

[GENERAL] index bloat query understand

I got a query to calculate index bloat as follows: http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html --- CREATE OR REPLACE VIEW bloat AS SELECT schemaname, tablename, reltuples::bigint, relpages::bigint, otta, ROUND(CASE WHEN otta=0 THEN 0.0 ELSE sml.relpages/o

Re: [GENERAL] Need help for constructing query

On 2011-03-27 rsmog...@softperience.eu (Radosław Smogura) wrote: > Marco Friday 25 March 2011 14:25:47 > > Hi, > > > > I have a table like this: > > > > id datemin max value > > 1 2011-03-25 20 30 17 > > 3 2011-03-21 40 55 43 > > 3 2011-0