pgsql-general - October 2014

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

Oct. 1, 2014

Thread Author Time
Re: improving speed of query that uses a multi-column "filter" ? John R Pierce 00:04
Re: improving speed of query that uses a multi-column "filter" ? Jonathan Vanasco 00:46
Re: improving speed of query that uses a multi-column "filter" ? Misa Simic 04:34
Re: table versioning approach (not auditing) Felix Kunde 09:19
Extract especific text from a sql statement Emanuel Araújo 12:19
Best practices for Large import in empty database? Daniel Begin 14:13
Re: Best practices for Large import in empty database? Tom Lane 14:37
Re: Best practices for Large import in empty database? Andy Colson 14:41
Postgres tcp_keepalive_xxxx parameters. jlrando 14:57
Re: Best practices for Large import in empty database? Daniel Begin 15:00
Re: Postgres tcp_keepalive_xxxx parameters. Tom Lane 15:04
Re: table versioning approach (not auditing) Adam Brusselback 15:09
Re: Extract especific text from a sql statement David G Johnston 15:56
Re: improving speed of query that uses a multi-column "filter" ? Jonathan Vanasco 16:12
Is there a way to get both the plan and the results? François Beausoleil 17:46
Re: Is there a way to get both the plan and the results? David G Johnston 18:40
Re: Extract especific text from a sql statement Melvin Davidson 19:52
Re: Extract especific text from a sql statement David G Johnston 20:10

Oct. 2, 2014

Thread Author Time
PostgreSQL Inheritance and column mapping Achilleas Mantzios 11:51
Re: PostgreSQL Inheritance and column mapping John R Pierce 12:11
Re: PostgreSQL Inheritance and column mapping Tom Lane 14:00
Re: table versioning approach (not auditing) Adam Brusselback 14:27
Re: table versioning approach (not auditing) Adam Brusselback 14:38
Getting my Database name in a C Extension Cedric Berger 15:11
Getting my Database name in a C Extension Cedric Berger 15:38
Re: Getting my Database name in a C Extension Tom Lane 16:13
Creating a PL/pgSQL function that returns multiple out parameters and refcursor Néstor Boscán 16:15
Re: Postgres tcp_keepalive_xxxx parameters. José Luis Rando Calvo 17:08
Benching Queries Jonathan Vanasco 20:13
Creating index on concatenated char columns fails is Postgres 9 (regression) Andrus 20:49
How to find greatest record before known values fast Andrus 20:49
installing on mac air development machine john.tiger 22:50
Re: Getting my Database name in a C Extension John R Pierce 23:01
Re: installing on mac air development machine Ian Barwick 23:21
Re: installing on mac air development machine john gale 23:30
Re: installing on mac air development machine john gale 23:30
Re: installing on mac air development machine Jonathan Vanasco 23:36
Re: installing on mac air development machine Adrian Klaver 23:37

Oct. 3, 2014

Thread Author Time
Re: Creating index on concatenated char columns fails is Postgres 9 (regression) Adrian Klaver 00:11
Re: How to find greatest record before known values fast Jim Nasby 02:44
Re: PostgreSQL Inheritance and column mapping Jim Nasby 02:54
Re: How to find greatest record before known values fast David G Johnston 03:04
Re: installing on mac air development machine John R Pierce 03:04
Re: How to find greatest record before known values fast Tom Lane 03:54
Re: installing on mac air development machine Steve Atkins 04:12
Re: Creating a PL/pgSQL function that returns multiple out parameters and refcursor Michael Paquier 04:40
Re: How to find greatest record before known values fast Andrus 06:28
Re: Getting my Database name in a C Extension Cedric Berger 07:31
Re: PostgreSQL Inheritance and column mapping Achilleas Mantzios 07:49
Re: Getting my Database name in a C Extension Albe Laurenz 07:57
Re: Getting my Database name in a C Extension Michael Paquier 08:23
Re: deadlock of lock-waits (on transaction and on tuple) using same update statement Andrej Vanek 09:36
Re: Getting my Database name in a C Extension Cedric Berger 11:54
Re: How to find greatest record before known values fast Merlin Moncure 14:44
Really strange foreign key constraint problem blocking delete Tim Mickelson 16:17
faster way to calculate top "tags" for a "resource" based on a column Jonathan Vanasco 16:21
Re: Really strange foreign key constraint problem blocking delete Vick Khera 18:38
Processor usage/tuning question Israel Brewster 19:24
Re: How to find greatest record before known values fast Andrus 20:28
Re: How to find greatest record before known values fast Merlin Moncure 20:45
Re: Processor usage/tuning question Alan Hodgson 21:40
Re: How to find greatest record before known values fast Adrian Klaver 22:36
Re: How to find greatest record before known values fast Tom Lane 22:59
Re: How to find greatest record before known values fast Adrian Klaver 23:15

