public inbox for [email protected]  
help / color / mirror / Atom feed
Messages from [email protected]

Re: Multi-Column List Partitioning
  2021-10-11 10:42 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Multi-Column List Partitioning
  2021-10-11 05:35 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Multi-Column List Partitioning
  2021-10-07 10:34 UTC  Rajkumar Raghuwanshi <[email protected]>

Getting ERROR "subplan "SubPlan 1" was not initialized" in EXISTS subplan when using for list partition.
  2021-09-14 11:49 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Multi-Column List Partitioning
  2021-09-13 10:17 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Multi-Column List Partitioning
  2021-08-30 07:51 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: recovering from "found xmin ... from before relfrozenxid ..."
  2020-08-18 12:18 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: recovering from "found xmin ... from before relfrozenxid ..."
  2020-08-06 08:55 UTC  Rajkumar Raghuwanshi <[email protected]>

Getting ERROR with FOR UPDATE/SHARE for partitioned table.
  2020-05-22 11:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-04-23 09:53 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-04-23 06:43 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: create partition table caused server crashed with self-referencing foreign key
  2020-04-22 11:34 UTC  Rajkumar Raghuwanshi <[email protected]>

create partition table caused server crashed with self-referencing foreign key
  2020-04-22 07:50 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: ERROR: could not open file "pg_tblspc/ issue with replication setup.
  2020-04-17 06:39 UTC  Rajkumar Raghuwanshi <[email protected]>

ERROR: could not open file "pg_tblspc/ issue with replication setup.
  2020-04-16 08:26 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-04-15 09:28 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: variation of row_number with parallel
  2020-04-14 04:18 UTC  Rajkumar Raghuwanshi <[email protected]>

variation of row_number with parallel
  2020-04-14 03:58 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-04-08 05:48 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-04-02 09:57 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-03-30 10:43 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-03-25 07:22 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-03-19 10:41 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-03-16 12:49 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-03-16 06:26 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-03-16 06:08 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: WIP/PoC for parallel backup
  2020-03-11 09:38 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: backup manifests
  2020-03-05 07:39 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: block-level incremental backup
  2019-08-30 12:56 UTC  Rajkumar Raghuwanshi <[email protected]>

getting ERROR "relation 16401 has no triggers" with partition foreign key alter
  2019-07-16 07:37 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Postgres 11: Table Partitioning and Primary Keys
  2019-07-09 06:09 UTC  Rajkumar Raghuwanshi <[email protected]>

Statistical aggregate functions are not working with PARTIAL aggregation
  2019-05-07 09:09 UTC  Rajkumar Raghuwanshi <[email protected]>

Statistical aggregate functions are not working with partitionwise aggregate
  2019-05-03 09:26 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] advanced partition matching algorithm for partition-wise join
  2019-04-26 10:29 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] advanced partition matching algorithm for partition-wise join
  2019-03-08 08:42 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] advanced partition matching algorithm for partition-wise join
  2019-03-07 06:24 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Getting ERROR: could not open file "base/13164/t3_16388" with partition table with ON COMMIT
  2018-11-05 05:25 UTC  Rajkumar Raghuwanshi <[email protected]>

pg_upgrade failed with ERROR: null relpartbound for relation 18159 error.
  2018-10-03 18:58 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Multiple primary key on partition table?
  2018-10-01 06:39 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Getting ERROR: could not open file "base/13164/t3_16388" with partition table with ON COMMIT
  2018-09-18 05:31 UTC  Rajkumar Raghuwanshi <[email protected]>

Multiple primary key on partition table?
  2018-09-17 11:20 UTC  Rajkumar Raghuwanshi <[email protected]>

Getting ERROR: could not open file "base/13164/t3_16388" with partition table with ON COMMIT
  2018-09-12 10:29 UTC  Rajkumar Raghuwanshi <[email protected]>

cache lookup failed for constraint when alter table referred by partition table
  2018-09-07 10:32 UTC  Rajkumar Raghuwanshi <[email protected]>

negative bitmapset member not allowed Error with partition pruning
  2018-07-26 10:10 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Test patch for partitionwise join with partitioned tables containing default partition
  2018-07-06 05:51 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)"
  2018-06-29 06:24 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)"
  2018-06-28 17:05 UTC  Rajkumar Raghuwanshi <[email protected]>

