[GENERAL] memory problem with refresh materialized view

anyone help me? Thanks in advantage :) Enrico -- PostgreSQL openday Rimini 27-02-2016 <http://www.postgresql.org/about/event/1861/> Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 328 4164437 - Fax +39 0861 1850310 http://www.pgtraining.com <http://www.pgtraining.com-> - i...@pg

Re: [GENERAL] Index scan vs indexonly scan method

effective to use the visibility map and pull data directly from the index data. Thank you for your answer Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 328 4164437 - Fax +39 0861 1850310 http://www.pgtraining.com

[GENERAL] Index scan vs indexonly scan method

mit is 100 and for the second the limit is 1 it seems a little bit strange...someone can help me to understand why? My develop PostgreSQL version is a 9.4 beta regards, Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 3

Re: [GENERAL] Question on explain

small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 328 4164437 - Fax +39 0861 1850310 http://www.pgtraining.com - i...@pgtraining.com www.enricopirozzi.info - i...@enricopirozzi.info Skype sscotty71 - Gtalk sscott...@gmail.com smime.p7s Descript

[GENERAL] Question on explain

stants as default_statistics_target (integer) and / or from_collapse_limit (integer) join_collapse_limit (integer) but the query plan has been the same. Can anyone help me ? Thanks, Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 328 4164

Re: [GENERAL] PostgreSQL Magazine #01 is out !

one. This is very good. > > -- >  Simon Riggs   http://www.2ndQuadrant.com/ >  PostgreSQL Development, 24x7 Support, Training & Services > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http

Re: [GENERAL] ODBC mac os

Thank you very much ;) Enrico 2010/1/29 Dave Page : > On Fri, Jan 29, 2010 at 1:29 PM, Enrico Pirozzi wrote: >> Hi, >> I would like to find an odbc driver for mac os x, >> where I can find it? >> >> Thanks to all > > If you're running the one-

[GENERAL] ODBC mac os

Hi, I would like to find an odbc driver for mac os x, where I can find it? Thanks to all regards, Enrico -- That's one small step for man; one giant leap for mankind -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [GENERAL] Records Number

-list archives on this. Thank you for your time Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 Mob.+39 328 4164437 Fax +39 0861 1850310 www.enricopirozzi.info i...@enricopirozzi.info Skype sscotty71 -- Sent via pgsql-gener

[GENERAL] Records Number

field in the pg_class table, but I need this value in real time. Any suggestion? Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 Mob.+39 328 4164437 Fax +39 0861 1850310 www.enricopirozzi.info i...@enricopirozzi.info Skype sscotty71

Re: [GENERAL] returns numbers of record

No I'm looking something else, as I wrote above :) Regards Enrico 2008/12/3 justin <[EMAIL PROTECTED]>: > Select Count(*) from (query) is what i believe you are looking for see > http://www.postgresql.org/docs/8.3/interactive/tutorial-agg.html > > > > Enric

[GENERAL] returns numbers of record

Hi all, does it exists a way to know how many records a query returns? I thought sometime like DECLARE curs1 CURSOR FOR select * from table ; I thought if I can write MOVE LAST Is there any way to return the number of row for select * from table without execute a count(*) ? Thanks :) Enrico

[GENERAL] unsigned int type

Hi all, Is it present on postgresql 8.3.x any implementation of an unsigned int type? Regards, Enrico -- That's one small step for man; one giant leap for mankind www.enricopirozzi.info [EMAIL PROTECTED] Skype sscotty71 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To