Oct. 4, 2014

Thread Author Time
Re: Processor usage/tuning question Andy Colson 02:28
Re: Really strange foreign key constraint problem blocking delete Tim Mickelson 05:45
Re: Really strange foreign key constraint problem blocking delete Adrian Klaver 14:00
Re: Really strange foreign key constraint problem blocking delete Andy Colson 14:06
How to callproc a PL/pgSQL function a cursor OUT parameter and two OUT parameters Néstor Boscán 16:16
Re: How to callproc a PL/pgSQL function a cursor OUT parameter and two OUT parameters Adrian Klaver 16:51
Re: How to callproc a PL/pgSQL function a cursor OUT parameter and two OUT parameters Adrian Klaver 19:15
Re: How to find greatest record before known values fast Andrus 20:34
Re: How to find greatest record before known values fast Andrus 20:46

Oct. 5, 2014

Thread Author Time
Re: Really strange foreign key constraint problem blocking delete Tim Mickelson 11:01
Re: Really strange foreign key constraint problem blocking delete Tim Mickelson 11:03
Re: Really strange foreign key constraint problem blocking delete Adrian Klaver 13:54
Re: Really strange foreign key constraint problem blocking delete Tim Mickelson 14:37
Re: Really strange foreign key constraint problem blocking delete Andy Colson 14:56
Re: Really strange foreign key constraint problem blocking delete Adrian Klaver 15:00
Re: Really strange foreign key constraint problem blocking delete Andy Colson 15:06

Oct. 6, 2014

Thread Author Time
How does PostgerSQL planner decide driving table Shingo horiuchi 05:38
How to get good performance for very large lists/sets? Richard Frith-Macdonald 08:02
Converting char to varchar automatically Andrus 10:29
Re: Converting char to varchar automatically Andy Colson 14:04
<idle> question 📎 Emi Lu 15:07
Re: How to find greatest record before known values fast Merlin Moncure 15:10
Re: <idle> question Andy Colson 15:15
Re: Really strange foreign key constraint problem blocking delete Tim Mickelson 15:25
Re: Converting char to varchar automatically Melvin Davidson 15:25
Re: How does PostgerSQL planner decide driving table Emanuel Calvo 16:24
Re: How to get good performance for very large lists/sets? Igor Neyman 16:54
Re: Converting char to varchar automatically Andrus 17:11
Re: How to get good performance for very large lists/sets? Andy Colson 17:22
Re: Converting char to varchar automatically hari.fuchs 17:41
Re: How to get good performance for very large lists/sets? François Beausoleil 17:52
Re: How to get good performance for very large lists/sets? Richard Frith-Macdonald 17:52
Re: How to get good performance for very large lists/sets? Igor Neyman 18:25
Re: How to get good performance for very large lists/sets? Andy Colson 19:14
Re: How to get good performance for very large lists/sets? Jeff Janes 19:17
Re: How to get good performance for very large lists/sets? Andy Colson 19:47
Re: table versioning approach (not auditing) Jim Nasby 21:47
Re: faster way to calculate top "tags" for a "resource" based on a column Jim Nasby 21:56
Re: Processor usage/tuning question Jim Nasby 22:00
Re: <idle> question Jim Nasby 22:08
Re: Really strange foreign key constraint problem blocking delete Jim Nasby 22:15
Re: Converting char to varchar automatically Jim Nasby 22:18
Re: How to get good performance for very large lists/sets? Jim Nasby 22:29
Re: Converting char to varchar automatically Melvin Davidson 22:49
Re: faster way to calculate top "tags" for a "resource" based on a column Jonathan Vanasco 23:07
Re: table versioning approach (not auditing) Gavin Flower 23:10
Re: Converting char to varchar automatically Tom Lane 23:16