pgsql-general since 2012-08-19 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)

Advanced Search

Browse Archives

Prev | Next

Aug. 19, 2012

Thread	Author	Time
Re: Schemas vs partitioning vs multiple databases for archiving	Gavin Flower	04:30
Re: Messy data models (Re: Visualize database schema)	Gavin Flower	05:08
Re: Schemas vs partitioning vs multiple databases for archiving	Chris Travers	05:50
Re: Schemas vs partitioning vs multiple databases for archiving	Gavin Flower	06:04
Re: Views versus user-defined functions: formatting, comments, performance, etc.	Dmitriy Igrishin	13:14
importing updated files into a database	fashouri	14:49
xml performance	Raju Angani	20:48
Re: Ignore hash indices on replicas	Jeff Davis	21:37

Aug. 20, 2012

Thread	Author	Time
How hard would a "path" operator be to implement in PostgreSQL	Chris Travers	01:28
Re: How hard would a "path" operator be to implement in PostgreSQL	Ondrej Ivanič	02:25
citext: citext=text is case sensitive	Craig Ringer	03:01
Re: Ignore hash indices on replicas	Scott Marlowe	03:01
Re: How hard would a "path" operator be to implement in PostgreSQL	David Johnston	03:13
Re: How hard would a "path" operator be to implement in PostgreSQL	Craig Ringer	03:50
Re: How hard would a "path" operator be to implement in PostgreSQL	Chris Travers	03:52
Different results from view and from its defintion query [w/ windowing function]	Thalis Kalfigkopoulos	04:55
Re: importing updated files into a database	Craig Ringer	05:50
Re: Some feedback on range types	Jeff Davis	07:16
Re: Visualize database schema	Johann Spies	08:04
function depend on view	salah jubeh	12:14
Re: function depend on view	Andreas Kretschmer	12:47
Re: Views versus user-defined functions: formatting, comments, performance, etc.	Merlin Moncure	14:06
Re: Different results from view and from its defintion query [w/ windowing function]	Achilleas Mantzios	14:34
Re: function depend on view	salah jubeh	14:37
Re: function depend on view	Merlin Moncure	14:57
Re: function depend on view	Andreas Kretschmer	14:59
Re: function depend on view	Merlin Moncure	15:12
Re: Different results from view and from its defintion query [w/ windowing function]	Tom Lane	15:16
Re: Different results from view and from its defintion query [w/ windowing function]	Thalis Kalfigkopoulos	16:33
Re: Best practice non privilege postgres-user	Frank Lanitz	16:45
postmaster.pid file auto-clean up?	Sebastien Boisvert	16:52
Re: Ignore hash indices on replicas	Steven Schlansker	17:26
Re: Ignore hash indices on replicas	Steven Schlansker	17:29
Re: postmaster.pid file auto-clean up?	Tom Lane	17:31
Database Bloat	elliott	17:53
Re: Ignore hash indices on replicas	Jeff Janes	17:55
Re: Database Bloat	David Johnston	18:09
Re: Database Bloat	John R Pierce	18:10
Grant problem and how to prevent users to execute OS commands?	Evil	18:34
Re: Database Bloat	elliott	18:46
Re: How hard would a "path" operator be to implement in PostgreSQL	Martijn van Oosterhout	19:06
Re: Database Bloat	John R Pierce	19:33
.Net/C# - How to use Entity Framework Code First with Npgsql?	Hermano Cabral	19:59
Re: Database Bloat	Merlin Moncure	22:16

Aug. 21, 2012

Thread	Author	Time
Re: How hard would a "path" operator be to implement in PostgreSQL	Craig Ringer	01:39
Re: postmaster.pid file auto-clean up?	Sebastien Boisvert	03:03
Re: postmaster.pid file auto-clean up?	Tom Lane	03:30
Amazon High I/O instances	Sébastien Lorion	05:33
Re: Grant problem and how to prevent users to execute OS commands?	Craig Ringer	06:23
Re: Grant problem and how to prevent users to execute OS commands?	Thom Brown	06:24
Estimated rows question	Sam Ross	06:27
Re: How hard would a "path" operator be to implement in PostgreSQL	Martijn van Oosterhout	07:01
Re: How hard would a "path" operator be to implement in PostgreSQL	Craig Ringer	07:56
Re: Amazon High I/O instances	Vincent Veyron	08:12
Re: Amazon High I/O instances	Vincent Veyron	08:18
Are there any options to parallelize queries?	Seref Arikan	08:45
Re: Are there any options to parallelize queries?	Pavel Stehule	09:20
How to copy Datum	Wang, Chaoyong	10:49
Re: .Net/C# - How to use Entity Framework Code First with Npgsql?	Albe Laurenz	12:31
Re: Amazon High I/O instances	Oliver Kohll - Mailing Lists	13:10
Re: Amazon High I/O instances	David Boreham	13:30
Re: Amazon High I/O instances	David Boreham	13:40
Re: Amazon High I/O instances	Merlin Moncure	14:36
Re: Amazon High I/O instances	Vincent Veyron	17:16
Re: Amazon High I/O instances	Sébastien Lorion	18:25
redundant fields in table for "performance optimizations"	Menelaos PerdikeasSemantix	21:07
Re: redundant fields in table for "performance optimizations"	Darren Duncan	21:17
Problems with timestamp with time zone and old dates?	Michael Clark	21:29
Re: Problems with timestamp with time zone and old dates?	Steve Crawford	21:50
Re: redundant fields in table for "performance optimizations"	Ondrej Ivanič	22:51

