pgsql-general since 2012-11-15 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

Nov. 15, 2012

Thread Author Time
Re: SSDs - SandForce or not? Toby Corkindale 00:40
Re: Access disk from plpython Craig Ringer 01:21
Re: Using Postgresql 9.2 on windows 7 and windows vista Craig Ringer 01:24
Re: File system level copy Wang, Hao 01:44
Re: FATAL: index contains unexpected zero page at block Dmitriy Tyugaev 07:58
Re: FATAL: index contains unexpected zero page at block Dmitriy Tyugaev 08:31
Re: File system level copy Albe Laurenz 08:52
Re: File system level copy Wang, Hao 09:12
Re: Finding first free time from reservations table hari.fuchs 09:17
Re: File system level copy Albe Laurenz 09:53
Postgres Index Vishalakshi Navaneethakrishnan 11:11
Re: Postgres Index Thomas Kellerer 11:19
Re: Postgres Index Albe Laurenz 11:31
Re: Strategies/Best Practises Handling Large Tables Chitra Creta 11:34
Re: Postgres Index Dann Corbit 11:55
How to list all schema names inside a PostgreSQL database through SQL Xiaobo Gu 12:31
Re: How to list all schema names inside a PostgreSQL database through SQL Виктор Егоров 12:41
Re: How to list all schema names inside a PostgreSQL database through SQL Achilleas Mantzios 12:43
Re: How to list all schema names inside a PostgreSQL database through SQL sk baji 13:13
Re: Strategies/Best Practises Handling Large Tables Igor Romanchenko 14:40
Plproxy with returns table() make PG segfault Sébastien Lardière 17:27
Re: High SYS CPU - need advise Merlin Moncure 17:28
Re: High SYS CPU - need advise Vlad 17:50
user aggregate function ( calculate the average value of each index of an array column ) Myoung-Ah KANG 18:10
Re: Finding first free time from reservations table Steve Crawford 18:45
Re: Plproxy with returns table() make PG segfault Cédric Villemain 19:40
Re: High SYS CPU - need advise Merlin Moncure 20:11
Re: High SYS CPU - need advise Vlad 20:20
Re: High SYS CPU - need advise Merlin Moncure 20:31
Re: High SYS CPU - need advise Vlad 20:44
Re: How to list all schema names inside a PostgreSQL database through SQL Ondrej Ivanič 21:33
Re: High SYS CPU - need advise Merlin Moncure 21:49
Re: High SYS CPU - need advise Merlin Moncure 22:16
Re: High SYS CPU - need advise Alvaro Herrera 22:29
Re: High SYS CPU - need advise Vlad 22:31
Percent of Total in Histogram Query Paul Jungwirth 22:44
Re: High SYS CPU - need advise Merlin Moncure 22:44
Re: Percent of Total in Histogram Query David Johnston 22:58
Re: High SYS CPU - need advise Tom Lane 23:52

Nov. 16, 2012

Thread Author Time
Re: High SYS CPU - need advise Vlad Marchenko 00:06
Re: High SYS CPU - need advise Jeff Janes 00:07
PG_TERMINATE_BACKEND not working. Harry 06:34
Purge Logs from pgagent P. Broennimann 06:58
Aggeregate funtion calculating the average value of each same index of an array column in a table LEA KANG 08:52
Re: Plproxy with returns table() make PG segfault Sébastien Lardière 09:09
Pg/SQL returning composite type P. Broennimann 09:46
Re: Pg/SQL returning composite type Raymond O'Donnell 09:58
Re: Aggeregate funtion calculating the average value of each same index of an array column in a table David Johnston 13:26
Set returning functions in the SELECT list Ryan Kelly 14:14
Re: High SYS CPU - need advise Merlin Moncure 15:28
Re: Set returning functions in the SELECT list Tom Lane 15:31
Re: High SYS CPU - need advise Vlad 15:52
Check table storage parameters Lee Hachadoorian 16:11
Re: High SYS CPU - need advise Merlin Moncure 16:21
Re: Check table storage parameters Mike Blackwell 17:08
Re: High SYS CPU - need advise Vlad 17:19
Re: Full text search ranking: ordering using index and proximiti ranking with OR queries Nicolas Grilly 17:37
Re: High SYS CPU - need advise Merlin Moncure 17:39
Re: Check table storage parameters Lee Hachadoorian 18:07
Re: High SYS CPU - need advise 📎 Jeff Janes 18:26
PostgreSQL logging - restrict error messages hartrc 18:40
Re: High SYS CPU - need advise Merlin Moncure 19:19
Re: Full text search ranking: ordering using index and proximiti ranking with OR queries Merlin Moncure 19:25
Noticed something odd with pgbench Shaun Thomas 19:35
Re: Noticed something odd with pgbench Richard Huxton 19:59
Re: Noticed something odd with pgbench Shaun Thomas 20:09
Re: High SYS CPU - need advise Vlad 20:13
Re: High SYS CPU - need advise Merlin Moncure 20:31
Re: Noticed something odd with pgbench Steven Schlansker 20:44
Re: High SYS CPU - need advise Vlad 21:21
Re: High SYS CPU - need advise Merlin Moncure 21:32

