pgsql-general - June 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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30

June 1, 2014

Thread Author Time
Re: Extended Prefetching using Asynchronous IO - proposal and patch 📎 johnlumby 00:44
Re: Extended Prefetching using Asynchronous IO - proposal and patch johnlumby 01:03
Re: Extended Prefetching using Asynchronous IO - proposal and patch Claudio Freire 05:27
Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" David Wall 06:41
Re: Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" John R Pierce 06:47
Re: Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" David Wall 07:16
Re: Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" David Wall 07:18
Re: Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" John R Pierce 07:32
Re: Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" Adrian Klaver 16:05
Re: Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" Tom Lane 16:25
Re: [GENERAL] Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" David Wall 18:42
Re: [GENERAL] Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST" Adrian Klaver 19:54
Re: Merge a sharded master into a single read-only slave Sébastien Lorion 19:59
Re: Merge a sharded master into a single read-only slave John R Pierce 20:10
Re: Extended Prefetching using Asynchronous IO - proposal and patch Heikki Linnakangas 22:33

June 2, 2014

Thread Author Time
Re: How is sorting work? Rajeev rastogi 05:03
How can I select rows by comparing an array data type column with multiple values ? Arup Rakshit 10:54
Re: How can I select rows by comparing an array data type column with multiple values ? Raymond O'Donnell 11:21
Re: How can I select rows by comparing an array data type column with multiple values ? Steve Crawford 15:32
Re: How can I select rows by comparing an array data type column with multiple values ? Arup Rakshit 15:38
Re: Merge a sharded master into a single read-only slave Kevin Goess 16:52
Re: Merge a sharded master into a single read-only slave Sébastien Lorion 18:47

June 3, 2014

Thread Author Time
Re: Archive# views Kapil Agarwal 01:34
Re: new index type with clustering in mind. Jack Douglas 07:24
bytea Issue - Reg sramay 08:25
Re: libpq: indefinite block on poll during network problems Merlin Moncure 20:08

June 4, 2014

Thread Author Time
Re: bytea Issue - Reg Adrian Klaver 00:39
pg_largeobject high overhead Jason Newton 04:08
Re: bytea Issue - Reg sramay 05:02
Re: Postgresql service stopped automatically after restart Kalai R 05:58
Re: How can I select rows by comparing an array data type column with multiple values ? Arup Rakshit 06:25
Re: How can I select rows by comparing an array data type column with multiple values ? Arup Rakshit 06:33
Re: How can I select rows by comparing an array data type column with multiple values ? Arup Rakshit 07:15
pg_largeobject high overhead Jason Newton 07:45
Migrating from 9.2.4 to 9.3.0 with XML DOCTYPE Tim Kane 11:59
Migrating from 9.2.4 to 9.3.0 with XML DOCTYPE Tim Kane 12:05
PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Bhushan Pathak 12:20
Re: Migrating from 9.2.4 to 9.3.0 with XML DOCTYPE David G Johnston 12:20
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Devrim Gündüz 12:32
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Adrian Klaver 13:34
Re: Migrating from 9.2.4 to 9.3.0 with XML DOCTYPE Tom Lane 15:06
Partial solution to observed " MultiXactId ### has not been created yet -- apparent wraparound" issue with newly upgraded db Bill Mitchell 15:38
Re: [GENERAL] Migrating from 9.2.4 to 9.3.0 with XML DOCTYPE Tim Kane 16:04
Re: pg_largeobject high overhead Tom Lane 16:21
Re: Re: PostgreSQL 9.3 XML parser seems not to recognize the DOCTYPE element in XML files Peter Eisentraut 17:44
Re: Merge a sharded master into a single read-only slave Keith Fiske 17:50
Re: PostgreSQL 9.3 XML parser seems not to recognize the DOCTYPE element in XML files David G Johnston 19:29
Re: pg_largeobject high overhead Jason Newton 21:42

June 5, 2014

