Materialized views in PGSQL 9.3 with replication on.

Hi There, We are using postgresql 9.3 with streaming replication to 3 standby nodes. I have a question about Materialized views. When the refresh for MV runs on Master how it's data is replicated to Stanby nodes? Does the refresh command runs on the standby nodes as well as it runs on Master and w

Re: Pg Upgrade failing as it is not able to start and stop server properly

Hi All pg_ctl start and stop commands are hanging in a Windows environment. Can i enable some debug logs to understand the root cause of the issue? Thanks Guru Thanks, Guru On Thu, Jan 4, 2018 at 8:54 PM, Bruce Momjian wrote: > On Thu, Jan 4, 2018 at 01:49:17PM +0530, kiran gadamsetty wrot

Re: Pg Upgrade failing as it is not able to start and stop server properly

Guru Prashanth Thanakodi writes: > pg_ctl start and stop commands are hanging in a Windows environment. Can i > enable some debug logs to understand the root cause of the issue? You could try cranking log_min_messages all the way up to "debug5" in postgresql.conf, but I'm not really sure if that

Supartitions in PGSQL 10

Team, Can you please let us know if Sub-partitions are supported in PGSQL (declarative partitions) 10.1. If yes can it be list-list partitions. We have a situation where a table is very big having around 2 billion rows and is growing. We want to use partitions but not sure if sub-partitions are

Re: Supartitions in PGSQL 10

Kumar, Virendra schrieb am 08.01.2018 um 22:12: Can you please let us know if Sub-partitions are supported in PGSQL (declarative partitions) 10.1. If yes can it be list-list partitions. We have a situation where a table is very big having around 2 billion rows and is growing. We want to use parti

RES: Supartitions in PGSQL 10

> Kumar, Virendra schrieb am 08.01.2018 um 22:12: > > Can you please let us know if Sub-partitions are supported in PGSQL > > (declarative partitions) 10.1. If yes can it be list-list partitions. > > We have a situation where a table is very big having around 2 billion > > rows and is growing. We w

How Many Partitions are Good Performing

Can somebody tell us how many partitions are good number without impacting the performance. We are hearing around a thousand, is that a limit. Do we have plan to increase the number of partitions for a table. We would appreciate if somebody can help us with this? Regards, Virendra ___

Re: How Many Partitions are Good Performing

 You should have read carefully what I wrote. 1000 is not an upper limit. 1000 partition is the number after which performance starts dropping . There is a blog in www.timescale.com which also highlights the same. Sent: Monday, January 08, 2018 at 6:20 PM From: "Kumar, Virendra" To: "pgsql

Re: How Many Partitions are Good Performing

On Tue, Jan 09, 2018 at 12:54:18AM +0100, Rakesh Kumar wrote: > Can somebody tell us how many partitions are good number without > impacting the performance. We are hearing around a thousand, is that a > limit. Do we have plan to increase the number of partitions for a > table. We would appreciate

help with generation_series in pg10

Hi, In pg10 generation series doesn't work like in 9.5. Ex. in 9.5: z=# select generate_series(1, 10), generate_series(1, 5); generate_series | generate_series -+- 1 | 1 2 | 2 3 |

Re: help with generation_series in pg10

On 01/08/2018 05:25 PM, Márcio A. Sepp wrote: Hi, In pg10 generation series doesn't work like in 9.5. Ex. in 9.5: z=# select generate_series(1, 10), generate_series(1, 5); generate_series | generate_series -+- 1 | 1

Re: help with generation_series in pg10

On Monday, January 8, 2018, Adrian Klaver wrote: > > I am not seeing a solution, but you might see something that would help > you. There is no general solution. For the problem at hand I would union two generate_series(1,5) queries with a query_id column. Then I'd use row_number() over (orde