pgsql-general since 2018-08-17 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Aug. 17, 2018

Thread Author Time
Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"? Raghavendra Rao J S V 01:10
Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"? Joshua D. Drake 04:00
Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"? Raghavendra Rao J S V 04:42
Re: pg_upgrade (and recovery) pitfalls PO 10:45
vPgSql Vlad Alexeenkov 12:30
Re: pg_upgrade (and recovery) pitfalls Stephen Frost 12:39
Re: vPgSql Dmitry Igrishin 12:45
Error installing postgresql 9.5.14 on windows7: “unable to write inside temp environment variable path” abhinav srivastava 12:54
Re: vPgSql Johnes Castro 13:01
Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"? Adrian Klaver 13:25
pg_stat_activity.query_start in the future? Justin Pryzby 16:11
Re: pg_stat_activity.query_start in the future? Adrian Klaver 16:17
including header files in a C extension TalGloz 17:24
Re: vPgSql Joshua D. Drake 18:19
Re: vPgSql Dmitry Igrishin 18:24
Re: vPgSql Vlad ABC 21:53

Aug. 18, 2018

Thread Author Time
Re: vPgSql Tim Cross 00:52
Re: using graph model with PostgreSQL 김세훈 05:09
CTE with JOIN of two tables is much faster than a regular query kpi6288 09:36
Re: CTE with JOIN of two tables is much faster than a regular query Andreas Kretschmer 10:26
AW: CTE with JOIN of two tables is much faster than a regular query kpi6288 11:08
Re: AW: CTE with JOIN of two tables is much faster than a regular query Adrian Klaver 14:24
Re: regex match and special characters Oleksii Kliukin 14:24
AW: AW: CTE with JOIN of two tables is much faster than a regular query kpi6288 14:32
Re: CTE with JOIN of two tables is much faster than a regular query Stephen Frost 14:38
AW: CTE with JOIN of two tables is much faster than a regular query kpi6288 15:07
Re: regex match and special characters Oleksii Kliukin 15:12
Re: CTE with JOIN of two tables is much faster than a regular query Tom Lane 15:29
AW: CTE with JOIN of two tables is much faster than a regular query kpi6288 15:43
Re: vPgSql Dmitri Maziuk 16:12
Re: CTE with JOIN of two tables is much faster than a regular query Ravi Krishna 16:25
AW: CTE with JOIN of two tables is much faster than a regular query kpi6288 16:33
Re: regex match and special characters Adrian Klaver 16:51

Aug. 19, 2018

Thread Author Time
Re: AW: CTE with JOIN of two tables is much faster than a regular query Tim Cross 02:56
AW: CTE with JOIN of two tables is much faster than a regular query kpi6288 08:59
AW: AW: CTE with JOIN of two tables is much faster than a regular query kpi6288 09:07
Linker errors while creating a PostgreSQL C extension function. TalGloz 10:56
Re: Linker errors while creating a PostgreSQL C extension function. Dmitry Igrishin 11:50
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 12:07
Re: Linker errors while creating a PostgreSQL C extension function. Dmitry Igrishin 12:24
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 12:46
Re: Linker errors while creating a PostgreSQL C extension function. Dmitry Igrishin 12:57
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 12:58
Re: Linker errors while creating a PostgreSQL C extension function. Dmitry Igrishin 13:09
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 13:20
Re: Linker errors while creating a PostgreSQL C extension function. Dmitry Igrishin 14:28
Re: Linker errors while creating a PostgreSQL C extension function. Tom Lane 14:54
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 15:10
Re: Linker errors while creating a PostgreSQL C extension function. Dmitry Igrishin 16:52
Re: Linker errors while creating a PostgreSQL C extension function. Daniel Verite 16:59
How to create a log file in pg_log directory for each execution of my function. Raghavendra Rao J S V 17:22
Re: How to create a log file in pg_log directory for each execution of my function. Adrian Klaver 17:39
Re: How to create a log file in pg_log directory for each execution of my function. Raghavendra Rao J S V 17:46
ERROR: cache lookup failed for function 125940 DrakoRod 17:48
Postgresql 📎 Sonam Sharma 17:53
Re: Postgresql Adrian Klaver 17:55
Re: Postgresql Sonam Sharma 17:56
Re: Postgresql Adrian Klaver 18:00
Re: Postgresql Christophe Pettus 18:01
Re: ERROR: cache lookup failed for function 125940 Tom Lane 18:30
Re: Postgresql Chris Travers 18:37
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 18:48
Re: ERROR: cache lookup failed for function 125940 DrakoRod 19:07
pg_stat_statements in the query column I am not getting the exact query nikhil raj 19:15
Re: Linker errors while creating a PostgreSQL C extension function. Tom Lane 19:16
Re: ERROR: cache lookup failed for function 125940 Tom Lane 19:22
Re: ERROR: cache lookup failed for function 125940 DrakoRod 19:42
Re: [External] Re: ERROR: cache lookup failed for function 125940 Vijaykumar Jain 20:00
Re: pg_stat_statements in the query column I am not getting the exact query legrand legrand 20:49

Aug. 20, 2018

