[GENERAL] Postgres 9.4.4/9.4.6: plpython2/3 intallation issues on a Windows 7 machine

2016-03-31 Thread margrit drescher
I installed postgres 9.4.6 on my Windows 7 (64-bit) machine, and managed to create the plpython3u extension without a problem. I then restored an existing DB (created in postgres 9.3). The plpython3 functions restored without a hitch and can execute. However, as soon as I try to create a NEW pl

Re: [GENERAL] Postgres 9.4.4/9.4.6: plpython2/3 intallation issues on a Windows 7 machine

2016-03-31 Thread Alex Ignatov
On 31.03.2016 10:50, margrit drescher wrote: I installed postgres 9.4.6 on my Windows 7 (64-bit) machine, and managed to create the plpython3u extension without a problem. I then restored an existing DB (created in postgres 9.3). The plpython3 functions restored without a hitch and can execut

[GENERAL] Re: Postgres 9.4.4/9.4.6: plpython2/3 intallation issues on a Windows 7 machine

2016-03-31 Thread margrit drescher
I originally used the 9.4.6 version on http://www.enterprisedb.com/products-services-training/pgdownload#windows for 64-bit windows and loaded the language pack recommended in the readme file. On 31 March 2016 at 11:25, Alex Ignatov-2 [via PostgreSQL] < ml-node+s1045698n5896174...@n5.nabble.com> w

Re: [GENERAL] More correlated (?) index woes

2016-03-31 Thread Geoff Winkless
On 31 Mar 2016 03:02, "bricklen" wrote: > Perhaps a partial index like "create index pa_sc_id_pidx on pa (sc_id) with > (fillfactor=100) where field1 IS NULL;" will help? Thanks for the suggestion. It might, but the problem with that is there's (something like) field2-16 which are used in simil

Re: [GENERAL] Multixacts wraparound monitoring