Thread Author Time
Re: bytea Issue - Reg Adrian Klaver 01:13
Re: Postgresql service stopped automatically after restart Adrian Klaver 02:38
Re: Postgresql service stopped automatically after restart Kalai R 05:31
Re: bytea Issue - Reg sramay 05:49
Re: Merge a sharded master into a single read-only slave Koichi Suzuki 05:57
Re: Postgresql service stopped automatically after restart Kalai R 12:59
help with a procedure Carlos Carcamo 15:32
Re: help with a procedure Carlos Carcamo 15:36
Re: Merge a sharded master into a single read-only slave Sébastien Lorion 15:41
Re: help with a procedure Seref Arikan 15:45
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Bhushan Pathak 16:11
Re: help with a procedure Seref Arikan 16:13
Re: help with a procedure Seref Arikan 16:14
Re: help with a procedure Carlos Carcamo 16:25
Re: help with a procedure David G Johnston 16:39
Re: help with a procedure Carlos Carcamo 16:45
Re: Merge a sharded master into a single read-only slave Francisco Olarte 16:55
Re: Heartbleed Impact Dev Kumkar 17:30
Re: Heartbleed Impact Magnus Hagander 17:33
Re: Merge a sharded master into a single read-only slave Sébastien Lorion 18:09
Re: help with a procedure David G Johnston 18:28
Re: Heartbleed Impact Dev Kumkar 18:46
screwed up authentication john.tiger 19:24
Re: screwed up authentication John R Pierce 19:51
Re: screwed up authentication Ray Stell 21:07
Optimizer issue -- bad query plan? Moshe Jacobson 21:43
Re: Optimizer issue -- bad query plan? John R Pierce 22:09
Re: Optimizer issue -- bad query plan? Moshe Jacobson 22:35
Re: Optimizer issue -- bad query plan? David G Johnston 22:38
Re: Merge a sharded master into a single read-only slave Keith Fiske 22:48
Re: Optimizer issue -- bad query plan? Moshe Jacobson 22:54
Re: Optimizer issue -- bad query plan? Tom Lane 23:19

June 6, 2014

Thread Author Time
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Adrian Klaver 00:18
Re: help with a procedure Adrian Klaver 00:29
pg_attribute growing extremely hamann.w 03:56
Re: pg_attribute growing extremely David G Johnston 04:44
Re: pg_attribute growing extremely Martijn van Oosterhout 06:24
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Bhushan Pathak 07:29
Postgress Doubts Ravi Kiran 10:52
Re: Postgress Doubts Atri Sharma 10:59
Re: Optimizer issue -- bad query plan? Moshe Jacobson 12:55
interpret bytea output as text / double encode() Stefan Froehlich 13:00
Trigger to convert UNIX time to timestamp without time zone. Alberto Olivares 13:19
Re: interpret bytea output as text / double encode() Rob Sargent 13:22
Re: Trigger to convert UNIX time to timestamp without time zone. Adrian Klaver 13:35
Re: interpret bytea output as text / double encode() Stefan Froehlich 13:37
Re: Trigger to convert UNIX time to timestamp without time zone. Andrew Sullivan 13:39
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Adrian Klaver 13:44
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Adrian Klaver 13:57
Re: Postgresql service stopped automatically after restart Adrian Klaver 14:16
How to select rows for which column has empty array ? Arup Rakshit 14:30
Re: interpret bytea output as text / double encode() Tom Lane 14:30
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Tom Lane 14:39
Re: interpret bytea output as text / double encode() Stefan Froehlich 14:57
Re: How to select rows for which column has empty array ? David G Johnston 15:12
Problem with locales on Linux with 9.3.4 hubert depesz lubaczewski 16:05
Re: How to select rows for which column has empty array ? Bosco Rama 16:12
Trigger function permissions Keith Fiske 17:13
Re: bytea Issue - Reg Alan Hodgson 18:00
Re: Problem with locales on Linux with 9.3.4 Adrian Klaver 20:04
Re: bytea Issue - Reg Adrian Klaver 20:18
Re: Problem with locales on Linux with 9.3.4 hubert depesz lubaczewski 23:36
Re: Problem with locales on Linux with 9.3.4 Adrian Klaver 23:55

June 7, 2014

Thread Author Time
Re: Problem with locales on Linux with 9.3.4 Adrian Klaver 00:23
Re: Problem with locales on Linux with 9.3.4 hubert depesz lubaczewski 15:17
Re: pg_upgrade from 8.3 to 9.1 and Flag --disable-integer-datetimes Kevin Grittner 16:30
Re: Problem with locales on Linux with 9.3.4 Adrian Klaver 17:07
Re: Problem with locales on Linux with 9.3.4 Adrian Klaver 17:16
Re: Problem with locales on Linux with 9.3.4 hubert depesz lubaczewski 19:43
Re: Problem with locales on Linux with 9.3.4 Adrian Klaver 19:57
Re: Problem with locales on Linux with 9.3.4 hubert depesz lubaczewski 20:06

June 8, 2014

Thread Author Time
Re: Optimizer issue -- bad query plan? Kevin Grittner 14:39
Re: Trigger to convert UNIX time to timestamp without time zone. Kevin Grittner 18:15

June 9, 2014

Thread Author Time
Re: Extended Prefetching using Asynchronous IO - proposal and patch 📎 johnlumby 02:12
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb 📎 Bhushan Pathak 08:53
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Devrim Gündüz 10:04
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Bhushan Pathak 11:02
pg_standby replication problem Khangelani Gama 11:41
Re: pg_standby replication problem Khangelani Gama 11:44
Re: pg_standby replication problem Khangelani Gama 12:23
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Adrian Klaver 14:27
Re: pg_standby replication problem Khangelani Gama 14:28
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Adrian Klaver 14:36
Re: pg_standby replication problem Adrian Klaver 14:41
Re: pg_standby replication problem Alan Hodgson 14:51
Re: pg_standby replication problem Khangelani Gama 15:06
Re: pg_standby replication problem Khangelani Gama 15:25
Re: pg_standby replication problem Khangelani Gama 16:16
Re: Extended Prefetching using Asynchronous IO - proposal and patch Claudio Freire 16:58
pg_standby replication problem Khangelani Gama 18:05
Re: pg_standby replication problem Khangelani Gama 18:15
Re: pg_standby replication problem Alan Hodgson 18:38
Re: pg_standby replication problem Adrian Klaver 23:41