Thread Author Time
Re: Audit management Achilleas Mantzios 06:08
Allow Reg Expressions in Position function 📎 Nick Dro 06:25
Re: including header files in a C extension Laurenz Albe 07:03
Re: including header files in a C extension TalGloz 07:11
Re: Allow Reg Expressions in Position function Ken Tanzer 07:31
RE: Re: Allow Reg Expressions in Position function 📎 Nick Dro 08:22
Re: Re: Allow Reg Expressions in Position function Geoff Winkless 11:35
RE: Re: Re: Allow Reg Expressions in Position function 📎 Nick Dro 13:46
Re: Linker errors while creating a PostgreSQL C extension function. Daniel Verite 13:47
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 13:56
help defining a basic type operator Luca Ferrari 14:40
Re: help defining a basic type operator Tom Lane 14:51
[No subject] Ravi Krishna 14:53
Multiple COPY on the same table Ravi Krishna 14:54
Re: help defining a basic type operator Luca Ferrari 15:24
Re: help defining a basic type operator Tom Lane 15:29
Re: Multiple COPY on the same table Nicolas Paris 15:56
Re: Re: Re: Allow Reg Expressions in Position function Ken Tanzer 16:07
Re: [External] Multiple COPY on the same table Vijaykumar Jain 16:47
Re: Re: Re: Allow Reg Expressions in Position function Geoff Winkless 16:51
Re: [External] Multiple COPY on the same table Ravi Krishna 16:52
Re: [External] Multiple COPY on the same table Christopher Browne 17:00
Re: [External] Multiple COPY on the same table Vijaykumar Jain 17:28
Re: [External] Multiple COPY on the same table Ron 17:49
Re: [External] Multiple COPY on the same table Ravi Krishna 18:16
Re: upgrading from pg 9.3 to 10 bricklen 18:45
(was: CTE with JOIN of two tables is much faster than a regular query) Albrecht Dreß 19:08
Re: upgrading from pg 9.3 to 10 Stephen Frost 19:15
Re: Multiple COPY on the same table Adrian Klaver 20:23

Aug. 21, 2018

Thread Author Time
Question about replication Zhiquan Simon Sui 00:46
How to check whether table is busy or free before running the ALTER or creating TRIGGER on that table Raghavendra Rao J S V 13:25
Re: How to check whether table is busy or free before running the ALTER or creating TRIGGER on that table Adrian Klaver 14:17
COPY FROM - to avoid WAL generation Ravi Krishna 15:00
Re: COPY FROM - to avoid WAL generation Jeff Ross 15:26
Re: COPY FROM - to avoid WAL generation Andres Freund 15:31
Re: COPY FROM - to avoid WAL generation Ravi Krishna 15:42
Re: Multiple COPY on the same table Christopher Browne 16:14
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 18:31
SPI_cursor_fetch Memory Issue Wu Ivy 23:33

Aug. 22, 2018

Thread Author Time
Re: Linker errors while creating a PostgreSQL C extension function. Laurenz Albe 06:42
Command line session and running queries imp3 09:03
Hungarian collation in English Windows server Durumdara 12:26
Re: Hungarian collation in English Windows server Laurenz Albe 13:08
"checkpointer process" is consuming more memory. How to control it? Raghavendra Rao J S V 13:43
Re: "checkpointer process" is consuming more memory. How to control it? Adrian Klaver 13:54
Re: "checkpointer process" is consuming more memory. How to control it? Avinash Kumar 13:56
Re: "checkpointer process" is consuming more memory. How to control it? Raghavendra Rao J S V 14:02
Re: "checkpointer process" is consuming more memory. How to control it? Avi Vallarapu 14:14
Re: "checkpointer process" is consuming more memory. How to control it? Maksim Milyutin 14:43
Can Pg somehow recognize/honor linux groups to control user access ? David Gauthier 15:56
Re: Can Pg somehow recognize/honor linux groups to control user access ? Ravi Krishna 15:58
Re: Can Pg somehow recognize/honor linux groups to control user access ? David G. Johnston 16:08
Re: Can Pg somehow recognize/honor linux groups to control user access ? Joshua D. Drake 16:11
Re: Can Pg somehow recognize/honor linux groups to control user access ? Ravi Krishna 16:38
Re: Can Pg somehow recognize/honor linux groups to control user access ? David G. Johnston 16:44
Re: Can Pg somehow recognize/honor linux groups to control user access ? Dimitri Maziuk 17:23
Re: Can Pg somehow recognize/honor linux groups to control user access ? Dimitri Maziuk 18:11
Re: Can Pg somehow recognize/honor linux groups to control user access ? Tim Cross 22:17
Re: Can Pg somehow recognize/honor linux groups to control user access ? Dimitri Maziuk 22:31
Re: Can Pg somehow recognize/honor linux groups to control user access ? Tim Cross 22:31

Aug. 23, 2018

