agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedStrange behavior of transcations
2022-06-05 11:10 UTC Hui Jackson <jackhts4@gmail.com>
` Re: Strange behavior of transcations
2022-06-05 14:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Strange behavior of transcations
2022-06-05 14:37 UTC Erik Brandsberg <erik@heimdalldata.com>
[3+ messages in thread]
Using Transaction with if-else in prepared statement
2022-05-25 11:12 UTC Hui Jackson <jackhts4@gmail.com>
` Re: Using Transaction with if-else in prepared statement
2022-05-25 18:03 UTC Steve Midgley <science@misuse.org>
` Re: Using Transaction with if-else in prepared statement
2022-05-25 23:35 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Using Transaction with if-else in prepared statement
2022-05-26 10:00 UTC Hui Jackson <jackhts4@gmail.com>
[4+ messages in thread]
Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
2022-05-23 11:55 UTC kimaidou <kimaidou@gmail.com>
` Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
2022-05-23 13:14 UTC Frank Streitzig <fstreitzig@gmx.net>
` Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
2022-05-23 14:15 UTC kimaidou <kimaidou@gmail.com>
` Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
2022-05-23 14:20 UTC kimaidou <kimaidou@gmail.com>
` Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
2022-05-23 14:22 UTC kimaidou <kimaidou@gmail.com>
` Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
2022-05-23 14:33 UTC kimaidou <kimaidou@gmail.com>
` Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ?
2022-05-23 20:39 UTC Frank Streitzig <fstreitzig@gmx.net>
[7+ messages in thread]
Set timeout just on a query?
2022-05-10 00:58 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Set timeout just on a query?
2022-05-10 00:59 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: Set timeout just on a query?
2022-05-10 01:00 UTC Christophe Pettus <xof@thebuild.com>
` Re: Set timeout just on a query?
2022-05-10 03:56 UTC Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
[4+ messages in thread]
Recursive query - ERROR: invalid memory alloc request size 1073741824
2022-05-07 13:23 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
2022-05-07 13:53 UTC Rob Sargent <robjsargent@gmail.com>
` Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
2022-05-07 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
2022-05-08 19:15 UTC Simon Riggs <simon.riggs@enterprisedb.com>
[4+ messages in thread]
Ignore error and carry on
2022-05-07 10:56 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: Ignore error and carry on
2022-05-07 14:38 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Has anyone tried to run lots of postgres commands in parallel in this way?
2022-04-28 09:57 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: Has anyone tried to run lots of postgres commands in parallel in this way?
2022-04-29 07:20 UTC Samed YILDIRIM <samed@reddoc.net>
` Re: Has anyone tried to run lots of postgres commands in parallel in this way?
2022-04-29 19:16 UTC Erik Brandsberg <erik@heimdalldata.com>
[3+ messages in thread]
How to use password in psql command line?
2022-04-28 09:10 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: How to use password in psql command line?
2022-04-29 07:18 UTC Samed YILDIRIM <samed@reddoc.net>
[2+ messages in thread]
parallel-processing multiple similar query tasks - any example?
2022-04-27 23:33 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: parallel-processing multiple similar query tasks - any example?
2022-04-28 17:14 UTC Steve Midgley <science@misuse.org>
` Re: parallel-processing multiple similar query tasks - any example?
2022-04-28 17:46 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: parallel-processing multiple similar query tasks - any example?
2022-04-28 18:22 UTC Erik Brandsberg <erik@heimdalldata.com>
[4+ messages in thread]
xargs psql
2022-04-28 11:32 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: xargs psql
2022-04-28 13:59 UTC Rob Sargent <robjsargent@gmail.com>
` Re: xargs psql
2022-04-28 14:05 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: xargs psql
2022-04-28 14:53 UTC Rob Sargent <robjsargent@gmail.com>
[4+ messages in thread]
AW: xargs psql
2022-04-28 13:10 UTC Marc Mamin <M.Mamin@intershop.de>
Aw: How to use password in psql command line?
2022-04-28 09:38 UTC Karsten Hilbert <Karsten.Hilbert@gmx.net>
Create index on user defined type
2022-04-19 16:27 UTC aditya desai <admad123@gmail.com>
` Re: Create index on user defined type
2022-04-19 16:29 UTC Christophe Pettus <xof@thebuild.com>
` Re: Create index on user defined type
2022-04-19 17:03 UTC aditya desai <admad123@gmail.com>
` Re: Create index on user defined type
2022-04-19 18:18 UTC Rob Sargent <robjsargent@gmail.com>
` Re: Create index on user defined type
2022-04-24 10:43 UTC Samed YILDIRIM <samed@reddoc.net>
[5+ messages in thread]
Understanding SQL queries
2022-04-14 09:10 UTC João Paulo Almeida <jpandradealmeida@gmail.com>
enable/disable instead of trigger
2022-04-12 13:12 UTC Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
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 <shishaozhong@gmail.com>
` Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?
2022-04-10 16:03 UTC Steve Midgley <science@misuse.org>
` Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?
2022-04-10 16:13 UTC David G. Johnston <david.g.johnston@gmail.com>
[3+ messages in thread]
Long running processes and commit writing to disk
2022-04-08 16:39 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Long running processes and commit writing to disk
2022-04-08 16:39 UTC Shaozhong SHI <shishaozhong@gmail.com>
` RE: Long running processes and commit writing to disk
2022-04-08 16:52 UTC Mike Sofen <msofen@runbox.com>
` Re: Long running processes and commit writing to disk
2022-04-08 17:05 UTC Rob Sargent <robjsargent@gmail.com>
` Re: Long running processes and commit writing to disk
2022-04-08 18:01 UTC Ron <ronljohnsonjr@gmail.com>
[5+ messages in thread]
Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
2022-04-06 04:07 UTC Jian He <hejian.mark@gmail.com>
` Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
2022-04-06 04:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions
2022-04-06 04:33 UTC David G. Johnston <david.g.johnston@gmail.com>
[3+ messages in thread]
Histogram question.
2022-04-05 14:34 UTC Jian He <hejian.mark@gmail.com>
` Re: Histogram question.
2022-04-05 15:14 UTC Steve Midgley <science@misuse.org>
[2+ messages in thread]
How to just get the last in a recursive query
2022-04-04 22:14 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: How to just get the last in a recursive query
2022-04-04 22:16 UTC Rob Sargent <robjsargent@gmail.com>
` Re: How to just get the last in a recursive query
2022-04-04 23:21 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: How to just get the last in a recursive query
2022-04-04 23:24 UTC Rob Sargent <robjsargent@gmail.com>
` Re: How to just get the last in a recursive query
2022-04-04 23:32 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: How to just get the last in a recursive query
2022-04-05 00:00 UTC Steve Midgley <science@misuse.org>
` Re: How to just get the last in a recursive query
2022-04-05 00:50 UTC David G. Johnston <david.g.johnston@gmail.com>
` RE: How to just get the last in a recursive query
2022-04-05 13:03 UTC Tchouante, Merlin <mtchouan@umaryland.edu>
[8+ messages in thread]
How long does iteration over 4-5 million rows usually take?
2022-04-02 01:34 UTC Shaozhong SHI <shishaozhong@gmail.com>
` How long does iteration over 4-5 million rows usually take?
2022-04-02 01:35 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: How long does iteration over 4-5 million rows usually take?
2022-04-02 01:47 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: How long does iteration over 4-5 million rows usually take?
2022-04-02 02:18 UTC Ron <ronljohnsonjr@gmail.com>
` Re: How long does iteration over 4-5 million rows usually take?
2022-04-02 13:21 UTC Rob Sargent <robjsargent@gmail.com>
` Re: Re: How long does iteration over 4-5 million rows usually take?
2022-04-02 14:16 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: Re: How long does iteration over 4-5 million rows usually take?
2022-04-02 14:34 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: How long does iteration over 4-5 million rows usually take?
2022-04-02 16:38 UTC Steve Midgley <science@misuse.org>
[8+ messages in thread]
Aw: Re: How long does iteration over 4-5 million rows usually take?
2022-04-02 13:46 UTC Karsten Hilbert <Karsten.Hilbert@gmx.net>
the order of operator computation
2022-03-25 04:46 UTC Jian He <hejian.mark@gmail.com>
` Re: the order of operator computation
2022-03-25 05:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
How to explicitly lock and unlock tables in pgsql?
2022-03-16 20:30 UTC Shaozhong SHI <shishaozhong@gmail.com>
` How to explicitly lock and unlock tables in pgsql?
2022-03-16 20:30 UTC Shaozhong SHI <shishaozhong@gmail.com>
` Re: How to explicitly lock and unlock tables in pgsql?
2022-03-16 20:35 UTC Fabrízio de Royes Mello <fabrizio@timbira.com.br>
` Re: How to explicitly lock and unlock tables in pgsql?
2022-03-17 07:51 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to explicitly lock and unlock tables in pgsql?
2022-03-18 16:38 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: How to explicitly lock and unlock tables in pgsql?
2022-03-18 22:48 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[6+ messages in thread]
PostgreSQL trigger on user logon
2022-03-18 14:46 UTC Kevin Tu <kevintu888@gmail.com>
` Re: PostgreSQL trigger on user logon
2022-03-18 19:58 UTC Steve Midgley <science@misuse.org>
[2+ 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