2016-03-31 Thread Pavlov, Vladimir
Hello, If I get you right: Latest checkpoint's NextMultiXactId:2075246000 Latest checkpoint's oldestMultiXid: 2019511697 Number of members files:10820 Size pg_multixact/members/ (bytes) (2.7Gb): 2887696384 Pages in file: 32 Members on page:2045 Number of members (32*204

[GENERAL] Postgres warm standby in production

2016-03-31 Thread Dmitry Mordovin
Dear friends! Anybody use Postgres 9.5 warm standby in production? Which schemes you use? My setup: - 2 DB servers (master and slave) - 4 APP servers (tomcat) Each tomcat server have JDBC connect to master and prepared config for slave. Business task permit switch between DB server on APP s

[GENERAL] Is it possible to delete a single value from an enum type?

2016-03-31 Thread Nik Mitev
Hi, In summary, I am looking for the opposite functionality to 'ALTER TYPE typename ADD VALUE IF NOT EXISTS new_value' e.g. 'ALTER TYPE typename DELETE VALUE IF NOT USED unused_value'. The [IF NOT USED] condition is optional, I can work around it and externally check whether the value is used in t

Re: [GENERAL] debugging server connection issue

2016-03-31 Thread Stephen Constable
In case anybody looks back on this thread in the future, I fixed the problem (at least temporarily) by running the following in CentOS 7: # echo "1025 65535" >/proc/sys/net/ipv4/ip_local_port_range # sysctl -w net.ipv4.tcp_timestamps=1 # sysctl -w net.ipv4.tcp_tw_recycle=1 # sysctl -w tcp_tw_reuse=

Re: [GENERAL] Re: Postgres 9.4.4/9.4.6: plpython2/3 intallation issues on a Windows 7 machine

2016-03-31 Thread Alex Ignatov
May be this would be the cause of you issue: http://www.postgresql.org/docs/9.2/static/plpython-python23.html It is not allowed to use PL/Python based on Python 2 and PL/Python based on Python 3 in the same session, because the symbols in the dynamic modules would clash, which could result in c

Re: [GENERAL] Is it possible to delete a single value from an enum type?

2016-03-31 Thread Sándor Daku
On 31 March 2016 at 14:35, Nik Mitev wrote: > Hi, > > In summary, I am looking for the opposite functionality to 'ALTER TYPE > typename ADD VALUE IF NOT EXISTS new_value' > e.g. 'ALTER TYPE typename DELETE VALUE IF NOT USED unused_value'. The > [IF NOT USED] condition is optional, I can work arou

Re: [GENERAL] Multixacts wraparound monitoring

2016-03-31 Thread Alvaro Herrera
Pavlov, Vladimir wrote: > Hello, > If I get you right: > Latest checkpoint's NextMultiXactId: 2075246000 > Latest checkpoint's oldestMultiXid: 2019511697 > Number of members files: 10820 > Size pg_multixact/members/ (bytes) (2.7Gb): 2887696384 > Pages in file:32 >

Re: [GENERAL] Is it possible to delete a single value from an enum type?

2016-03-31 Thread Nik Mitev
On 31/03/16 14:14, Sándor Daku wrote: > On 31 March 2016 at 14:35, Nik Mitev > wrote: > > Hi, > > In summary, I am looking for the opposite functionality to 'ALTER TYPE > typename ADD VALUE IF NOT EXISTS new_value' > e.g. 'ALTER TYPE typename DELETE VALUE IF

Re: [GENERAL] Postgres 9.4.4/9.4.6: plpython2/3 intallation issues on a Windows 7 machine

2016-03-31 Thread Adrian Klaver
On 03/31/2016 12:50 AM, margrit drescher wrote: I installed postgres 9.4.6 on my Windows 7 (64-bit) machine, and managed to create the plpython3u extension without a problem. I then restored an existing DB (created in postgres 9.3). The plpython3 functions restored without a hitch and can execu

Re: [GENERAL] Re: Postgres 9.4.4/9.4.6: plpython2/3 intallation issues on a Windows 7 machine

2016-03-31 Thread Adrian Klaver
On 03/31/2016 02:53 AM, margrit drescher wrote: I originally used the 9.4.6 version on http://www.enterprisedb.com/products-services-training/pgdownload#windows for 64-bit windows and loaded the language pack recommended in the readme file. Did you do this?: If you are using Windows 64, you mu

Re: [GENERAL] Is it possible to delete a single value from an enum type?

2016-03-31 Thread Melvin Davidson
On Thu, Mar 31, 2016 at 9:24 AM, Nik Mitev wrote: > > > On 31/03/16 14:14, Sándor Daku wrote: > > On 31 March 2016 at 14:35, Nik Mitev wrote: > >> Hi, >> >> In summary, I am looking for the opposite functionality to 'ALTER TYPE >> typename ADD VALUE IF NOT EXISTS new_value' >> e.g. 'ALTER TYPE t

Re: [GENERAL] Is it possible to delete a single value from an enum type?

2016-03-31 Thread Tom Lane
Melvin Davidson writes: > On Thu, Mar 31, 2016 at 9:24 AM, Nik Mitev wrote: >>> In summary, I am looking for the opposite functionality to 'ALTER TYPE >>> typename ADD VALUE IF NOT EXISTS new_value' >>> e.g. 'ALTER TYPE typename DELETE VALUE IF NOT USED unused_value'. > It is not easy to delete

Re: [GENERAL] Is it possible to delete a single value from an enum type?

2016-03-31 Thread Melvin Davidson
On Thu, Mar 31, 2016 at 10:25 AM, Tom Lane wrote: > Melvin Davidson writes: > > On Thu, Mar 31, 2016 at 9:24 AM, Nik Mitev wrote: > >>> In summary, I am looking for the opposite functionality to 'ALTER TYPE > >>> typename ADD VALUE IF NOT EXISTS new_value' > >>> e.g. 'ALTER TYPE typename DELETE

Re: [GENERAL] Multixacts wraparound monitoring

2016-03-31 Thread Pavlov, Vladimir
I understand correctly, that number of members cannot be more than 2^32 (also uses a 32-bit counter)? I had 69640 files in main/pg_multixact/members/, 69640*32*2045 = 4557241600 members, this is normal? Kind regards,   Vladimir Pavlov -Original Message- From: Alvaro Herrera [mailto:alv

[GENERAL] Create trigger on Materialized View?

2016-03-31 Thread Matthew Syphus
I would like a trigger on a materialized view. Is this possible? I have tried both an INSTEAD OF and BEFORE trigger with no luck. It responds with: "project_milestone_mv" is not a table or view. It is absolutely present and spelled correctly. It is the same with or without the schema qualificat

Re: [GENERAL] Create trigger on Materialized View?

2016-03-31 Thread David G. Johnston
On Thu, Mar 31, 2016 at 9:30 AM, Matthew Syphus wrote: > I would like a trigger on a materialized view. Is this possible? I have > tried both an INSTEAD OF and BEFORE trigger with no luck. It responds > with: > > "project_milestone_mv" is not a table or view. > > It is absolutely present and sp

Re: [GENERAL] Create trigger on Materialized View?

2016-03-31 Thread Matthew Syphus
I was afraid of that. Any idea if it is a technical or resource limitation? In other words, is such functionality impossible, undesirable, anticipated, or in the works? From: David G. Johnston [mailto:david.g.johns...@gmail.com] Sent: Thursday, March 31, 2016 10:38 AM To: Matthew Syphus Cc: pg

Re: [GENERAL] Multixacts wraparound monitoring

2016-03-31 Thread Thomas Munro
On Fri, Apr 1, 2016 at 4:31 AM, Pavlov, Vladimir wrote: > I understand correctly, that number of members cannot be more than 2^32 (also > uses a 32-bit counter)? Correct. > I had 69640 files in main/pg_multixact/members/, 69640*32*2045 = 4557241600 > members, this is normal? Where did you get

Re: [GENERAL] Missed LIMIT clause pushdown in FDW API

2016-03-31 Thread Alexander Reshetov
Tom, it's really good news. Thanks! For now as workaround I think that it's possible to add additional column in table. In this way it would be possible to scan only needed part of solumn in storage. While quals is pushed down it will be possible to limit like this select * from table where fak

Re: [GENERAL] Create trigger on Materialized View?

2016-03-31 Thread Adrian Klaver
On 03/31/2016 09:46 AM, Matthew Syphus wrote: I was afraid of that. Any idea if it is a technical or resource limitation? In other words, is such functionality impossible, undesirable, anticipated, or in the works? I would guess from here: http://www.postgresql.org/docs/9.5/static/rules-mater