public inbox for [email protected]  
help / color / mirror / Atom feed
PostgreSQL Objects design
  2023-04-20 16:01 UTC  kunwar singh <[email protected]>
` Re: PostgreSQL Objects design
  2023-04-20 16:25 UTC  Steve Midgley <[email protected]>
` PostgreSQL Objects design
  2023-04-20 18:40 UTC  Wetmore, Matthew (CTR) <[email protected]>
  [3+ messages in thread]

Looking for an efficient way to replace efficient NOT IN when landling very large data
  2023-04-11 09:27 UTC  Shaozhong SHI <[email protected]>
` Re: Looking for an efficient way to replace efficient NOT IN when landling very large data
  2023-04-11 09:33 UTC  David Rowley <[email protected]>
` Re: Looking for an efficient way to replace efficient NOT IN when landling very large data
  2023-04-11 09:44 UTC  Shaozhong SHI <[email protected]>
  [3+ messages in thread]

Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
  2023-02-25 20:35 UTC  nikhil raj <[email protected]>
` Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range.
  2023-02-25 21:04 UTC  nikhil raj <[email protected]>
` Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
  2023-02-25 21:56 UTC  Steve Midgley <[email protected]>
` Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
  2023-02-27 19:45 UTC  nikhil raj <[email protected]>
  [4+ messages in thread]

Could not serialize access due to read/write dependencies among transactions
  2023-02-23 21:18 UTC  michele curioni <[email protected]>
` Re: Could not serialize access due to read/write dependencies among transactions
  2023-02-23 22:10 UTC  Tom Lane <[email protected]>
  [2+ messages in thread]

How to ensure a log-entry is created based on state of data in other tables
  2023-02-09 07:23 UTC  Andreas Joseph Krogh <[email protected]>
` Re: How to ensure a log-entry is created based on state of data in other tables
  2023-02-09 15:08 UTC  Steve Midgley <[email protected]>
` Re: How to ensure a log-entry is created based on state of data in other tables
  2023-02-09 16:33 UTC  Andreas Joseph Krogh <[email protected]>
` Re: How to ensure a log-entry is created based on state of data in other tables
  2023-02-09 16:37 UTC  Steve Midgley <[email protected]>
` Re: How to ensure a log-entry is created based on state of data in other tables
  2023-02-09 16:44 UTC  David G. Johnston <[email protected]>
` Re: How to ensure a log-entry is created based on state of data in other tables
  2023-02-09 16:44 UTC  Rob Sargent <[email protected]>
` Re: How to ensure a log-entry is created based on state of data in other tables
  2023-02-09 16:59 UTC  Andreas Joseph Krogh <[email protected]>
  [7+ messages in thread]

Order By weirdness?
  2023-01-07 20:35 UTC  Carl Sopchak <[email protected]>
` Re: Order By weirdness?
  2023-01-07 20:38 UTC  Erik Brandsberg <[email protected]>
` Re: Order By weirdness?
  2023-01-07 20:45 UTC  Carl Sopchak <[email protected]>
` Re: Order By weirdness?
  2023-01-07 21:01 UTC  Samed YILDIRIM <[email protected]>
  [4+ messages in thread]

Postgresql long transaction support
  2022-12-14 11:54 UTC  Kirmo Uusitalo <[email protected]>
` Re: Postgresql long transaction support
  2022-12-14 12:02 UTC  Samed YILDIRIM <[email protected]>
` Re: Postgresql long transaction support
  2022-12-14 12:45 UTC  Kirmo Uusitalo <[email protected]>
` Re: Postgresql long transaction support
  2022-12-14 19:59 UTC  Steve Midgley <[email protected]>
` Re: Postgresql long transaction support
  2022-12-14 21:13 UTC  Tom Lane <[email protected]>
  [5+ messages in thread]

Tom changed his job role many times
  2022-12-12 22:43 UTC  Shaozhong SHI <[email protected]>
` Re: Tom changed his job role many times
  2022-12-13 01:01 UTC  David Rowley <[email protected]>
