pgsql-general since 2012-07-06 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

July 6, 2012

Thread Author Time
Issue with extension updates to pg_extension table Keith Fiske 00:07
Re: The need for clustered indexes to boost TPC-V performance Andy Colson 00:41
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 00:46
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 00:57
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 01:00
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 01:04
Re: Suboptimal query plan fixed by replacing OR with UNION Jasen Betts 01:35
Re: The need for clustered indexes to boost TPC-V performance Greg Smith 01:42
Re: [PERFORM] The need for clustered indexes to boost TPC-V performance Craig Ringer 03:02
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 03:08
build model from existing db ssylla 03:13
Draw Model from existing DB ssylla 03:28
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 03:33
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 04:19
Re: build model from existing db Craig Ringer 04:36
Re: Draw Model from existing DB Robert Gravsjö 07:04
Dynamic query execution using array ChoonSoo Park 14:02
Re: Dynamic query execution using array Pavel Stehule 15:45
Re: Primary key vs unique index rverghese 16:07
Re: Dynamic query execution using array ChoonSoo Park 16:21
Re: Dynamic query execution using array Pavel Stehule 16:40
Re: Dynamic query execution using array Pavel Stehule 16:41
Re: Primary key vs unique index hubert depesz lubaczewski 17:01
index and data tablespaces on two separate drives or one RAID 0? ach 17:05
Re: Primary key vs unique index Gurjeet Singh 17:54
Re: Primary key vs unique index rverghese 18:07
Re: index and data tablespaces on two separate drives or one RAID 0? John R Pierce 18:11
BUG? Regular expression matching of optional character group at beginning of RE Viktor Rosenfeld 18:49
Query runtime strongly dependent on generated statistics (and fewer statistics are better?) Viktor Rosenfeld 18:53
Tutorial On Connecting LibreOffice to PostgreSQL Available Don Parris 19:13
Re: Primary key vs unique index Gurjeet Singh 19:25
Weird "LIKE" behaviour Andy Chambers 20:16
Re: Weird "LIKE" behaviour David Johnston 20:26
Re: Weird "LIKE" behaviour Andy Chambers 20:34
Re: Weird "LIKE" behaviour David Johnston 20:50
Help with sql Perry Smith 21:34
Re: Suboptimal query plan fixed by replacing OR with UNION Steven Schlansker 23:25

July 7, 2012

Thread Author Time
Re: Help with sql Rob Sargent 00:43
Re: index and data tablespaces on two separate drives or one RAID 0? ach 00:51
Re: Help with sql Steve Crawford 00:56
Re: Re: index and data tablespaces on two separate drives or one RAID 0? John R Pierce 01:03
two-column primary key (not the typical question) Chip Nowacek 02:00
Re: two-column primary key (not the typical question) Chris Travers 02:09
Re: two-column primary key (not the typical question) Gurjeet Singh 02:17
Re: Suboptimal query plan fixed by replacing OR with UNION Gurjeet Singh 04:24
Re: Re: index and data tablespaces on two separate drives or one RAID 0? Joe Miller 13:15
Re: Help with sql Perry Smith 13:48
Re: Help with sql Chris Angelico 14:39
Re: BUG? Regular expression matching of optional character group at beginning of RE Tom Lane 16:09

July 8, 2012

Thread Author Time
recover as much as possible (xlog flush request not satisfied) Wim Goedertier 10:59
Re: recover as much as possible (xlog flush request not satisfied) Tom Lane 16:06

July 9, 2012

Thread Author Time
Re: recover as much as possible (xlog flush request not satisfied) Wim Goedertier 13:02
Re: recover as much as possible (xlog flush request not satisfied) Tom Lane 14:07
Re: Suboptimal query plan fixed by replacing OR with UNION Steven Schlansker 17:35
Re: Tutorial On Connecting LibreOffice to PostgreSQL Available Willy-Bas Loos 22:04
Finding Duplicate Rows during INSERTs Rich Shepard 22:48

July 10, 2012

