Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-general - March 2011

2011-03-01

• Re: slow building index and reference after Sybase to Pg Joshua D. Drake (00:10)
• Re: slow building index and reference after Sybase to Pg Andres Freund (00:30)
• Re: Lock ACCESS EXCLUSIVE and Select question ! David Johnston (01:13)
• Re: Binary params in libpq Craig Ringer (04:41)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Aleksey Tsalolikhin (05:51)
• restore a server backup Malm Paul (06:37)
• new databases using a template. Malm Paul (06:42)
• Re: restore a server backup Vibhor Kumar (07:48)
• pg_catalog.pg_stat_activity and current_query Alex (08:36)
• Re: how to avoid repeating expensive computation in select Orhan Kavrakoglu (08:51)
• Re: pg_catalog.pg_stat_activity and current_query Szymon Guz (09:35)
• Tool for shifting tables from Mysql to Postgresql Adarsh Sharma (10:27)
• Re: restore a server backup Raymond O'Donnell (10:51)
• Re: Issues with imported blobs from Postgres 8 to 9 Mahdi Mankai (11:08)
• Re: Tool for shifting tables from Mysql to Postgresql Raghavendra (11:57)
• Re: Tool for shifting tables from Mysql to Postgresql Jaiswal Dhaval Sudhirkumar (12:14)
• Postgresql not start during Startup Adarsh Sharma (13:07)
• Re: Postgresql not start during Startup Ray Stell (13:09)
• Re: Binary params in libpq Kelly Burkhart (14:19)
• Re: Lock ACCESS EXCLUSIVE and Select question ! Alan Acosta (14:23)
• Re: Lock ACCESS EXCLUSIVE and Select question ! Andrew Sullivan (14:33)
• Screencasts for PostgreSQL James B. Byrne (14:34)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Adrian Klaver (14:44)
• Re: Binary params in libpq Merlin Moncure (14:47)
• Re: Lock ACCESS EXCLUSIVE and Select question ! Alan Acosta (15:04)
• Re: slow building index and reference after Sybase to Pg Gary Fu (15:10)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Adrian Klaver (15:18)
• Re: Binary params in libpq Tom Lane (15:19)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Tom Lane (15:24)
• Re: Issues with imported blobs from Postgres 8 to 9 David Johnston (19:32)
• Thousands of users using one schema -> ERROR: row is too big Magnus Reftel (20:54)
• Re: Thousands of users using one schema -> ERROR: row is too big Bill Moran (20:57)
• Re: Thousands of users using one schema -> ERROR: row is too big Magnus Reftel (21:04)
• #PgEast Training Schedule Up Joshua D. Drake (21:13)
• #PgEast Training Schedule Up Joshua D. Drake (21:15)
• Re: Thousands of users using one schema -> ERROR: row is too big Joshua D. Drake (21:18)
• Re: Thousands of users using one schema -> ERROR: row is too big Tom Lane (21:45)
• #PgEast Training Schedule Up Joshua D. Drake (21:46)
• What could cause sudden increase in "PARSE" stage of prepared statements? hubert depesz lubaczewski (22:17)
• Dynamic binding in plpgsql function Pierre Racine (23:01)
• Re: Dynamic binding in plpgsql function Pavel Stehule (23:17)
• Re: Dynamic binding in plpgsql function Vibhor Kumar (23:23)

2011-03-02

