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

Re: Concurrently run scipts
  2023-10-26 09:49 UTC  Shaozhong SHI <[email protected]>

Re: Concurrently run scipts
  2023-10-26 08:01 UTC  Shaozhong SHI <[email protected]>

Concurrently run scipts
  2023-10-25 19:57 UTC  Shaozhong SHI <[email protected]>

stored procedures
  2023-10-17 15:52 UTC  Shaozhong SHI <[email protected]>

Very odd message
  2023-08-08 22:13 UTC  Shaozhong SHI <[email protected]>

Re: Multiple sets of results from recursive query
  2023-07-17 19:43 UTC  Shaozhong SHI <[email protected]>

Re: Multiple sets of results from recursive query
  2023-07-17 19:21 UTC  Shaozhong SHI <[email protected]>

best finding all paths with recursive query
  2023-07-16 17:22 UTC  Shaozhong SHI <[email protected]>

Multiple sets of results from recursive query
  2023-07-16 10:40 UTC  Shaozhong SHI <[email protected]>

Re: Memory allocation error
  2023-07-14 22:44 UTC  Shaozhong SHI <[email protected]>

Re: Memory allocation error
  2023-07-14 07:36 UTC  Shaozhong SHI <[email protected]>

Memory allocation error
  2023-07-14 06:38 UTC  Shaozhong SHI <[email protected]>

Can we set time exception?
  2023-07-13 14:46 UTC  Shaozhong SHI <[email protected]>

Finding out types of error
  2023-07-08 18:55 UTC  Shaozhong SHI <[email protected]>

How to remove duplicates in an array and maintain the order?
  2023-07-08 15:30 UTC  Shaozhong SHI <[email protected]>

How do Exception, do nothing and carry on
  2023-07-06 21:47 UTC  Shaozhong SHI <[email protected]>

Re: How to select the last value/row?
  2023-07-06 16:02 UTC  Shaozhong SHI <[email protected]>

How to select the last value/row?
  2023-07-06 15:46 UTC  Shaozhong SHI <[email protected]>

Working around insert into a_table from select things from a_function
  2023-07-04 16:58 UTC  Shaozhong SHI <[email protected]>

How come column is locked?
  2023-07-04 14:34 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:44 UTC  Shaozhong SHI <[email protected]>

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: Tom changed his job role many times
  2022-12-13 20:33 UTC  Shaozhong SHI <[email protected]>

Tom changed his job role many times
  2022-12-12 22:43 UTC  Shaozhong SHI <[email protected]>

Re: Change detection
  2022-12-09 19:32 UTC  Shaozhong SHI <[email protected]>

Re: Change detection
  2022-12-09 14:15 UTC  Shaozhong SHI <[email protected]>

Re: Change detection
  2022-12-09 13:14 UTC  Shaozhong SHI <[email protected]>

Change detection
  2022-12-09 12:55 UTC  Shaozhong SHI <[email protected]>

select only 1 pair
  2022-10-24 14:44 UTC  Shaozhong SHI <[email protected]>

How to do things like \timing on in a do loop?
  2022-10-15 19:32 UTC  Shaozhong SHI <[email protected]>

Append a list of tables to an empty table to form a whole table
  2022-10-14 06:00 UTC  Shaozhong SHI <[email protected]>

How to union all tables in a schema into one whole table?
  2022-10-13 17:02 UTC  Shaozhong SHI <[email protected]>

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]>

select items based on 2 columns
  2022-08-08 08:24 UTC  Shaozhong SHI <[email protected]>

Re: A function to find errors in groups in a table
  2022-06-09 23:13 UTC  Shaozhong SHI <[email protected]>

A function to find errors in groups in a table
  2022-06-09 13:37 UTC  Shaozhong SHI <[email protected]>

A function to find errors in groups in a table
  2022-06-09 13:37 UTC  Shaozhong SHI <[email protected]>

Set timeout just on a query?
  2022-05-10 00:59 UTC  Shaozhong SHI <[email protected]>

Set timeout just on a query?
  2022-05-10 00:58 UTC  Shaozhong SHI <[email protected]>

Recursive query - ERROR: invalid memory alloc request size 1073741824
  2022-05-07 13:23 UTC  Shaozhong SHI <[email protected]>

Ignore error and carry on
  2022-05-07 10:56 UTC  Shaozhong SHI <[email protected]>

Re: parallel-processing multiple similar query tasks - any example?
  2022-04-28 17:46 UTC  Shaozhong SHI <[email protected]>

Re: xargs psql
  2022-04-28 14:05 UTC  Shaozhong SHI <[email protected]>

xargs psql
  2022-04-28 11:32 UTC  Shaozhong SHI <[email protected]>

Has anyone tried to run lots of postgres commands in parallel in this way?
  2022-04-28 09:57 UTC  Shaozhong SHI <[email protected]>

How to use password in psql command line?
  2022-04-28 09:10 UTC  Shaozhong SHI <[email protected]>

parallel-processing multiple similar query tasks - any example?
  2022-04-27 23:33 UTC  Shaozhong SHI <[email protected]>

How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?
  2022-04-10 13:50 UTC  Shaozhong SHI <[email protected]>

Long running processes and commit writing to disk
  2022-04-08 16:39 UTC  Shaozhong SHI <[email protected]>

Long running processes and commit writing to disk
  2022-04-08 16:39 UTC  Shaozhong SHI <[email protected]>

Re: How to just get the last in a recursive query
  2022-04-04 23:21 UTC  Shaozhong SHI <[email protected]>

How to just get the last in a recursive query
  2022-04-04 22:14 UTC  Shaozhong SHI <[email protected]>

Re: Re: How long does iteration over 4-5 million rows usually take?
  2022-04-02 14:16 UTC  Shaozhong SHI <[email protected]>

How long does iteration over 4-5 million rows usually take?
  2022-04-02 01:35 UTC  Shaozhong SHI <[email protected]>

How long does iteration over 4-5 million rows usually take?
  2022-04-02 01:34 UTC  Shaozhong SHI <[email protected]>


55+ results

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