June 10, 2014

Thread Author Time
two questions about fulltext searchign / tsvector indexes Jonathan Vanasco 00:55
Re: pg_standby replication problem Khangelani Gama 05:02
Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb Bhushan Pathak 10:30
Re: two questions about fulltext searchign / tsvector indexes Vick Khera 12:26
Re: two questions about fulltext searchign / tsvector indexes Kevin Grittner 13:23
Re: pg_standby replication problem Adrian Klaver 13:45
How can I tell if pg_restore is running? Moshe Jacobson 14:02
Re: How can I tell if pg_restore is running? Keith Fiske 14:39
Re: How can I tell if pg_restore is running? Martin French 14:51
Re: two questions about fulltext searchign / tsvector indexes Jonathan Vanasco 14:52
Re: How can I tell if pg_restore is running? Francisco Olarte 14:57
Re: pg_standby replication problem Khangelani Gama 16:18
Re: slow query question: more indexes considered harmful Sandeep Gupta 17:25
Warm standby (log shipping) from PG 8.3 to 9.3 David Wall 18:13
Re: Warm standby (log shipping) from PG 8.3 to 9.3 hubert depesz lubaczewski 18:54
Re: Warm standby (log shipping) from PG 8.3 to 9.3 David Wall 20:52
Question about partial functional indexes and the query planner Brian Dunavant 21:29
Re: [GENERAL] Question about partial functional indexes and the query planner Tom Lane 23:19

June 11, 2014

Thread Author Time
Accessing structured datatypes using libpq Raimo Jormakka 06:20
Re: Accessing structured datatypes using libpq John R Pierce 06:44
Re: Accessing structured datatypes using libpq Raimo Jormakka 09:59
eclipse-postgres Ravi Kiran 10:50
Re: Accessing structured datatypes using libpq Michael Paquier 11:02
Re: [HACKERS] Question about partial functional indexes and the query planner Robert Haas 13:39
what does pg_activity mean when the database is stuck? Si Chen 15:59
Re: what does pg_activity mean when the database is stuck? Ciba Sadaf 16:04
Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account boca2608 16:05
Re: what does pg_activity mean when the database is stuck? Jeff Janes 16:29
Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account Raymond O'Donnell 17:55
Re: Accessing structured datatypes using libpq Merlin Moncure 18:08
unknown type name ‘pg_int64’ Steve Crawford 18:14
Re: How can I tell if pg_restore is running? Moshe Jacobson 18:18
max_connections reached in postgres 9.3.3 Vasudevan, Ramya 18:24
Re: unknown type name ‘pg_int64’ Tom Lane 18:35
Re: unknown type name ‘pg_int64’ Steve Crawford 19:29
Re: what does pg_activity mean when the database is stuck? Si Chen 20:33
Re: what does pg_activity mean when the database is stuck? Igor Neyman 20:46
Re: max_connections reached in postgres 9.3.3 Adrian Klaver 21:43
Re: what does pg_activity mean when the database is stuck? Si Chen 22:37
Re: what does pg_activity mean when the database is stuck? Merlin Moncure 22:41
Re: How can I tell if pg_restore is running? Keith 22:51
Re: max_connections reached in postgres 9.3.3 Merlin Moncure 23:23
Re: [GENERAL] Question about partial functional indexes and the query planner 📎 Tom Lane 23:24

June 12, 2014

Thread Author Time
Re: what does pg_activity mean when the database is stuck? Si Chen 02:44
OpenSSL Vulnerabilities Saravanan Subramaniyan 06:43
Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml Khangelani Gama 08:23
Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml John R Pierce 08:34
Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml Khangelani Gama 08:44
Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml Craig Ringer 08:59
Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml Ian Barwick 09:04
Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml Khangelani Gama 09:06
Re: Shared memory changes in 9.4? Christoph Berg 09:07
Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml Ian Barwick 09:13
Re: what does pg_activity mean when the database is stuck? Michael Paquier 09:34
Re: what does pg_activity mean when the database is stuck? Michael Paquier 09:36
Re: Shared memory changes in 9.4? Andres Freund 09:41
Re: Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml Khangelani Gama 10:00
Re: what does pg_activity mean when the database is stuck? Igor Neyman 13:35
Re: Shared memory changes in 9.4? 📎 Christoph Berg 13:39

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30