Aug. 22, 2012

Thread	Author	Time
Re: Problems with timestamp with time zone and old dates?	Michael Clark	03:09
Re: Are there any options to parallelize queries?	Craig Ringer	03:24
Re: Problems with timestamp with time zone and old dates?	Scott Marlowe	04:08
Re: Problems with timestamp with time zone and old dates?	Scott Marlowe	04:12
[No subject]	Wells Oliver	04:16
Re: Problems with timestamp with time zone and old dates?	Scott Marlowe	04:19
Performance implications of numeric?	Wells Oliver	04:27
Re: Grant problem and how to prevent users to execute OS commands?	Craig Ringer	04:33
Re: Performance implications of numeric?	Craig Ringer	04:47
Re: Amazon High I/O instances	Craig Ringer	05:15
Understanding autocommit	Chris Angelico	08:33
Re: Understanding autocommit	Albe Laurenz	08:52
Re: Problems with timestamp with time zone and old dates?	hubert depesz lubaczewski	09:00
Re: How hard would a "path" operator be to implement in PostgreSQL	Chris Travers	10:00
Re: Are there any options to parallelize queries?	Seref Arikan	10:03
Re: Are there any options to parallelize queries?	Chris Travers	10:21
NULL value comparison	Michael Sacket	13:23
Re: NULL value comparison	Pavel Stehule	13:28
Re: NULL value comparison	Adrian Klaver	13:30
Re: NULL value comparison	David Johnston	13:37
Re: NULL value comparison	Thalis Kalfigkopoulos	13:43
Re: NULL value comparison	Michael Sacket	14:58
Re: Amazon High I/O instances	Vincent Veyron	16:44
Re: Database Bloat	Jerry Sievers	16:58
Re: Database Bloat	Jeff Janes	17:20
Re: Database Bloat	elliott	17:25
Re: Amazon High I/O instances	Sébastien Lorion	17:30
Re: Database Bloat	Merlin Moncure	18:16
Re: Amazon High I/O instances	Andrew Hannon	20:10
Statistical aggregates with intervals	Thomas Munro	20:25
Re: Database Bloat	John R Pierce	20:31
Re: Amazon High I/O instances	Alan Hodgson	21:12
Migrating from 8.3 to 9.1 - date/time storage types do not match	Scott Briggs	21:17
Re: Migrating from 8.3 to 9.1 - date/time storage types do not match	John R Pierce	21:27
Re: Migrating from 8.3 to 9.1 - date/time storage types do not match	Alan Hodgson	21:43
Can column name aliases be supported?	Gauthier, Dave	22:19
Re: Can column name aliases be supported?	Bosco Rama	22:34
Re: Can column name aliases be supported?	Rob Sargent	22:35
Re: Can column name aliases be supported?	Bosco Rama	22:41
At what point does a big table start becoming too big?	Nick	23:06
Re: Database Bloat	David Johnston	23:30
Re: Migrating from 8.3 to 9.1 - date/time storage types do not match	Alan Hodgson	23:55

Aug. 23, 2012

