[HACKERS] calculated fields are not seen in the WHERE clause

Hello, OK select 1 as ccc where 1=1 ERROR select 1 as ccc where ccc=1 PostgreSQL said: ERROR: Attribute 'ccc' not found Is there any way to set conditions on calculated fields values? Best regards, Yar ---(end of broadcast)--- TIP 3: if posting

Re: [HACKERS] []performance issues

Christopher Kings-Lynne wrote: >Doing a row count requires a sequential scan in Postgres. > >Try creating another summary table that just has one row and one column and >is an integer. > > I have THREE summary tables derived from "stats" with different levels of aggregation. They work quite

[HACKERS] []performance issues

Hello, Sorry if it's wrong list for the question. Could you suggest some tweaks to the PostgreSQL 7.2.1 to handle the following types of tables faster? Here we have table "stats" with something over one millon records. Obvious "SELECT COUNT(*) FROM stats " takes over 40 seconds to execute,