[GENERAL] Is it typo in pg_stat_replication column name in PG 9.4 ?

Hi, PostgreSQL 9.4 document for pg_stat_replication view mentions column name as "backend_xid", whereas when a view described it shows column name as "backend_xmin". http://www.postgresql.org/docs/devel/static/monitoring-stats.html#PG-STAT-REPLICATION-VIEW postgres=# select version(); -[ RECORD 1

[GENERAL] materialised views vs unlogged table (also, ize vs ise)

HI all, I’m curious about materialised views. I was just setting something up, and noticed there is no support for UNLOGGED materialised views (http://www.postgresql.org/message-id/E1UZNrD-0008Eh-83@gemulon.postgresql.o rg) I also notice that the creation of an unlogged table appears to be a lot

[GENERAL] How to solve the problem "error reading c:\Program Files\PostgreSQL\9.3\data\postgresql.conf during installation"

When I encountered the error in reading the postgresql.conf file I googled and found the answer at error reading c:\Program Files\PostgreSQL\8.3\data\postgresql.conf during installation.But I am unable to execute the answer since w

Re: [GENERAL] materialised views vs unlogged table (also, ize vs ise)

On 05/18/2014 05:47 PM, Tim Kane wrote: > Oh, I also noticed we don’t support alternate spellings of > MATERIALIZE, as we do for ANALYZE. > I’m not sure if we do this anywhere else, maybe it’s just analyze > being the odd one out. For the moment, if not forever, ANALYSE is the odd one out. http:

Re: [GENERAL] 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION

On 17 May 2014 13:25, Thomas Kellerer wrote: > Hello, > > when playing with 9.4 beta I noticed that the result of pg_get_viewdef() > will not include the new WITH CHECK OPTION clause when the view was created > using it. > > Is that intended (if so: why?) or is this an oversight/bug? > Yes, that'

Re: [GENERAL] materialised views vs unlogged table (also, ize vs ise)

On Mon, May 19, 2014 at 6:47 AM, Tim Kane wrote: > Aside from the convenience of the REFRESH functionality, are there any other > factors I should consider? An exclusive lock is taken on the materialized view during a REFRESH operation, blocking an read or write queries attempted on them. You can

Re: [GENERAL] How to solve the problem "error reading c:\Program Files\PostgreSQL\9.3\data\postgresql.conf during installation"

On 05/18/2014 03:00 PM, Varuna Seneviratna wrote: When I encountered the error in reading the postgresql.conf file I googled and found the answer at error reading c:\Program Files\PostgreSQL\8.3\data\postgresql.conf during installation

Re: [GENERAL] 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION

Dean Rasheed writes: > On 17 May 2014 13:25, Thomas Kellerer wrote: >> when playing with 9.4 beta I noticed that the result of pg_get_viewdef() >> will not include the new WITH CHECK OPTION clause when the view was created >> using it. > Yes, that's correct. pg_get_viewdef() only returns the und

[GENERAL] slow query question: more indexes considered harmful

Hi, I have typical setup consisting of two tables (demography and ses) with a typical filter-join-groupby-orderby query. Schemas: demography (pid int, countyid int) ses (pid int, exposed_time int) query: select countyid, count(pid) from demography, ses where demography.pid = ses.pid and expose

Re: [GENERAL] 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION

Dean Rasheed wrote on 19.05.2014 01:10: when playing with 9.4 beta I noticed that the result of pg_get_viewdef() will not include the new WITH CHECK OPTION clause when the view was created using it. Is that intended (if so: why?) or is this an oversight/bug? Yes, that's correct. pg_get_viewde