Thread	Author	Time
What text format is this and can I import it into Postgres?	Mike Christensen	00:23
Re: Performance implications of numeric?	Craig Ringer	00:28
Re: What text format is this and can I import it into Postgres?	Edson Richter	00:33
Re: What text format is this and can I import it into Postgres?	Rob Sargent	00:33
Re: What text format is this and can I import it into Postgres?	Bosco Rama	00:34
Re: What text format is this and can I import it into Postgres?	Rob Sargent	00:35
Re: What text format is this and can I import it into Postgres?	Mike Christensen	00:38
Re: What text format is this and can I import it into Postgres?	David Johnston	00:40
Re: What text format is this and can I import it into Postgres?	Mike Christensen	00:41
Re: Alternatives to very large tables with many performance-killing indicies?	Jeff Janes	00:56
Re: What text format is this and can I import it into Postgres?	John R Pierce	00:57
Re: What text format is this and can I import it into Postgres?	John R Pierce	00:58
Re: What text format is this and can I import it into Postgres?	Bosco Rama	00:58
Re: NULL value comparison	Craig Ringer	01:13
Re: NULL value comparison	Craig Ringer	01:17
no null checking/check constraint checking in nested tables: Bug, missing feature, or desired behavior?	Chris Travers	01:42
Re: Can column name aliases be supported?	Craig Ringer	02:04
Re: What text format is this and can I import it into Postgres?	Mike Christensen	02:17
Re: NULL value comparison	Michael Sacket	02:32
Re: NULL value comparison	Craig Ringer	02:38
Re: What text format is this and can I import it into Postgres?	Adrian Klaver	02:44
Re: What text format is this and can I import it into Postgres?	John R Pierce	03:01
Re: Alternatives to very large tables with many performance-killing indicies?	Scott Marlowe	03:16
Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)	Chris Travers	03:22
Re: Can column name aliases be supported?	Chris Angelico	03:56
Re: What text format is this and can I import it into Postgres?	Mike Christensen	04:13
Re: Can column name aliases be supported?	Craig Ringer	04:19
Re: Can column name aliases be supported?	Chris Angelico	05:23
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)	David Johnston	05:36
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)	Thomas Kellerer	06:15
Re: What text format is this and can I import it into Postgres?	Thomas Kellerer	06:22
Re: At what point does a big table start becoming too big?	Gavin Flower	07:04
Re: Alternatives to very large tables with many performance-killing indicies?	Martijn van Oosterhout	07:09
Re: At what point does a big table start becoming too big? 📎	Martin French	07:22
Result from Having count	Condor	07:52
Re: Result from Having count	Frank Lanitz	08:11
Re: Result from Having count	Condor	08:45
Re: Result from Having count	Frank Lanitz	08:54
Re: At what point does a big table start becoming too big?	Chris Travers	09:13
Rules, Windows and ORDER BY	Jason Dusek	11:37
Re: Amazon High I/O instances	Vincent Veyron	11:39
Re: At what point does a big table start becoming too big?	Jasen Betts	11:55
Re: Amazon High I/O instances	Anthony	12:00
Re: Can column name aliases be supported?	Gauthier, Dave	13:32
Re: At what point does a big table start becoming too big?	Bill Moran	13:37
Re: Amazon High I/O instances	Sébastien Lorion	13:45
Re: At what point does a big table start becoming too big?	Merlin Moncure	13:46
Re: Amazon High I/O instances	Craig Ringer	13:49
Re: Check PostgreSQL status using MS-DOS bat file?	Loughrey, Hugh	13:50
Re: Rules, Windows and ORDER BY	Tom Lane	13:51
Re: At what point does a big table start becoming too big? 📎	Martin French	13:51
Re: Can column name aliases be supported?	Craig Ringer	13:52
Re: At what point does a big table start becoming too big?	Chris Travers	14:09
Re: At what point does a big table start becoming too big?	Tom Lane	14:18
Re: Can column name aliases be supported?	Gauthier, Dave	14:19
Cannot Run EnterpriseDB Postgresql Installation	javad M	14:31
Re: NULL value comparison	Michael Sacket	14:49
Re: Performance implications of numeric?	Merlin Moncure	15:17
Re: Amazon High I/O instances	Merlin Moncure	15:37
Re: Cannot Run EnterpriseDB Postgresql Installation	Sachin Srivastava	15:40
Re: Amazon High I/O instances	John R Pierce	15:51
Should I drop / create extensions after upgraging?	François Beausoleil	16:19
Re: Should I drop / create extensions after upgraging?	Tomas Vondra	17:03
Re: Should I drop / create extensions after upgraging?	Tom Lane	17:36
Re: Cannot Run EnterpriseDB Postgresql Installation	javad M	18:10
Confirming \timing output	Gauthier, Dave	18:13
Re: Amazon High I/O instances	Sébastien Lorion	18:24
Re: Confirming \timing output	Steven Schlansker	18:27
Re: Confirming \timing output	John R Pierce	18:30
Re: Amazon High I/O instances	John R Pierce	18:41
Windows SIngle Sign On - LINUX Server	Jeremy Palmer	19:12
Re: How hard would a "path" operator be to implement in PostgreSQL	Merlin Moncure	19:20
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)	Merlin Moncure	19:36
Re: Problems with timestamp with time zone and old dates?	Michael Clark	19:41
Re: Problems with timestamp with time zone and old dates?	Michael Clark	19:42
need substring based on delimiter	Gauthier, Dave	21:30
Re: Statistical aggregates with intervals	Christopher Swingley	21:39
Re: need substring based on delimiter	Joe Conway	21:58
Re: Statistical aggregates with intervals	Ondrej Ivanič	22:43

Aug. 24, 2012

Thread	Author	Time
Re: At what point does a big table start becoming too big?	Jeff Janes	00:16
Re: At what point does a big table start becoming too big?	Jeff Janes	00:56
FETCH in subqueries or CTEs	Craig Ringer	01:35
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)	Chris Travers	01:44
Re: FETCH in subqueries or CTEs	Jeff Davis	02:00
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)	Chris Travers	02:04
Re: Can column name aliases be supported?	Craig Ringer	02:12
Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)	Ondrej Ivanič	02:17
Postgresql 9.1 on VMWare ESXi 5.0	Edson Richter	02:18

Browse Archives

Prev | Next