• Query should have failed, but didn't? Royce Ausburn (01:50)
• Re: Query should have failed, but didn't? Andy Colson (03:16)
• Re: Query should have failed, but didn't? Royce Ausburn (03:34)
• Re: Query should have failed, but didn't? David Johnston (03:38)
• Comparing md5 hash with md5 password hash Michał Koba (06:42)
• Re: Comparing md5 hash with md5 password hash Thom Brown (07:15)
• pg_dump slow with bytea data chris r. (08:35)
• Re: pg_dump slow with bytea data chris r. (08:47)
• Re: Dynamic binding in plpgsql function Merlin Moncure (14:30)
• how are you? suresh ramasamy (14:31)
• Re: Dynamic binding in plpgsql function Dmitriy Igrishin (14:34)
• Re: pg_dump slow with bytea data Merlin Moncure (14:41)
• Re: Dynamic binding in plpgsql function Merlin Moncure (14:45)
• Re: Dynamic binding in plpgsql function Dmitriy Igrishin (14:54)
• Re: Dynamic binding in plpgsql function Merlin Moncure (15:05)
• Re: Dynamic binding in plpgsql function Pierre Racine (15:06)
• Re: Dynamic binding in plpgsql function Merlin Moncure (15:12)
• I need your help to get opinions about this situation Rayner Julio Rodríguez Pimentel (15:41)
• Per-session memory footprint (9.0/windows) Hannes Erven (16:07)
• Re: Per-session memory footprint (9.0/windows) Scott Mead (16:59)
• Re: pg_dump slow with bytea data Alban Hertroys (17:58)
• Index question Michael Black (18:31)
• Re: *****SPAM***** Index question Scott Ribe (18:40)
• Re: Index question Andrew Sullivan (18:45)
• Re: Index question Scott Ribe (18:50)
• Re: Index question Joshua D. Drake (19:05)
• Re: how are you? John R Pierce (19:11)
• Grant question Michael Black (19:30)
• Re: Index question Michael Black (19:30)
• Re: Grant question Bill Moran (19:32)
• Re: Grant question S G (19:36)
• Re: Grant question Bosco Rama (19:39)
• How to approach dynamic status reporting James B. Byrne (20:11)
• select DISTINCT not ordering the returned rows Ioana Danes (20:35)
• Re: select DISTINCT not ordering the returned rows Ioana Danes (20:39)
• Re: select DISTINCT not ordering the returned rows Tom Lane (20:44)
• Re: select DISTINCT not ordering the returned rows Thomas Kellerer (20:46)
• Re: select DISTINCT not ordering the returned rows Ioana Danes (21:02)
• Re: Per-session memory footprint (9.0/windows) Hannes Erven (22:24)
• Re: Per-session memory footprint (9.0/windows) Tom Lane (22:42)
• Re: how to avoid repeating expensive computation in select Merlin Moncure (23:50)

2011-03-03

• close connection more expensive that open connection? Rob Sargent (00:13)
• Re: PG on two nodes with shared disk ocfs2 & drbd Jasmin Dizdarevic (01:01)
• Re: PG on two nodes with shared disk ocfs2 & drbd Craig Ringer (01:11)
• Re: ERROR: invalid byte sequence for encoding "UTF8": 0xc35c Jasmin Dizdarevic (01:18)
• Re: ERROR: invalid byte sequence for encoding "UTF8": 0xc35c Craig Ringer (01:45)
• data type Nick Raj (05:41)
• Integrated Trigers Alpha Beta (11:59)
• Re: Integrated Trigers Willy-Bas Loos (13:28)
• Why count(*) doest use index? obamabarak (13:29)
• Re: I need your help to get opinions about this situation David Johnston (14:15)
• Re: Screencasts for PostgreSQL Willy-Bas Loos (14:18)
• Re: Postgresql not start during Startup Willy-Bas Loos (14:28)
• Re: data type Willy-Bas Loos (14:40)
• closing connection more expensive than opening connection? Rob Sargent (15:27)
• opening connection more expensive than closing connection? Rob Sargent (15:28)
• invalid byte sequence Maximilian Tyrtania (16:02)
• Re: opening connection more expensive than closing connection? Rob Sargent (16:05)
• Tracking table modifications / table stats Derrick Rice (17:00)
• Re: Why count(*) doest use index? Adrian Klaver (17:22)
• Re: Tracking table modifications / table stats Merlin Moncure (17:23)
• Re: Tracking table modifications / table stats Andy Colson (17:34)
• Re: Tracking table modifications / table stats Derrick Rice (17:44)
• orphaned?? tmp files Reid Thompson (20:11)
• Re: orphaned?? tmp files Tom Lane (22:04)

2011-03-04

• Re: I need your help to get opinions about this situation Greg Williamson (01:05)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Aleksey Tsalolikhin (02:15)
• updating all records of a table Gauthier, Dave (03:03)
• Re: updating all records of a table Joshua D. Drake (03:20)
• Pgdump error "invalid page header in block" tuanhoanganh (07:47)
• Re: Pgdump error "invalid page header in block" John R Pierce (07:59)
• Re: invalid byte sequence Craig Ringer (10:01)
• full text search zab08 (10:58)
• Re: updating all records of a table Andrew Sullivan (11:47)
• Re: updating all records of a table Vibhor Kumar (11:54)
• Re: Pgdump error "invalid page header in block" Vibhor Kumar (11:56)
• How to select a list of sequences? Kenneth Buckler (14:02)
• Re: Screencasts for PostgreSQL James B. Byrne (14:18)
• Re: invalid byte sequence Maximilian Tyrtania (14:18)
• Re: How to select a list of sequences? Raghavendra (14:31)
• Re: How to select a list of sequences? Raghavendra (14:36)
• Re: updating all records of a table Rob Sargent (15:21)
• Re: How to select a list of sequences? salah jubeh (15:32)
• Re: updating all records of a table Gauthier, Dave (15:37)
• gmane? Thufir Hawat (15:38)
• script errors or PEBKAC? Thufir Hawat (15:48)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Adrian Klaver (15:53)
• Re: script errors or PEBKAC? Michael Black (18:41)
• Re: script errors or PEBKAC? Adrian Klaver (19:20)
• Re: script errors or PEBKAC? Adrian Klaver (19:24)
• Re: I need your help to get opinions about this situation Rayner Julio Rodríguez Pimentel (20:05)
• Unprivileged access to pgsql functions? Matt Warner (21:11)
• Re: Unprivileged access to pgsql functions? John R Pierce (21:20)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:29)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:31)
• Re: Unprivileged access to pgsql functions? Vibhor Kumar (21:34)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:41)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:42)
• Re: updating all records of a table Chris Browne (21:46)
• Re: Unprivileged access to pgsql functions? Bosco Rama (21:48)
• Re: Unprivileged access to pgsql functions? John R Pierce (21:49)
• Re: Unprivileged access to pgsql functions? Vibhor Kumar (21:51)
• Re: Unprivileged access to pgsql functions? Andrew Sullivan (21:51)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:51)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:55)
• Re: Unprivileged access to pgsql functions? Bosco Rama (21:56)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:57)
• Re: Unprivileged access to pgsql functions? Matt Warner (21:58)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Aleksey Tsalolikhin (22:03)
• Re: Unprivileged access to pgsql functions? John R Pierce (22:03)
• Re: Unprivileged access to pgsql functions? Matt Warner (22:08)
• Significance of numbers in server errors? Sebastien Boisvert (23:15)

