[go: up one dir, main page]

pgsql-general - December 2011

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

Dec. 1, 2011

Thread Author Time
Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS? David Johnston 00:00
Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Tomas Vondra 00:03
Using a domain Daniele Varrazzo 00:39
Re: Using a domain Tom Lane 00:49
Problem with custom aggregates and record pseudo-type Maxim Boguk 05:46
Re: How to restore the table space tar files created by pg_basebackup? Venkat Balaji 05:59
Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS? Sergey Konoplev 08:05
Re: Is it possible to make a streaming replication faster using COPY instead of lots of INSERTS? Sergey Konoplev 08:08
Re: Strange problem with turning WAL archiving on Albe Laurenz 09:34
sql statements using access frontend Gavin Mitchell 10:49
How to get Place Names from Lat Lon Adarsh Sharma 11:46
Problem with binary data transfer format of TEXT in 8.4 Gracjan Polak 11:50
Re: psql query gets stuck indefinitely tamanna madaan 11:57
Conditional left join 📎 Amitabh Kant 12:16
Re: Conditional left join Alban Hertroys 12:27
Re: How to restore the table space tar files created by pg_basebackup? Samba 12:35
Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Magnus Hagander 12:47
Streaming Replication Over SSL Samba 12:48
Replication issue Jim Buttafuoco 13:07
Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Tomas Vondra 13:45
Re: psql query gets stuck indefinitely Tomas Vondra 13:58
Re: How to restore the table space tar files created by pg_basebackup? Magnus Hagander 14:51
Re: Streaming Replication Over SSL Magnus Hagander 14:55
session hang for same row update AI Rumman 15:10
Re: session hang for same row update Adrian Klaver 15:23
Re: Problem with custom aggregates and record pseudo-type Tom Lane 16:19
Re: Limiting number of connections to PostgreSQL per IP (not per DB/user)? Merlin Moncure 17:32
recursive inner trigger call Red Light 18:57
Re: recursive inner trigger call Gauthier, Dave 19:09
Re: recursive inner trigger call Red Light 19:17
problem with restore: collision id`s lob Hellmuth Vargas 19:21
Re: recursive inner trigger call David Johnston 19:31
Re: recursive inner trigger call Bèrto ëd Sèra 19:32
Re: recursive inner trigger call Red Light 19:36
Re: Problem with custom aggregates and record pseudo-type Maxim Boguk 19:51
returning rows from an implicit JOIN where results either exist in both tables OR only one table Lonni J Friedman 21:12
Re: returning rows from an implicit JOIN where results either exist in both tables OR only one table David Johnston 21:57
psql -1 with multiple files? Jay Levitt 22:01
Re: psql -1 with multiple files? Steve Crawford 23:28

Dec. 2, 2011

Thread Author Time
Re: psql -1 with multiple files? Jay Levitt 00:01
Re: Query Optimizer makes a poor choice Marcin Mańk 00:50
Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov 01:08
Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov 01:10
Re: returning rows from an implicit JOIN where results either exist in both tables OR only one table Lonni J Friedman 01:36
Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Venkat Balaji 03:49
Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov 08:16
How to convert HEX to ASCII? Torsten Zuehlsdorff 13:18
Re: odbc_fdw fschwend 13:50
Re: How to convert HEX to ASCII? Damien Churchill 13:58
sql statements using access frontend Gavin Mitchell 14:02
Re: How to convert HEX to ASCII? Torsten Zuehlsdorff 14:16
Re: Query Optimizer makes a poor choice Tyler Hains 14:28
Re: sql statements using access frontend Richard Huxton 14:28
order by, within a plpgsql fx david.sahagian 15:04
Re: order by, within a plpgsql fx Tom Lane 15:43
Re: How to convert HEX to ASCII? Merlin Moncure 15:46
Re: How to convert HEX to ASCII? Marti Raudsepp 16:42
Re: How to convert HEX to ASCII? Merlin Moncure 16:58
Re: How to convert HEX to ASCII? Pavel Stehule 17:15
Re: How to convert HEX to ASCII? Merlin Moncure 19:47
Re: How to convert HEX to ASCII? Pavel Stehule 20:01
\dT+ does not give elements ? Gauthier, Dave 20:13
Oddball data distribution giving me planner headaches Jeff Amiel 20:19
Re: Oddball data distribution giving me planner headaches David Johnston 20:38
Re: Oddball data distribution giving me planner headaches Jeff Amiel 20:52
Re: How to convert HEX to ASCII? Merlin Moncure 20:54
Re: How to convert HEX to ASCII? Pavel Stehule 21:01
Re: Oddball data distribution giving me planner headaches David Johnston 21:04
Re: Oddball data distribution giving me planner headaches Jeff Amiel 21:15
Re: Oddball data distribution giving me planner headaches David Johnston 21:28
Re: \dT+ does not give elements ? Tom Lane 21:54
Re: Oddball data distribution giving me planner headaches Jeff Amiel 22:06
Re: Oddball data distribution giving me planner headaches Tom Lane 22:09
Re: Oddball data distribution giving me planner headaches David Johnston 22:15
Re: Oddball data distribution giving me planner headaches Jeff Amiel 22:20
Re: Oddball data distribution giving me planner headaches Jeff Amiel 22:22
weird negative seconds on checkpoint message. Ing.Edmundo.Robles.Lopez 22:33
Re: weird negative seconds on checkpoint message. Ing.Edmundo.Robles.Lopez 22:48
Re: weird negative seconds on checkpoint message. Adrian Klaver 22:50
Re: Oddball data distribution giving me planner headaches Jeff Amiel 23:11
Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Andre Lopes 23:13
Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. David Johnston 23:28
Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Adrian Klaver 23:34
Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. John R Pierce 23:36
Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Andre Lopes 23:41
Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. John R Pierce 23:46
Re: Can't access to database from webapp in PostgreSQL 9.0, from shell it is Ok. Andre Lopes 23:52

Dec. 3, 2011

Thread Author Time
[No subject] gouse shaik 02:37
Re: PostgreSQL 9.0 and asynchronous replication through VPN Edson Richter 03:01
Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Craig Ringer 07:23
Re: Oddball data distribution giving me planner headaches Harald Fuchs 09:12
Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 12:39
Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Tomas Vondra 14:10
Re: Shared memory usage in PostgreSQL 9.1 Tomas Vondra 14:34
Re: How to convert HEX to ASCII? Torsten Zühlsdorff 14:35
Re: Postgresql + corrupted disk = data loss. (Need help for database recover) Oleg Serov 15:31
Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 17:02
Re: Shared memory usage in PostgreSQL 9.1 Tom Lane 17:39
returning results from plsql function to plpythonu function c k 17:50
Re: returning results from plsql function to plpythonu function Lou Picciano 17:55
Re: returning results from plsql function to plpythonu function c k 18:01
Re: returning results from plsql function to plpythonu function c k 18:14
Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 18:23
Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 18:51
Re: returning results from plsql function to plpythonu function Lou Picciano 18:51
Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 19:31
Re: returning results from plsql function to plpythonu function c k 19:32
Re: How to get Place Names from Lat Lon Josh Kupershmidt 20:15
Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 21:33
Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 21:33

Dec. 4, 2011

Thread Author Time
Foreign keys question (performance) Phoenix Kiula 10:19
Re: Foreign keys question (performance) Alban Hertroys 11:14
Weird behavior: deleted row still in index? Phoenix Kiula 11:32
Re: Foreign keys question (performance) Phoenix Kiula 11:41
Re: Weird behavior: deleted row still in index? Alban Hertroys 11:51
Re: Weird behavior: deleted row still in index? Szymon Guz 11:55
BUG #6325: Useless Index updates dmigowski 12:54
Re: Weird behavior: deleted row still in index? Phoenix Kiula 12:56
Re: BUG #6325: Useless Index updates Craig Ringer 14:02
Re: Shared memory usage in PostgreSQL 9.1 Stephen Frost 14:06
Re: Shared memory usage in PostgreSQL 9.1 📎 sfrost 14:17
Re: Shared memory usage in PostgreSQL 9.1 Tomas Vondra 14:33
Re: Shared memory usage in PostgreSQL 9.1 Christoph Zwerschke 15:20
Re: BUG #6325: Useless Index updates hubert depesz lubaczewski 20:07
Re: Shared memory usage in PostgreSQL 9.1 Tom Lane 21:23

Dec. 5, 2011

Thread Author Time
Re: BUG #6325: Useless Index updates Andreas Karlsson 00:16
Re: BUG #6325: Useless Index updates Craig Ringer 00:25
WITH and WITH RECURSIVE in single query Maxim Boguk 03:28
Re: WITH and WITH RECURSIVE in single query Tom Lane 03:41
Questions about setting an array element value outside of the update Maxim Boguk 03:43
Re: WITH and WITH RECURSIVE in single query David Johnston 03:45
Re: WITH and WITH RECURSIVE in single query Maxim Boguk 03:58
Re: Questions about setting an array element value outside of the update David Johnston 04:03
pl/pgsql and arrays[] Maxim Boguk 04:06
What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Mike Christensen 04:10
Re: Questions about setting an array element value outside of the update Tom Lane 04:13
Re: WITH and WITH RECURSIVE in single query David Johnston 04:15
Re: WITH and WITH RECURSIVE in single query Maxim Boguk 04:35
Re: pl/pgsql and arrays[] Pavel Stehule 04:53
Re: pl/pgsql and arrays[] Maxim Boguk 05:11
Re: pl/pgsql and arrays[] Pavel Stehule 05:20
Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Craig Ringer 07:12
Re: psql query gets stuck indefinitely tamanna madaan 07:15
Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Mike Christensen 07:31
Re: odbc_fdw Florian Schwendener 08:07
Regarding licensing of Postgresql Jayashankar K B 08:23
Re: Regarding licensing of Postgresql John R Pierce 08:42
Re: odbc_fdw Albe Laurenz 08:52
Re: Regarding licensing of Postgresql Jayashankar K B 08:55
Re: Regarding licensing of Postgresql John R Pierce 08:59
Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Albe Laurenz 09:04
Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Filip Rembiałkowski 10:48
Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Cédric Villemain 10:54
pg_standby: How to check in which state the server is currently? Frank Lanitz 11:16
Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Craig Ringer 11:25
Re: Regarding licensing of Postgresql Craig Ringer 11:31
FATAL: the database system is starting up Dave Cramer 11:43
Re: FATAL: the database system is starting up Dave Cramer 12:07
Re: Regarding licensing of Postgresql Andrew Sullivan 12:43
Re: Regarding licensing of Postgresql Gregg Jaskiewicz 14:59
plpgsql question Gauthier, Dave 14:59
Re: plpgsql question Adrian Klaver 15:11
Re: pg_standby: How to check in which state the server is currently? Ray Stell 15:50
Re: pg_standby: How to check in which state the server is currently? Cédric Villemain 16:02
Re: pl/pgsql and arrays[] Tom Lane 16:11
Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row? Francisco Figueiredo Jr. 16:41
Re: pl/pgsql and arrays[] Pavel Stehule 16:47
High-Concurrency GiST in postgreSQL C. Mundi 18:31
disallow SET WORK_MEM Andreas Kretschmer 18:41
Installing different PostgreSQL versions in parallel Rafael Ostertag 18:43
Re: disallow SET WORK_MEM Bruce Momjian 19:13
Re: High-Concurrency GiST in postgreSQL Andy Colson 19:26
Re: disallow SET WORK_MEM Tom Lane 20:00
Re: High-Concurrency GiST in postgreSQL C. Mundi 21:34
Re: High-Concurrency GiST in postgreSQL John R Pierce 21:41
Re: High-Concurrency GiST in postgreSQL John R Pierce 21:53
Re: High-Concurrency GiST in postgreSQL Andy Colson 22:26
Re: High-Concurrency GiST in postgreSQL C. Mundi 22:40
Re: High-Concurrency GiST in postgreSQL Andy Colson 22:59

Dec. 6, 2011

Thread Author Time
Re: Regarding licensing of Postgresql Craig Ringer 00:36
Re: gouse shaik 08:57
Re: pg_standby: How to check in which state the server is currently? Frank Lanitz 10:28
How to retrieve rows with empty value in numeric(12,8) columns Adarsh Sharma 10:39
Re: How to retrieve rows with empty value in numeric(12,8) columns Adarsh Sharma 10:53
Re: How to retrieve rows with empty value in numeric(12,8) columns Adarsh Sharma 11:00
Re: How to retrieve rows with empty value in numeric(12,8) columns Raymond O'Donnell 11:07
Re: How to retrieve rows with empty value in numeric(12,8) columns Alban Hertroys 11:18
Re: How to retrieve rows with empty value in numeric(12,8) columns Bèrto ëd Sèra 11:20
Re: BUG #6325: Useless Index updates Daniel Migowski 14:41
Re: [BUGS] BUG #6325: Useless Index updates Daniel Migowski 14:51
Re: [BUGS] BUG #6325: Useless Index updates Gregg Jaskiewicz 15:14
Re: Foreign keys question (performance) Phoenix Kiula 16:45
PostgreSQL DBA in SPAAAAAAAACE Joe Miller 16:56
Re: Foreign keys question (performance) David Johnston 17:07
Re: PostgreSQL DBA in SPAAAAAAAACE Merlin Moncure 17:30
Re: PostgreSQL DBA in SPAAAAAAAACE Torello Querci 17:33
Re: PostgreSQL DBA in SPAAAAAAAACE Bèrto ëd Sèra 18:02
Re: Foreign keys question (performance) Adrian Klaver 20:39
Re: PostgreSQL DBA in SPAAAAAAAACE Glyn Astill 20:56
Re: PostgreSQL DBA in SPAAAAAAAACE Rob Sargent 21:20

Browse Archives

Prev | Next