Thread Author Time
Re: Finding Duplicate Rows during INSERTs Rob Sargent 00:01
Re: Tutorial On Connecting LibreOffice to PostgreSQL Available Don Parris 00:20
Re: Finding Duplicate Rows during INSERTs Rich Shepard 01:03
Re: Finding Duplicate Rows during INSERTs Darren Duncan 02:54
Re: ERROR: function crosstab(unknown, unknown) does not exist Stefan Schwarzer 05:31
Ignore hash indices on replicas Steven Schlansker 07:09
PL/Python error fetching next item from iterator tuanhoanganh 07:27
Pg CRUD for joined tables gvim 14:10
Re: C-Functions using SPI - Missing Magic Block eugeniotapias 15:54
Re: The need for clustered indexes to boost TPC-V performance Merlin Moncure 19:05
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 19:35
Transaction question Jeff Ross 20:06
Error with plpython Efraín Déctor 21:59
Re: BUG? Regular expression matching of optional character group at beginning of RE Tom Lane 22:03
Error with plpython Efraín Déctor 22:16
Sequence moves forward when failover is triggerred Andy Chambers 22:17
Re: Do I need archive_mode = on for hot standby? Andy Chambers 22:26
Re: Sequence moves forward when failover is triggerred Tom Lane 22:48
Python + listen/notify Filipe Brandão 22:56
Re: Sequence moves forward when failover is triggerred Andy Chambers 23:23

July 11, 2012

Thread Author Time
Re: Transaction question Adrian Klaver 00:21
Re: Error with plpython Adrian Klaver 00:24
Re: Error with plpython Efraín Déctor 00:34
Re: Error with plpython Adrian Klaver 01:57
Re: Transaction question Jeff Ross 02:30
Re: Transaction question Adrian Klaver 02:39
Re: Python + listen/notify Josh Kupershmidt 03:20
Re: Error with plpython Craig Ringer 03:43
Re: Sequence moves forward when failover is triggerred Craig Ringer 03:47
Re: Sequence moves forward when failover is triggerred Berend Tober 05:01
Bug? Prepared queries continue to use search_path from their preparation time Toby Corkindale 07:43
foreign keys with constant part Marc Mamin 10:41
Fulltext Search Function Jeremaine Johnson 11:20
question about installation martin soethof 12:58
Key not present in table, but it is. Emanuel Calvo 13:20
Re: Error with plpython Efraín Déctor 13:32
Re: Transaction question Jeff Ross 14:01
Re: Bug? Prepared queries continue to use search_path from their preparation time Tom Lane 14:07
Re: Bug? Prepared queries continue to use search_path from their preparation time Jerry Sievers 14:34
Re: Bug? Prepared queries continue to use search_path from their preparation time Jerry Sievers 14:34
installation problem with postgres password KOTa 14:47
Please Post Gregorio, Albert 15:13
Fulltext Search Function Jeremaine Johnson 15:17
Re: Python + listen/notify Josh Kupershmidt 15:27
Re: Key not present in table, but it is. Tom Lane 15:35
Re: Key not present in table, but it is. Emanuel Calvo 16:07
Re: question about installation Raymond O'Donnell 19:46
Re: installation problem with postgres password Raymond O'Donnell 19:48
Re: Error with plpython Adrian Klaver 20:01
Re: Transaction question Adrian Klaver 20:07
Re: Transaction question Adrian Klaver 20:15
Re: Sequence moves forward when failover is triggerred Steve Crawford 20:17
PostgreSQL limitations question Bartosz Dmytrak 21:01
Re: Transaction question Jeff Ross 21:41
Re: Transaction question Adrian Klaver 21:52
Re: Transaction question Marcin Mańk 22:24
Re: Transaction question Jeff Ross 23:02
Re: Transaction question Jeff Ross 23:10
Re: Transaction question Adrian Klaver 23:13
Re: Error with plpython Efraín Déctor 23:17
Re: Transaction question Jeff Ross 23:18
Re: Transaction question Adrian Klaver 23:46
Re: Error with plpython Adrian Klaver 23:56

July 12, 2012