` Re: Tom changed his job role many times
  2022-12-13 20:33 UTC  Shaozhong SHI <[email protected]>
  [3+ messages in thread]

PARALLEL CTAS
  2022-12-12 16:16 UTC  Shane Borden <[email protected]>
` Re: PARALLEL CTAS
  2022-12-12 16:55 UTC  Erik Brandsberg <[email protected]>
` Re: PARALLEL CTAS
  2022-12-12 17:13 UTC  Shane Borden <[email protected]>
` Re: PARALLEL CTAS
  2022-12-12 17:25 UTC  Rob Sargent <[email protected]>
` Re: PARALLEL CTAS
  2022-12-12 17:36 UTC  Shane Borden <[email protected]>
` Re: PARALLEL CTAS
  2022-12-12 18:19 UTC  Steve Midgley <[email protected]>
` Re: PARALLEL CTAS
  2022-12-12 18:52 UTC  Tom Lane <[email protected]>
  [7+ messages in thread]

Change detection
  2022-12-09 12:55 UTC  Shaozhong SHI <[email protected]>
` AW: Change detection
  2022-12-09 13:02 UTC  Stöcker, Martin <[email protected]>
` Re: Change detection
  2022-12-09 13:06 UTC  Marcos Pegoraro <[email protected]>
` Re: Change detection
  2022-12-09 13:14 UTC  Shaozhong SHI <[email protected]>
` Re: Change detection
  2022-12-09 14:15 UTC  Shaozhong SHI <[email protected]>
` Re: Change detection
  2022-12-09 17:00 UTC  Marcos Pegoraro <[email protected]>
` Re: Change detection
  2022-12-09 19:32 UTC  Shaozhong SHI <[email protected]>
` Re: Change detection
  2022-12-09 19:38 UTC  Rob Sargent <[email protected]>
  [8+ messages in thread]

[QUESTION] Window function with partition by and order by
  2022-11-27 16:08 UTC  Ankit Kumar Pandey <[email protected]>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:21 UTC  William Alves Da Silva <[email protected]>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:23 UTC  Samed YILDIRIM <[email protected]>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:28 UTC  Tom Lane <[email protected]>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:54 UTC  Ankit Kumar Pandey <[email protected]>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:54 UTC  Ankit Kumar Pandey <[email protected]>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:55 UTC  Ankit Kumar Pandey <[email protected]>
  [7+ messages in thread]

access sub elements using any()
  2022-10-31 17:04 UTC  Rob Sargent <[email protected]>
` Re: access sub elements using any()
  2022-10-31 22:36 UTC  Torsten Grust <[email protected]>
` Re: access sub elements using any()
  2022-10-31 22:40 UTC  Rob Sargent <[email protected]>
` Re: access sub elements using any()
  2022-11-01 00:50 UTC  Tom Lane <[email protected]>
  [4+ messages in thread]

select only 1 pair
  2022-10-24 14:44 UTC  Shaozhong SHI <[email protected]>
` AW: select only 1 pair
  2022-10-24 14:51 UTC  Stöcker, Martin <[email protected]>
` RE: select only 1 pair
  2022-10-24 14:59 UTC  Voillequin, Jean-Marc <[email protected]>
` Re: select only 1 pair
  2022-10-24 15:01 UTC  William Alves Da Silva <[email protected]>
` Re: select only 1 pair
  2022-10-24 15:01 UTC  Frank Streitzig <[email protected]>
` Re: select only 1 pair
  2022-10-24 15:08 UTC  Thomas Kellerer <[email protected]>
` Re: select only 1 pair
  2022-10-24 15:57 UTC  Steve Midgley <[email protected]>
  [7+ messages in thread]

How to do things like \timing on in a do loop?
  2022-10-15 19:32 UTC  Shaozhong SHI <[email protected]>
` Re: How to do things like \timing on in a do loop?
  2022-10-15 20:04 UTC  Erik Brandsberg <[email protected]>
` Re: How to do things like \timing on in a do loop?
  2022-10-16 09:21 UTC  hubert depesz lubaczewski <[email protected]>
  [3+ messages in thread]

Append a list of tables to an empty table to form a whole table
  2022-10-14 06:00 UTC  Shaozhong SHI <[email protected]>
` Re: Append a list of tables to an empty table to form a whole table
  2022-10-14 07:13 UTC  Frank Gard <[email protected]>
