Mailing lists [pgsql-sql]

2 April 2022

• 04:35   How long does iteration over 4-5 million rows usually take? Shaozhong SHI
• 19:38   Re: How long does iteration over 4-5 million rows usually take? Steve Midgley

5 April 2022

• 01:14   How to just get the last in a recursive query Shaozhong SHI
• 01:16   Re: How to just get the last in a recursive query Rob Sargent
• 02:21   Re: How to just get the last in a recursive query Shaozhong SHI
• 02:24   Re: How to just get the last in a recursive query Rob Sargent
• 02:32   Re: How to just get the last in a recursive query David G. Johnston
• 03:00   Re: How to just get the last in a recursive query Steve Midgley
• 03:50   Re: How to just get the last in a recursive query David G. Johnston
• 16:03   RE: How to just get the last in a recursive query Tchouante, Merlin
• 17:34   Histogram question. Jian He
• 18:14   Re: Histogram question. Steve Midgley

6 April 2022

• 07:07   Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions Jian He
• 07:10   Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions Tom Lane
• 07:33   Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions David G. Johnston

8 April 2022

• 19:39   Long running processes and commit writing to disk Shaozhong SHI
• 19:52   RE: Long running processes and commit writing to disk Mike Sofen
• 20:05   Re: Long running processes and commit writing to disk Rob Sargent

10 April 2022

• 16:50   How best to do parallel query given tens of thousands of iteration of a loop of recursive queries? Shaozhong SHI
• 19:03   Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries? Steve Midgley
• 19:13   Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries? David G. Johnston

12 April 2022

• 16:12   enable/disable instead of trigger Voillequin, Jean-Marc

14 April 2022

• 12:10   Understanding SQL queries João Paulo Almeida

19 April 2022

• 19:27   Create index on user defined type aditya desai
• 19:29   Re: Create index on user defined type Christophe Pettus
• 20:03   Re: Create index on user defined type aditya desai
• 21:18   Re: Create index on user defined type Rob Sargent

28 April 2022

• 02:33   parallel-processing multiple similar query tasks - any example? Shaozhong SHI
• 12:10   How to use password in psql command line? Shaozhong SHI
• 12:38   Aw: How to use password in psql command line? Karsten Hilbert
• 12:57   Has anyone tried to run lots of postgres commands in parallel in this way? Shaozhong SHI
• 14:32   xargs psql Shaozhong SHI
• 16:10   AW: xargs psql Marc Mamin
• 16:59   Re: xargs psql Rob Sargent
• 17:05   Re: xargs psql Shaozhong SHI
• 17:53   Re: xargs psql Rob Sargent
• 20:14   Re: parallel-processing multiple similar query tasks - any example? Steve Midgley
• 20:46   Re: parallel-processing multiple similar query tasks - any example? Shaozhong SHI
• 21:22   Re: parallel-processing multiple similar query tasks - any example? Erik Brandsberg

29 April 2022

• 22:16   Re: Has anyone tried to run lots of postgres commands in parallel in this way? Erik Brandsberg