Thread Author Time
Re: question about installation Craig Ringer 00:27
Re: Sequence moves forward when failover is triggerred Craig Ringer 00:42
Re: PostgreSQL limitations question Craig Ringer 01:07
Re: Bug? Prepared queries continue to use search_path from their preparation time Toby Corkindale 01:18
Re: Timeline error on streaming replica (WAS: "Please post") Craig Ringer 02:01
Re: Error with plpython Craig Ringer 02:05
PostgreSQL index issue mperformer 02:06
Re: installation problem with postgres password KOTa 03:05
Re: installation problem with postgres password raghu ram 05:02
Re: installation problem with postgres password KOTa 05:34
Re: PostgreSQL limitations question Bartosz Dmytrak 06:16
Re: PostgreSQL index issue Albe Laurenz 07:18
Re: PostgreSQL limitations question Craig Ringer 07:39
Re: Python + listen/notify Filipe brandão 10:28
Full text search advice requested Johann Spies 10:42
Re: question about installation Sachin Srivastava 11:45
[No subject] [email protected] 12:36
Re: PostgreSQL limitations question Adrian Klaver 13:31
Re: Pg CRUD for joined tables Wolfgang Keller 13:35
Re: PostgreSQL limitations question Tom Lane 13:44
Re: PostgreSQL limitations question Adrian Klaver 13:53
Re: PostgreSQL limitations question David Johnston 14:22
ERROR: out of shared memory - But the table is empty Stefan Schwarzer 14:53
Re: Bug? Prepared queries continue to use search_path from their preparation time Greg Sabino Mullane 16:59
Re: Query to find sum of grouped counts from 2 tables arafatix 18:14
Re: PostgreSQL limitations question Bartosz Dmytrak 18:14
how much volatile is a function Anibal David Acosta 18:38
Re: how much volatile is a function David Johnston 18:48
Re: how much volatile is a function Sergey Konoplev 18:55
Re: how much volatile is a function Sergey Konoplev 19:00
Re: Output of query_to_xml Peter Eisentraut 20:51
Re: PostgreSQL index issue codevally 22:06
Re: PostgreSQL index issue Craig Ringer 23:57

July 13, 2012

Thread Author Time
Re: Bug? Prepared queries continue to use search_path from their preparation time Toby Corkindale 01:46
Re: ERROR: out of shared memory - But the table is empty raghu ram 05:23
hstore for audit logging: Finding differences between two hstore values Craig Ringer 05:51
Re: hstore for audit logging: Finding differences between two hstore values Sergey Konoplev 06:15
Re: installation problem with postgres password Sachin Srivastava 06:44
Re: PostgreSQL limitations question Chris Angelico 07:05
Re: installation problem with postgres password KOTa 07:56
Re: hstore for audit logging: Finding differences between two hstore values Craig Ringer 08:18
WITH RECURSIVE question Marc Mamin 10:20
Is postgresql 9.1.* supporting plpython with python 2.* Leger Bertrand 10:23
Re: WITH RECURSIVE question Andreas Kretschmer 10:47
Re: WITH RECURSIVE question hubert depesz lubaczewski 10:51
Re: WITH RECURSIVE question Marc Mamin 11:08
Re: ERROR: out of shared memory - But the table is empty Stefan Schwarzer 12:07
Re: WITH RECURSIVE question Chris Travers 12:57
Re: PostgreSQL limitations question Mike Christensen 16:40
Re: PostgreSQL limitations question Chris Angelico 16:48
great infoworld article on postgresql/enterprisedb Merlin Moncure 18:42
multiple SAVEPOINTs without RELEASE SAVEPOINT fearless_fool 21:05

July 14, 2012

Thread Author Time
Help me follow... Perry Smith 15:57
Re: Help me follow... Peter Geoghegan 16:55
Re: Help me follow... Tom Lane 17:56
Re: Help me follow... Peter Geoghegan 19:19
Re: Help me follow... Perry Smith 22:30

July 15, 2012

Thread Author Time
Re: Is postgresql 9.1.* supporting plpython with python 2.* Adrian Klaver 00:03
Can't figure out how to use now() in default for tsrange column (PG 9.2) Chris Bartlett 10:25
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) Tom Lane 15:19
Re: PostgreSQL limitations question Bartosz Dmytrak 18:54

July 16, 2012

Thread Author Time
How to obtain calling role within a SECURITY DEFINER function Craig Ringer 05:46
Replication/cloning: rsync vs modification dates? Chris Angelico 08:28
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) Chris Bartlett 10:41
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) Alban Hertroys 11:41
Replication terminated by primary server Nicolau Roca 11:52
DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error. Olga Vingurt 12:14
Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error. raghu ram 13:55
Create stored procedure from C#.net postgresuser 14:04
Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error. Raghavendra 14:04
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) Craig Ringer 14:56
Re: DB fails to start: "Could not read from file "pg_clog/0003" at offset 212992: No error. Craig Ringer 15:09
Re: Replication/cloning: rsync vs modification dates? Michael Nolan 15:40
Re: Replication/cloning: rsync vs modification dates? Chris Angelico 15:45
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) Daniele Varrazzo 15:57
Re: Replication/cloning: rsync vs modification dates? Michael Nolan 15:58
Re: Replication/cloning: rsync vs modification dates? Chris Angelico 16:01
Re: Create stored procedure from C#.net Pavel Stehule 16:50
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) Alban Hertroys 17:44
Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) David Johnston 18:08
Re: Replication/cloning: rsync vs modification dates? Sergey Konoplev 18:35

Browse Archives

Prev | Next