Server crashed with "TRAP: unrecognized TOAST vartag("1", File: "heaptuple.c", Line: 1490)"
  2018-06-28 10:38 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: alter index WITH ( storage_parameter = value [, ... ] ) for partition index.
  2018-06-28 06:38 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: alter index WITH ( storage_parameter = value [, ... ] ) for partition index.
  2018-06-28 06:21 UTC  Rajkumar Raghuwanshi <[email protected]>

alter index WITH ( storage_parameter = value [, ... ] ) for partition index.
  2018-06-27 09:42 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: unexpected relkind: 73 ERROR with partition table index
  2018-06-27 05:59 UTC  Rajkumar Raghuwanshi <[email protected]>

unexpected relkind: 73 ERROR with partition table index
  2018-06-26 12:18 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: partition table and stddev() /variance() behaviour
  2018-06-22 06:38 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: ERROR: ORDER/GROUP BY expression not found in targetlist
  2018-06-22 06:33 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)"
  2018-06-22 06:28 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Server crashed with TRAP: FailedAssertion("!(parallel_workers > 0)" when partitionwise_aggregate true.
  2018-06-22 06:26 UTC  Rajkumar Raghuwanshi <[email protected]>

partition table and stddev() /variance() behaviour
  2018-06-21 12:18 UTC  Rajkumar Raghuwanshi <[email protected]>

ERROR: ORDER/GROUP BY expression not found in targetlist
  2018-06-20 07:52 UTC  Rajkumar Raghuwanshi <[email protected]>

Server crashed with TRAP: FailedAssertion("!(parallel_workers > 0)" when partitionwise_aggregate true.
  2018-06-18 11:32 UTC  Rajkumar Raghuwanshi <[email protected]>

Getting "ERROR: did not find all requested child rels in append_rel_list" when enable_partition_pruning is on
  2018-06-15 07:32 UTC  Rajkumar Raghuwanshi <[email protected]>

server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)"
  2018-06-14 11:56 UTC  Rajkumar Raghuwanshi <[email protected]>

ntile() throws ERROR when hashagg is false
  2018-06-14 06:06 UTC  Rajkumar Raghuwanshi <[email protected]>

Server crashed with dense_rank on partition table.
  2018-06-13 05:38 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Test patch for partitionwise join with partitioned tables containing default partition
  2018-06-06 06:33 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
  2018-06-06 06:01 UTC  Rajkumar Raghuwanshi <[email protected]>

Test patch for partitionwise join with partitioned tables containing default partition
  2018-06-06 05:56 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: New committers announced at PGCon 2018
  2018-06-04 05:44 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: parallel append vs. simple UNION ALL
  2018-03-16 11:35 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: parallel append vs. simple UNION ALL
  2018-03-08 07:46 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: parallel append vs. simple UNION ALL
  2018-03-07 10:36 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
  2018-03-05 07:13 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: parallel append vs. simple UNION ALL
  2018-03-01 13:11 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: server crash in nodeAppend.c
  2018-03-01 06:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key
  2018-02-28 07:08 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: parallel append vs. simple UNION ALL
  2018-02-27 11:21 UTC  Rajkumar Raghuwanshi <[email protected]>

server crash in nodeAppend.c
  2018-02-27 10:24 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Runtime Partition Pruning
  2018-02-21 09:45 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Runtime Partition Pruning
  2018-02-20 10:46 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] path toward faster partition pruning
  2018-02-20 07:56 UTC  Rajkumar Raghuwanshi <[email protected]>

Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.
  2018-02-12 12:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Query running for very long time (server hanged) with parallel append
  2018-02-06 06:32 UTC  Rajkumar Raghuwanshi <[email protected]>

Query running for very long time (server hanged) with parallel append
  2018-02-01 10:29 UTC  Rajkumar Raghuwanshi <[email protected]>

Multi-level hierarchy with parallel append can lead to an extra subplan.
  2018-01-09 10:09 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
  2017-12-22 09:30 UTC  Rajkumar Raghuwanshi <[email protected]>