` Re: Append a list of tables to an empty table to form a whole table
  2022-10-14 08:50 UTC  Frank Gard <[email protected]>
  [3+ messages in thread]

How to union all tables in a schema into one whole table?
  2022-10-13 17:02 UTC  Shaozhong SHI <[email protected]>
` Aw: How to union all tables in a schema into one whole table?
  2022-10-13 17:06 UTC  Karsten Hilbert <[email protected]>
` Re: How to union all tables in a schema into one whole table?
  2022-10-13 17:17 UTC  Frank Gard <[email protected]>
  [3+ messages in thread]

Can we generate a series of tables in a loop and then use another loop to union all?
  2022-10-13 15:44 UTC  Shaozhong SHI <[email protected]>
` Re: Can we generate a series of tables in a loop and then use another loop to union all?
  2022-10-13 16:50 UTC  Frank Gard <[email protected]>
  [2+ messages in thread]

[Bug][Ver 11]: Generic query plan selected is worse than custom query plan
  2022-09-29 18:33 UTC  Malay Keshav <[email protected]>
` Re: [Bug][Ver 11]: Generic query plan selected is worse than custom query plan
  2022-09-29 19:58 UTC  Tom Lane <[email protected]>
  [2+ messages in thread]

Delete from locking ordering differences
  2022-09-23 07:31 UTC  Peter Hendriks <[email protected]>
` Re: Delete from locking ordering differences
  2022-09-23 16:04 UTC  Rob Sargent <[email protected]>
` Re: Delete from locking ordering differences
  2022-09-29 13:51 UTC  Peter Hendriks <[email protected]>
  [3+ messages in thread]

ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-15 17:31 UTC  Inzamam Shafiq <[email protected]>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-15 23:09 UTC  Steve Midgley <[email protected]>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-16 05:49 UTC  Inzamam Shafiq <[email protected]>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-16 06:41 UTC  Tom Lane <[email protected]>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-16 07:51 UTC  Inzamam Shafiq <[email protected]>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-20 09:29 UTC  Inzamam Shafiq <[email protected]>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-20 09:46 UTC  David Rowley <[email protected]>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-22 10:39 UTC  Geri Wright <[email protected]>
  [8+ messages in thread]

execution id
  2022-08-30 16:22 UTC  Voillequin, Jean-Marc <[email protected]>
` Re: execution id
  2022-08-30 16:26 UTC  David G. Johnston <[email protected]>
` RE: execution id
  2022-08-30 16:32 UTC  Voillequin, Jean-Marc <[email protected]>
` Re: execution id
  2022-08-30 16:55 UTC  hubert depesz lubaczewski <[email protected]>
  [4+ messages in thread]

Most efficient way to select events from users having common subscriptions
  2022-08-22 06:52 UTC  Brice André <[email protected]>

Alternative to "AT TIME ZONE" that is less of a foot-gun?
  2022-08-09 21:31 UTC  John Ericson <[email protected]>

Possible bug (or at least unexpected behavior)
  2022-08-07 20:06 UTC  Adam Mackler <[email protected]>
` Re: Possible bug (or at least unexpected behavior)
  2022-08-07 23:31 UTC  Tom Lane <[email protected]>
` Re: Possible bug (or at least unexpected behavior)
  2022-08-09 21:10 UTC  Tom Lane <[email protected]>
  [3+ messages in thread]

select items based on 2 columns
  2022-08-08 08:24 UTC  Shaozhong SHI <[email protected]>
` Re: select items based on 2 columns
  2022-08-08 09:32 UTC  Frank Streitzig <[email protected]>
` Re: select items based on 2 columns
  2022-08-08 16:17 UTC  Pierre Chevalier <[email protected]>
` Re: select items based on 2 columns
  2022-08-08 16:30 UTC  Carl Sopchak <[email protected]>
  [4+ messages in thread]


[next (older)]

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