2011-03-05

• Re: Significance of numbers in server errors? Peter Geoghegan (00:13)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Adrian Klaver (00:45)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Aleksey Tsalolikhin (01:11)
• test data Andy Colson (01:41)
• Re: database is bigger after dump/restore - why? (60 GB to 109 GB) Adrian Klaver (03:19)
• Re: test data David Johnston (03:28)
• Re: invalid byte sequence Craig Ringer (06:52)
• 9.1 - rewrite less alter table? hubert depesz lubaczewski (11:55)
• Re: updating all records of a table ray (15:38)
• Re: updating all records of a table Martijn van Oosterhout (15:55)
• Re: Why count(*) doest use index? Raymond O'Donnell (17:02)
• PHP array to PlPgSQL arrat. How to? Andre Lopes (19:22)
• Re: PHP array to PlPgSQL arrat. How to? Pavel Stehule (19:28)
• Re: PHP array to PlPgSQL arrat. How to? Andre Lopes (19:38)
• Re: PHP array to PlPgSQL arrat. How to? Pavel Stehule (19:42)
• Re: PHP array to PlPgSQL arrat. How to? Dmitriy Igrishin (19:48)
• Re: PHP array to PlPgSQL arrat. How to? Andre Lopes (19:48)
• Re: PHP array to PlPgSQL arrat. How to? Pavel Stehule (19:58)
• Re: PHP array to PlPgSQL arrat. How to? Dmitriy Igrishin (20:06)
• School teacher in need of HELP hbailey17 (20:33)
• Web Hosting matty jones (21:08)
• Re: PHP array to PlPgSQL arrat. How to? Pavel Stehule (22:05)
• Re: Why count(*) doest use index? Allan Kamau (22:05)
• Re: PHP array to PlPgSQL arrat. How to? John R Pierce (22:44)
• Re: Why count(*) doest use index? John R Pierce (22:46)
• Re: Why count(*) doest use index? Willy-Bas Loos (23:25)
• Re: updating all records of a table Willy-Bas Loos (23:42)

2011-03-06

• Re: Web Hosting Mike Christensen (00:40)
• Re: School teacher in need of HELP Adrian Klaver (01:04)
• Re: Web Hosting Andreas Kretschmer (01:05)
• Re: Web Hosting Bret Fledderjohn (01:07)
• Re: Web Hosting Ogden (01:12)
• Re: Web Hosting Martin Gainty (02:32)
• Re: Web Hosting Uwe Schroeder (02:55)
• Re: School teacher in need of HELP Jaime Casanova (05:53)
• Re: Why count(*) doest use index? Allan Kamau (08:03)
• Re: Web Hosting Brent Wood (08:11)
• Re: Question about switchover with PG9 replication Jean-Armel Luce (10:09)
• Re: Why count(*) doest use index? Martijn van Oosterhout (10:41)
• Re: Why count(*) doest use index? Alban Hertroys (10:45)
• Copying few tables from one database to another Alexander Farber (13:43)
• Re: Copying few tables from one database to another Vibhor Kumar (13:50)
• Re: PHP array to PlPgSQL arrat. How to? Andre Lopes (14:58)
• Re: PHP array to PlPgSQL arrat. How to? Pavel Stehule (15:05)
• Re: School teacher in need of HELP Cia Watson (16:22)
• Re: PHP array to PlPgSQL arrat. How to? Andre Lopes (16:23)