Thread Author Time
Re: upgrading from pg 9.3 to 10 bricklen 00:59
postgresql-10 armhf repository Grégoire Berclaz 06:57
Re: pg_sample naveen12 07:10
Re: Command line session and running queries Laurenz Albe 08:56
MultiXactId 24018 has not been created yet -- apparent wraparound error Dean Armada 09:13
Re: postgresql-10 armhf repository Imre Samu 10:38
Upgrade/Downgrade Sonam Sharma 10:51
Re: Upgrade/Downgrade Andreas Kretschmer 11:26
Re: Upgrade/Downgrade Sonam Sharma 11:30
Re: Upgrade/Downgrade Achilleas Mantzios 11:47
Re: pg_sample Adrian Klaver 13:04
Re: "checkpointer process" is consuming more memory. How to control it? Andres Freund 13:46
Re: MultiXactId 24018 has not been created yet -- apparent wraparound error Alvaro Herrera 14:07
Re: pg_sample Naveen Dabas 14:39
Re: pg_sample Adrian Klaver 14:47
Re: pg_sample Adrian Klaver 14:52
Re: Upgrade/Downgrade Dmitri Maziuk 14:55
Is my text_pattern_ops index working for a LIKE prefix search with column reference? Seamus Abshere 14:57
extracting the sql for a function Paul Tilles 17:17
RE: extracting the sql for a function Igor Neyman 17:46
Join condition parsing puzzle Mark Jeffcoat 18:17
Re: Upgrade/Downgrade Joshua D. Drake 18:43
RE: extracting the sql for a function Charles Clavadetscher 18:52
Re: extracting the sql for a function Melvin Davidson 19:31
Re: Upgrade/Downgrade Nikolay Samokhvalov 19:40
Re: Join condition parsing puzzle Tom Lane 21:51

Aug. 24, 2018

Thread Author Time
Re: Is my text_pattern_ops index working for a LIKE prefix search with column reference? Laurenz Albe 00:46
[No subject] Raghavendra Rao J S V 02:03
Which are the settings need to be modified inorder to implement only connection pool mechanisam in pgpool Raghavendra Rao J S V 02:03
Re: Is my text_pattern_ops index working for a LIKE prefix search with column reference? Tom Lane 02:13
Re: Upgrade/Downgrade Achilleas Mantzios 06:27
Re: Hungarian collation in English Windows server Durumdara 08:21
How to split an array into columns a 09:01
Re: How to split an array into columns Thomas Kellerer 09:09
Re: pg_sample Naveen Dabas 10:38
Arrays, casting and "constrained" data types Thomas Kellerer 11:43
Re: pg_sample Ravi Krishna 12:43
Re: pg_sample Abhinav Mehta 12:46
PG-Sample | Error | Equality operator for type json Abhinav Mehta 12:50
Re: PG-Sample | Error | Equality operator for type json Abhinav Mehta 13:07
Re: How to split an array into columns Tom Lane 13:41
Re: Hungarian collation in English Windows server Tom Lane 14:01
Re: How to split an array into columns Paul A Jungwirth 16:54
unorthodox use of PG for a customer David Gauthier 18:18
Re: unorthodox use of PG for a customer James Keener 18:29
Re: unorthodox use of PG for a customer Adrian Klaver 18:35
Re: unorthodox use of PG for a customer Edson Carlos Ericksson Richter 18:39
Re: unorthodox use of PG for a customer David Gauthier 19:07
Re: unorthodox use of PG for a customer Adrian Klaver 19:14
Re: unorthodox use of PG for a customer Dimitri Maziuk 19:20
Re: unorthodox use of PG for a customer Edson Carlos Ericksson Richter 19:22
Re: unorthodox use of PG for a customer Andrew Kerber 19:35
Re: unorthodox use of PG for a customer Dimitri Maziuk 19:54

Aug. 25, 2018

Thread Author Time
Re: Join condition parsing puzzle Mark Jeffcoat 00:43
Re: unorthodox use of PG for a customer Tim Cross 02:42
Re: pg_sample Naveen Dabas 05:44
Returning Vector of Pairs with a PostgreSQL C Extension Function TalGloz 12:54
Re: Returning Vector of Pairs with a PostgreSQL C Extension Function Tom Lane 15:44
Re: Returning Vector of Pairs with a PostgreSQL C Extension Function TalGloz 15:57
Re: Returning Vector of Pairs with a PostgreSQL C Extension Function Tom Lane 16:31
Re: Returning Vector of Pairs with a PostgreSQL C Extension Function TalGloz 17:13
Re: unorthodox use of PG for a customer Gary M 18:17
Re: Linker errors while creating a PostgreSQL C extension function. TalGloz 20:23

Aug. 26, 2018

Thread Author Time
How can I use Postgres "ROLLBACK TO SAVEPOINT" with "FOR UPDATE SKIP LOCKED"? Andrew Stuart 00:03
Size of the table is growing abnormally in my database. Raghavendra Rao J S V 03:36
Re: Size of the table is growing abnormally in my database. Adrian Klaver 04:16
pg_dump order of operation Ron 04:25
Re: Size of the table is growing abnormally in my database. Raghavendra Rao J S V 04:36
Re: Size of the table is growing abnormally in my database. Paul Carlucci 05:16
Re: Size of the table is growing abnormally in my database. Raghavendra Rao J S V 05:24
Re: pg_dump order of operation Tom Lane 15:24

Browse Archives

Prev | Next