!<space>= should give error?
  2017-12-21 06:43 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
  2017-12-05 07:54 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
  2017-12-05 05:34 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
  2017-12-01 06:36 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Partition-wise aggregation/grouping
  2017-11-28 07:07 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Parallel Append implementation
  2017-11-24 11:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Parallel Append implementation
  2017-11-23 08:20 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] path toward faster partition pruning
  2017-11-21 10:06 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [HACKERS] Runtime Partition Pruning
  2017-11-14 08:52 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: path toward faster partition pruning
  2017-11-08 06:52 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: path toward faster partition pruning
  2017-10-30 08:09 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: path toward faster partition pruning
  2017-10-27 10:29 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: path toward faster partition pruning
  2017-10-27 08:05 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: path toward faster partition pruning
  2017-10-23 09:54 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: path toward faster partition pruning
  2017-10-23 06:58 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise aggregation/grouping
  2017-09-21 11:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise join for join between (declaratively) partitioned tables
  2017-09-20 14:25 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise aggregation/grouping
  2017-09-18 09:13 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise aggregation/grouping
  2017-09-12 09:54 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Adding support for Default partition in partitioning
  2017-09-07 09:45 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: advanced partition matching algorithm for partition-wise join
  2017-09-05 11:55 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: [POC] hash partitioning
  2017-09-05 09:13 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: advanced partition matching algorithm for partition-wise join
  2017-09-04 12:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: advanced partition matching algorithm for partition-wise join
  2017-08-28 07:14 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Default Partition for Range
  2017-08-09 12:18 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Default Partition for Range
  2017-08-09 07:07 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: reload-through-the-top-parent switch the partition table
  2017-08-08 10:40 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: UPDATE of partition key
  2017-08-07 06:24 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: UPDATE of partition key
  2017-07-25 12:55 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: UPDATE of partition key
  2017-07-25 09:32 UTC  Rajkumar Raghuwanshi <[email protected]>

drop operator class..using .. left dependency behind.
  2017-06-19 13:17 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Adding support for Default partition in partitioning
  2017-05-25 07:09 UTC  Rajkumar Raghuwanshi <[email protected]>

alter table..drop constraint pkey, left not null un-dropped
  2017-05-11 09:33 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Adding support for Default partition in partitioning
  2017-05-05 06:25 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Adding support for Default partition in partitioning
  2017-05-04 12:39 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2017-04-28 08:11 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2017-04-25 10:03 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise join for join between (declaratively) partitioned tables
  2017-04-24 11:32 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2017-04-21 08:00 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Parallel Append implementation
  2017-03-24 07:41 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise join for join between (declaratively) partitioned tables
  2017-03-21 10:22 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: wait events for disk I/O
  2017-03-20 12:21 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: wait events for disk I/O
  2017-03-13 05:24 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: wait events for disk I/O
  2017-03-08 13:11 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2017-01-04 06:11 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2017-01-03 10:04 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2016-12-27 09:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2016-10-07 08:33 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2016-10-05 07:57 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise join for join between (declaratively) partitioned tables
  2016-09-27 07:25 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise join for join between (declaratively) partitioned tables
  2016-09-22 09:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise join for join between (declaratively) partitioned tables
  2016-09-21 06:44 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Partition-wise join for join between (declaratively) partitioned tables
  2016-09-16 12:30 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2016-09-14 07:58 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2016-09-08 12:38 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2016-09-07 08:56 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Declarative partitioning - another take
  2016-09-06 11:15 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Postgres_fdw join pushdown - getting server crash in left outer join of three table
  2016-05-17 06:54 UTC  Rajkumar Raghuwanshi <[email protected]>

postgres_fdw : Not able to update foreign table referring to a local table's view when use_remote_estimate = true
  2016-04-22 12:44 UTC  Rajkumar Raghuwanshi <[email protected]>

postgres_fdw : altering foreign table not invalidating prepare statement execution plan.
  2016-04-04 06:17 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Postgres_fdw join pushdown - INNER - FULL OUTER join combination generating wrong result
  2016-03-31 05:35 UTC  Rajkumar Raghuwanshi <[email protected]>

Postgres_fdw join pushdown - INNER - FULL OUTER join combination generating wrong result
  2016-03-28 09:17 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Postgres_fdw join pushdown - getting server crash in left outer join of three table
  2016-03-23 09:24 UTC  Rajkumar Raghuwanshi <[email protected]>

Postgres_fdw join pushdown - getting server crash in left outer join of three table
  2016-03-18 10:22 UTC  Rajkumar Raghuwanshi <[email protected]>

Re: Issue with NULLS LAST, with postgres_fdw sort pushdown
  2016-03-02 10:04 UTC  Rajkumar Raghuwanshi <[email protected]>

Issue with NULLS LAST, with postgres_fdw sort pushdown
  2016-02-29 10:19 UTC  Rajkumar Raghuwanshi <[email protected]>


151+ results

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox