pgsql-general - February 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)
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 28

Feb. 1, 2011

Thread Author Time
Re: Almost full pg_xlog/ Tom Lane 00:14
Issues with generate_series using integer boundaries Thom Brown 00:15
Re: Almost full pg_xlog/ Jeff Ross 00:28
Re: Almost full pg_xlog/ Adrian Klaver 00:30
Re: Issues with generate_series using integer boundaries Thom Brown 00:33
Re: Issues with generate_series using integer boundaries Tom Lane 00:36
Re: Issues with generate_series using integer boundaries Thom Brown 00:41
Re: Issues with generate_series using integer boundaries Thom Brown 00:48
Why does my DB size differ between Production and DR? (Postgres 8.4) Aleksey Tsalolikhin 00:54
Re: Issues with generate_series using integer boundaries Tom Lane 01:05
Re: Issues with generate_series using integer boundaries Thom Brown 02:17
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Scott Marlowe 03:52
Re: Automatic database monitoring tool for PostgreSQL ... new project Joshua Tolley 05:40
cast problem in Postgresql 9.0.1 AI Rumman 06:14
Serial Vs Sequence Adarsh Sharma 06:55
Re: Serial Vs Sequence John R Pierce 07:08
Re: Serial Vs Sequence Pavel Stehule 07:13
Re: Weird performance issue with custom function with a for loop. Nicos Panayides 10:09
Select for update with offset interferes with concurrent transactions Yngve Nysaeter Pettersen 12:32
Re: cast problem in Postgresql 9.0.1 Adrian Klaver 14:57
Cluster table and order information Dario Beraldi 15:08
Re: Select for update with offset interferes with concurrent transactions Andy Colson 15:19
Problem with encode () and hmac() in pgcrypto hlcborg 15:36
Using the copy protocol, is there a way to be notified of a potential error before sending? Nicolas Grilly 15:52
Book recommendation? Herouth Maoz 15:56
Re: Cluster table and order information Andy Colson 15:59
Re: Book recommendation? tv 16:04
Re: Book recommendation? Jeff Ross 16:14
Re: PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic" bricklen 16:16
Re: Cluster table and order information Dario Beraldi 16:17
Re: Cluster table and order information Andy Colson 16:22
Re: Weird performance issue with custom function with a for loop. Tom Lane 16:52
Re: Select for update with offset interferes with concurrent transactions Yngve Nysaeter Pettersen 16:59
Re: Book recommendation? Vick Khera 17:06
Re: Select for update with offset interferes with concurrent transactions Andy Colson 17:11
Re: Select for update with offset interferes with concurrent transactions Tom Lane 17:18
Re: Book recommendation? Chris Browne 17:31
Re: Select for update with offset interferes with concurrent transactions Yngve Nysaeter Pettersen 18:10
Re: Select for update with offset interferes with concurrent transactions Yngve Nysaeter Pettersen 18:10
Re: Select for update with offset interferes with concurrent transactions Andy Colson 18:29
Re: Weird performance issue with custom function with a for loop. Nicos Panayides 18:50
Re: Select for update with offset interferes with concurrent transactions Yngve Nysaeter Pettersen 18:51
Re: Select for update with offset interferes with concurrent transactions Andy Colson 19:04
Re: Select for update with offset interferes with concurrent transactions Radosław Smogura 19:05
Re: Some Problems - Shall I reinstall the DB? vwu98034 20:03
Re: Select for update with offset interferes with concurrent transactions Yngve Nysaeter Pettersen 20:05
Re: Book recommendation? Scott Marlowe 20:05
yum repo problem John R Pierce 20:07
Re: Text search parser's treatment of URLs and emails Bruce Momjian 20:14
Re: Book recommendation? Greg Smith 20:15
Re: [GENERAL] Binary Replication and Slony 📎 Bruce Momjian 20:21
Re: yum repo problem John R Pierce 20:25
Re: Issues with generate_series using integer boundaries Thom Brown 20:26
Re: Some Problems - Shall I reinstall the DB? Adrian Klaver 21:05
Re: Problem with encode () and hmac() in pgcrypto Marko Kreen 21:08
Re: cast problem in Postgresql 9.0.1 Alban Hertroys 21:12
Re: Some Problems - Shall I reinstall the DB? Tom Lane 21:14
Re: cast problem in Postgresql 9.0.1 Joshua D. Drake 21:22
troubleshooting Postgresql on Windows Heine Ferreira 21:24
Re: Book recommendation? Alban Hertroys 21:30
Re: cast problem in Postgresql 9.0.1 Tom Lane 21:31
Re: Issues with generate_series using integer boundaries Alban Hertroys 21:32
Re: zero_damaged_pages doesn't work 📎 Bruce Momjian 21:44
Windows to Linux PostgreSQL Migration David Johnston 21:44
Re: Windows to Linux PostgreSQL Migration Andy Colson 21:59
Re: Windows to Linux PostgreSQL Migration David Johnston 22:04
Re: Documentation enhancement 📎 Bruce Momjian 22:18
Re: Issues with generate_series using integer boundaries Thom Brown 23:08
Re: Problem with encode () and hmac() in pgcrypto hlcborg 23:19
postgresql 9 on windows 2000 geek.shrek 23:45

Feb. 2, 2011

Thread Author Time
Re: yum repo problem Devrim GÜNDÜZ 00:09
Importing/Appending to Existing Table Rich Shepard 00:28
Re: Select for update with offset interferes with concurrent transactions David Johnston 00:36
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Aleksey Tsalolikhin 02:29
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Peter Geoghegan 03:13
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Scott Marlowe 05:41
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Scott Marlowe 05:42
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Scott Marlowe 05:43
Tablespaces Issue in Postgres Adarsh Sharma 06:33
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Greg Sabino Mullane 07:07
Re: Importing/Appending to Existing Table Sergey Konoplev 07:12
Installation Issue of PostgresPlus-9.0 Adarsh Sharma 09:23
Re: Problem with encode () and hmac() in pgcrypto Marko Kreen 09:52
Re: Importing/Appending to Existing Table Greg Williamson 09:56
Re: Installation Issue of PostgresPlus-9.0 Adarsh Sharma 09:59
Hot-Standby and sequences Wouter D'Haeseleer 10:32
Hot-Standby and sequences Wouter D'Haeseleer 11:03
Query plan optimization: sorting vs. partitioning Sergey Zaharchenko 11:49
Re: Installation Issue of PostgresPlus-9.0 Sachin Srivastava 12:09
Re: Select for update with offset interferes with concurrent transactions Yngve N. Pettersen (Developer Opera Software ASA) 12:32
Changing SHMMAX Adarsh Sharma 13:33
Re: Changing SHMMAX Florian Weimer 13:42
Privileges for read-only tables with sequence and foreign keys gvim 13:44
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Bill Moran 13:46
Re: Importing/Appending to Existing Table Rich Shepard 14:26
Re: Importing/Appending to Existing Table Rich Shepard 14:29
redirecting query statement and output to a marked up file, using psql Wim Bertels 14:41
Re: Importing/Appending to Existing Table David Johnston 14:41
Re: "could not accept SSPI security context" Ahmed 14:52
Re: Query plan optimization: sorting vs. partitioning Tom Lane 15:06
Re: Hot-Standby and sequences Tom Lane 15:13
Re: Query plan optimization: sorting vs. partitioning Sergey Zaharchenko 15:30
Re: Changing SHMMAX Torsten Zühlsdorff 15:31
Re: Hot-Standby and sequences Wouter D'Haeseleer 15:47
Streaming Rep 101 questions Gauthier, Dave 15:52
Re: Streaming Rep 101 questions Ray Stell 16:07
Re: "could not accept SSPI security context" Francisco Figueiredo Jr. 16:11
Re: Streaming Rep 101 questions Magnus Hagander 16:17
Re: Streaming Rep 101 questions Adrian Klaver 16:24
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Chris Browne 17:40
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Chris Browne 17:45
Why "copy ... from stdio" does not return immediately when reading invalid data? Nicolas Grilly 18:20
Database Design Question Carlos Mennens 18:32
Re: Why "copy ... from stdio" does not return immediately when reading invalid data? John R Pierce 19:06
upgrade William Bruton 19:08
Re: Database Design Question John R Pierce 19:08
Re: Database Design Question Chris Browne 19:14
Re: Database Design Question David Johnston 19:24
Re: Database Design Question Joshua D. Drake 19:24
Re: Database Design Question John R Pierce 19:44
Re: Database Design Question Gary Chambers 19:57
Re: Database Design Question Martijn van Oosterhout 19:59
Re: Changing SHMMAX Vick Khera 20:16
Why does a normally fast query run so slow when the table is in a partition? Bill Thoen 20:17
Re: How best to load modules? Steve White 20:37
SCALE: seeking booth attendees Richard Broersma 20:39
Re: redirecting query statement and output to a marked up file, using psql Bosco Rama 20:49
Re: Why does a normally fast query run so slow when the table is in a partition? Steve Crawford 21:08
effective_io_concurrency Yves Weißig 21:16
Re: Why does a normally fast query run so slow when the table is in a partition? Steve Crawford 22:10
set theory question matty jones 22:58
PQfinish blocking on non-existent IP address ... Mad 23:02

Feb. 3, 2011

Thread Author Time
isn't "insert into where not exists" atomic? Mage 01:17
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Aleksey Tsalolikhin 02:03
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Scott Marlowe 03:04
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Peter Geoghegan 03:49
Re: PQfinish blocking on non-existent IP address ... Mad 03:55
Re: Why does my DB size differ between Production and DR? (Postgres 8.4) Scott Marlowe 05:34
Re: upgrade Scott Marlowe 06:43
Re: isn't "insert into where not exists" atomic? Alban Hertroys 07:13
Select Command in Procedures Adarsh Sharma 08:56
Encoding Conversion Wilton Wonrath 11:03
Re: Select Command in Procedures hubert depesz lubaczewski 11:23
Re: Issues with generate_series using integer boundaries 📎 Thom Brown 11:31
Re: Issues with generate_series using integer boundaries 📎 Thom Brown 11:34
Re: Problem with encode () and hmac() in pgcrypto hlcborg 12:38
win Locales - "Arabic, Gum" Jasen Betts 12:46
Re: Database Design Question Sim Zacks 12:51
Re: Issues with generate_series using integer boundaries Thom Brown 13:32
Re: Issues with generate_series using integer boundaries 📎 Thom Brown 13:58
Re: Problem with encode () and hmac() in pgcrypto Marko Kreen 14:01
Re: Issues with generate_series using integer boundaries David Johnston 14:37
PostgreSQL For Beginners Kenneth Buckler 14:40
Re: Issues with generate_series using integer boundaries Thom Brown 14:43
Re: Database Design Question Carlos Mennens 15:06
Re: PostgreSQL For Beginners Andy Colson 15:14
Re: set theory question Andy Colson 15:18
Re: Why does a normally fast query run so slow when the table is in a partition? Bill Thoen 15:29
Re: PostgreSQL For Beginners Andy Colson 15:53
Re: set theory question Rich Shepard 16:06
how to avoid repeating expensive computation in select Bob Price 16:07
Re: effective_io_concurrency Greg Smith 16:15
Re: PostgreSQL For Beginners rick chu 16:17
Re: Why does a normally fast query run so slow when the table is in a partition? Steve Crawford 16:47
Re: Encoding Conversion Tom Lane 16:51
how to avoid repeating expensive computation in select Bob Price 17:17
Re: how to avoid repeating expensive computation in select Bill Moran 17:23
Re: set theory question Wappler, Robert 17:41
Re: how to avoid repeating expensive computation in select David Johnston 18:07
Re: how to avoid repeating expensive computation in select Tom Lane 18:16
Re: how to avoid repeating expensive computation in select Pavel Stehule 18:28
Re: upgrade Alan Hodgson 18:50
Re: isn't "insert into where not exists" atomic? Mage 19:00
Re: upgrade Scott Marlowe 19:05
Re: isn't "insert into where not exists" atomic? Tom Lane 19:23
Re: how to avoid repeating expensive computation in select Bob Price 20:02
Tip: Transposing rows using generate_series() Alban Hertroys 20:09
Re: isn't "insert into where not exists" atomic? pasman pasmański 21:35
Re: Tip: Transposing rows using generate_series() pasman pasmański 21:44
Re: how to avoid repeating expensive computation in select Nicklas Avén 21:46
Re: how to avoid repeating expensive computation in select Tom Lane 22:33
Re: how to avoid repeating expensive computation in select Tom Lane 22:43
Re: isn't "insert into where not exists" atomic? Mage 23:50
Re: isn't "insert into where not exists" atomic? Mage 23:59

Feb. 4, 2011

Thread Author Time
tuning postgresql writes to disk Vinubalaji Gopal 00:08
Re: isn't "insert into where not exists" atomic? Tom Lane 02:54
Re: isn't "insert into where not exists" atomic? pasman pasmański 05:57
Re: redirecting query statement and output to a marked up file, using psql Wim Bertels 09:29
Re: redirecting query statement and output to a marked up file, using psql Bosco Rama 11:23
Re: redirecting query statement and output to a marked up file, using psql Wim Bertels 11:28
Re: Issues with generate_series using integer boundaries 📎 Thom Brown 12:32
Setting configuration parameter to role and propagating it to users asia123321 12:32
pg_restore: implied data-only restore\n Andreas Laggner 12:35
Re: pg_restore: implied data-only restore\n Adrian Klaver 15:37
Re: how to avoid repeating expensive computation in select Bob Price 16:08
Re: redirecting query statement and output to a marked up file, using psql Bosco Rama 17:46
Remove Role Membership Carlos Mennens 17:51
Re: set theory question Yeb Havinga 18:08
Additional Grants To SuperUser? Carlos Mennens 18:27
varchar (no 'N') vs. text Jon Nelson 18:45

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 28