Nov. 17, 2012

Thread Author Time
9.2 streaming replication issue and solution strategy T. E. Lawrence 14:08
Parser - Query Analyser Michael Giannakopoulos 14:18
Re: Parser - Query Analyser David Johnston 14:44
Re: 9.2 streaming replication issue and solution strategy Adrian Klaver 15:12
Re: Parser - Query Analyser Tom Lane 15:17
Re: 9.2 streaming replication issue and solution strategy T. E. Lawrence 15:33
Using a GIN index on an integer array to model sets of tags Mike Jarmy 16:01
Re: Parser - Query Analyser Любен Каравелов 16:01
Re: Using a GIN index on an integer array to model sets of tags T. E. Lawrence 16:39
Re: 9.2 streaming replication issue and solution strategy Adrian Klaver 19:33
Re: Using a GIN index on an integer array to model sets of tags Ryan Kelly 21:15
Re: Plproxy with returns table() make PG segfault Marko Kreen 21:43

Nov. 18, 2012

Thread Author Time
Re: Difference between varchar and text? Jasen Betts 01:11
Re: Difference between varchar and text? David Johnston 01:37
Re: Exclusion constraints with time expressions Jasen Betts 01:41
Re: Difference between varchar and text? John R Pierce 01:43
Re: Difference between varchar and text? David Johnston 01:49
Prepared Statement Name Truncation Phil Sorber 02:12
Re: Exclusion constraints with time expressions Jasen Betts 02:15
Re: Exclusion constraints with time expressions Jasen Betts 02:27
Re: Prepared Statement Name Truncation Stephen Frost 02:46
Re: Prepared Statement Name Truncation Greg Sabino Mullane 03:49
Re: Prepared Statement Name Truncation Gavin Flower 03:54
Re: Prepared Statement Name Truncation Gavin Flower 04:06
Re: Prepared Statement Name Truncation Phil Sorber 04:10
Re: Prepared Statement Name Truncation Gavin Flower 04:19
Re: [GENERAL] Prepared Statement Name Truncation Tom Lane 07:24
Re: Difference between varchar and text? Tom Lane 07:29
Re: Prepared Statement Name Truncation Tom Lane 07:33
Re: Difference between varchar and text? Abel Abraham Camarillo Ojeda 07:48
Re: Difference between varchar and text? John R Pierce 08:39
Re: user aggregate function ( calculate the average value of each index of an array column ) Vincent Veyron 09:21
Re: PG_TERMINATE_BACKEND not working. Craig Ringer 11:25
Re: PG_TERMINATE_BACKEND not working. Chris Angelico 11:48
Re: Parser - Query Analyser Craig Ringer 12:34
Re: [GENERAL] Prepared Statement Name Truncation David Johnston 14:10
Re: Difference between varchar and text? Vick Khera 16:57
Re: Prepared Statement Name Truncation Phil Sorber 18:14
Re: High SYS CPU - need advise Jeff Janes 22:24
Re: [BUGS] Prepared Statement Name Truncation Gavan Schneider 23:32

Nov. 19, 2012

Thread Author Time
Re: Prepared Statement Name Truncation Tom Lane 00:13
Re: [HACKERS] Parser - Query Analyser Craig Ringer 00:21
Re: Parser - Query Analyser Craig Ringer 00:21
Re: Difference between varchar and text? Craig Ringer 00:24
Re: Difference between varchar and text? Vick Khera 00:35
Re: Difference between varchar and text? Jeff Janes 00:45
Re: Difference between varchar and text? Tom Lane 01:10
Fuzzystrmatch contrib module on RHEL63 Ike Nnabugwu 02:13
Re: Fuzzystrmatch contrib module on RHEL63 Peter Geoghegan 03:21
EDB installer should check for valid %COMSPEC% Craig Ringer 04:29
Full text search in Chinese Christian Jensen 04:43
Re: How to list all schema names inside a PostgreSQL database through SQL Xiaobo Gu 05:01
Re: How to list all schema names inside a PostgreSQL database through SQL Xiaobo Gu 05:05
Re: PG_TERMINATE_BACKEND not working. Harry 05:22
Experiences with pl/Java Thomas Hill 08:02
Re: EDB installer should check for valid %COMSPEC% Dave Page 09:14
Re: Fuzzystrmatch contrib module on RHEL63 Devrim GÜNDÜZ 10:55
How to upgrade postgres 8.4 -> 9.1 contrib? Benedikt Grundmann 10:56
remote connection refused Yvon Thoraval 12:08
Re: remote connection refused Martin French 12:17
Re: remote connection refused Devrim GÜNDÜZ 12:18
Maintaining state across function calls matt 12:41
Re: remote connection refused Yvon Thoraval 12:50
Re: Maintaining state across function calls Craig Ringer 13:29
Re: Prepared Statement Name Truncation Stephen Frost 13:43
Re: Maintaining state across function calls matt 14:09
Re: High SYS CPU - need advise Merlin Moncure 14:33
Re: Experiences with pl/Java Welty, Richard 14:55
Re: How to upgrade postgres 8.4 -> 9.1 contrib? Tom Lane 15:22
Re: How to upgrade postgres 8.4 -> 9.1 contrib? Benedikt Grundmann 15:27
Re: Maintaining state across function calls Tom Lane 15:28
Re: Prepared Statement Name Truncation Tom Lane 15:30
Re: Experiences with pl/Java Peter Geoghegan 16:26
Re: High SYS CPU - need advise Vlad 16:50
Re: Experiences with pl/Java Achilleas Mantzios 16:55
Re: High SYS CPU - need advise Merlin Moncure 17:19
Re: Experiences with pl/Java Edson Richter 17:21
Re: Experiences with pl/Java Welty, Richard 17:26
Re: Experiences with pl/Java Edson Richter 17:42
Re: High SYS CPU - need advise Vlad 18:02
PITR manual doesn't reference pg_receivexlog? Joe Van Dyk 18:35
Re: Maintaining state across function calls matt 18:37
Re: Experiences with pl/Java Welty, Richard 19:19
Re: Maintaining state across function calls Tom Lane 19:37
Split_part on a CR Jeff Ross 19:49
Re: Experiences with pl/Java Thomas Hill 19:55
Re: Split_part on a CR Tom Lane 19:59
Re: Split_part on a CR Gary Chambers 20:00
Re: High SYS CPU - need advise Merlin Moncure 20:04
Re: Split_part on a CR David Johnston 20:04
Re: Split_part on a CR Jeff Ross 21:08
Re: Experiences with pl/Java Thomas Hill 22:56
Re: Experiences with pl/Java John R Pierce 23:40

Nov. 20, 2012

Thread Author Time
get source of udf Peter Kroon 00:29
Re: [SOLVED] WINDOWS : PostgreSQL 8.4 Server Start Error JulAkmad, Julpikar 00:51
Re: High SYS CPU - need advise Vlad Marchenko 01:23
Re: Prepared Statement Name Truncation Craig Ringer 01:23
Re: Maintaining state across function calls Craig Ringer 01:30
Re: Maintaining state across function calls Peter Geoghegan 01:57
Re: Experiences with pl/Java Welty, Richard 04:05
Re: PG_TERMINATE_BACKEND not working. Raghavendra 07:21
Trigger based replication with ENABLE REPLICA triggers and session_replication_role best practice(s) Achilleas Mantzios 07:52
flush buffer after connection disllowed 张柏年 10:09
Re: get source of udf Pavel Stehule 10:40
Performance Testing Metrics Harry 11:54
fetch from cursor in pg_stats_activity and related SQL query aasat 12:30
Re: flush buffer after connection disllowed Craig Ringer 12:32
Re: PG_TERMINATE_BACKEND not working. dinesh kumar 13:45
Request for help setting up source tree r d 14:51
Re: High SYS CPU - need advise Shaun Thomas 15:02
Re: High SYS CPU - need advise Merlin Moncure 16:03
Re: High SYS CPU - need advise Shaun Thomas 16:12
Re: High SYS CPU - need advise Merlin Moncure 16:13
Re: High SYS CPU - need advise Shaun Thomas 16:21
Re: Request for help setting up source tree r d 16:37
Re: High SYS CPU - need advise Jeff Janes 16:50
Re: High SYS CPU - need advise Merlin Moncure 16:53
Re: High SYS CPU - need advise Merlin Moncure 17:05
Re: High SYS CPU - need advise Jeff Janes 18:16
COPY FROM in psql Matthew Vernon 18:46
Re: COPY FROM in psql Matthew Vernon 18:47
Re: COPY FROM in psql Matthew Vernon 18:55
Re: COPY FROM in psql Rob Sargent 19:03
Re: COPY FROM in psql Tom Lane 19:05
Re: Experiences with pl/Java Thomas 19:06
Simple queries slowdown, maybe related to 3-minute long "<IDLE> in transaction"? Dmitry Koterov 19:25
get column name passed to a function Rhys A.D. Stewart 19:36
Re: High SYS CPU - need advise Merlin Moncure 20:00
Re: Simple queries slowdown, maybe related to 3-minute long "<IDLE> in transaction"? Merlin Moncure 20:33

Browse Archives

Prev | Next