Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-sql - July 2008
Prev | Next
July 1, 2008
- Quick select, slow update - help with performance problems Gary Stainburn (10:20)
- Re: Quick select, slow update - help with performance problems Richard Huxton (11:17)
- Re: Quick select, slow update - help with performance problems Gary Stainburn (12:42)
- Need a sample Postgre SQL script Dhanushka Samarakoon (14:31)
- Re: Need a sample Postgre SQL script Richard Huxton (14:42)
- Re: Need a sample Postgre SQL script Dhanushka Samarakoon (14:53)
- Re: Need a sample Postgre SQL script Richard Huxton (15:17)
- column default dependant on another columns value Fernando Hevia (20:12)
- Re: column default dependant on another columns value Richard Broersma (20:44)
- Re: column default dependant on another columns value Fernando Hevia (21:51)
- Re: column default dependant on another columns value Tom Lane (22:24)
July 2, 2008
- Re: column default dependant on another columns value Fernando Hevia (13:52)
- Re: Need a sample Postgre SQL script Dhanushka Samarakoon (17:12)
July 3, 2008
- nesting XmlAgg Isaac Dover (02:08)
- Re: nesting XmlAgg Peter Eisentraut (13:15)
July 4, 2008
- query: last N price for each product? David Garamond (12:35)
- Re: query: last N price for each product? Claus Guttesen (12:44)
- Re: query: last N price for each product? Frank Bax (12:55)
July 6, 2008
- Egroupware infolog query slow (includes query plan) Mark Stosberg (20:23)
- Re: Egroupware infolog query slow (includes query plan) Mark Stosberg (20:26)
- Re: Egroupware infolog query slow (includes query plan) Tom Lane (21:34)
July 7, 2008
- How to find space occupied by postgres on harddisk dipesh (09:13)
- how to control the execution plan ? Sabin Coanda (09:14)
- Re: How to find space occupied by postgres on harddisk Craig Ringer (09:30)
- Re: how to control the execution plan ? Scott Marlowe (21:14)
July 8, 2008
- exception handling and CONTINUE Marcin Krawczyk (12:24)
- Re: exception handling and CONTINUE Alvaro Herrera (13:06)
- Re: exception handling and CONTINUE Pavel Stehule (13:13)
- Re: how to control the execution plan ? Sabin Coanda (16:37)
- Re: exception handling and CONTINUE Marcin Krawczyk (18:44)
- Best practice for long-lived journal tables: bigint or recycling IDs? Mark Stosberg (21:16)
- Re: Best practice for long-lived journal tables: bigint orrecycling IDs? Alvaro Herrera (21:20)
- Re: Best practice for long-lived journal tables: bigint or recycling IDs? Mark Stosberg (21:35)
- Re: Re: Best practice for long-lived journal tables: bigintor recycling IDs? Alvaro Herrera (22:00)
July 9, 2008
- Profiling postgresql queries Nacef LABIDI (08:22)
- Re: Profiling postgresql queries A. Kretschmer (08:41)
- selecting N record for each group Ivan Sergio Borgonovo (09:45)
- Re: Best practice for long-lived journal tables: bigint or recycling IDs? Mark Stosberg (12:49)
July 10, 2008
- i can't connect after some periode aldy (06:57)
- Re: i can't connect after some periode A. Kretschmer (07:14)
- Re: i can't connect after some periode aldy (08:16)
- Design and Question PostgreSQL Admin (12:50)
- Problem in dynamic query execution in plpgsql Anoop G (12:55)
- record type Marcin Krawczyk (13:21)
- Re: Problem in dynamic query execution in plpgsql Pavel Stehule (13:30)
- Re: Problem in dynamic query execution in plpgsql A. Kretschmer (13:30)
- Re: i can't connect after some periode Lennin Caro (13:33)
- Re: i can't connect after some periode Lennin Caro (14:22)
- Re: i can't connect after some periode Scott Marlowe (14:48)
- Converting Copy to insert statement in backup file Chris Preston (15:40)
- Re: Converting Copy to insert statement in backup file Scott Marlowe (15:44)
- Re: Design and Question Niklas Johansson (16:46)
July 11, 2008
- record type Marcin Krawczyk (06:03)
- Re: record type Pawel Socha (07:29)
- Re: record type Marcin Krawczyk (09:54)
- ESQL CREATE DATABASE Krejci, Pavel (12:08)
- Rollback in Postgres samantha mahindrakar (15:43)
- Unnecessary repeat condition for a self inner join Robins Tharakan (16:26)
- Re: Rollback in Postgres Mark Roberts (16:27)
- When was my database created Matthew T. O'Connor (17:14)
- Re: Rollback in Postgres Scott Marlowe (17:21)
- function that returns a set of records and integer(both of them) daniel blanco (18:34)
- Re: When was my database created Steve Crawford (18:56)
- Re: Rollback in Postgres Simon Riggs (18:58)
- Re: Unnecessary repeat condition for a self inner join Tom Lane (20:00)
- PERSISTANT PREPARE (another point of view) Milan Oparnica (23:31)
- Re: PERSISTANT PREPARE (another point of view) Tom Lane (23:42)
- Re: PERSISTANT PREPARE (another point of view) Steve Midgley (23:54)
July 12, 2008
- Re: Rollback in Postgres Lewis Cunningham (01:56)
- Re: function that returns a set of records and integer(both of them) Pavel Stehule (07:05)
- Re: Rollback in Postgres Simon Riggs (07:56)
- Re: Unnecessary repeat condition for a self inner join Robins Tharakan (08:05)
- Re: Rollback in Postgres Dave Page (08:40)
- Re: Problem in dynamic query execution in plpgsql Anoop G (09:15)
- Re: Rollback in Postgres Simon Riggs (09:20)
- Re: Problem in dynamic query execution in plpgsql Ragnar (10:06)
- CHAR to INT Martín Marqués (13:15)
- Re: Rollback in Postgres Scott Marlowe (13:19)
- Re: CHAR to INT Pavel Stehule (13:46)
- Re: CHAR to INT Martín Marqués (14:01)
- Re: Unnecessary repeat condition for a self inner join Tom Lane (15:20)
- Re: Rollback in Postgres Lewis Cunningham (18:59)
- Re: Rollback in Postgres Lewis Cunningham (19:04)
- Re: Copyright and Paper walls (was: Rollback in Postgres) Steve Midgley (19:23)
- Re: Copyright and Paper walls John Hasler (22:53)
July 13, 2008
- RE: function that returns a set of records and integer(both of them) daniel blanco (02:32)
- Re: function that returns a set of records and integer(both of them) Pavel Stehule (05:06)
- RE: function that returns a set of records and integer(both of them) daniel blanco (06:53)
- Re: function that returns a set of records and integer(both of them) Pavel Stehule (10:40)
- Re: PERSISTANT PREPARE (another point of view) Milan Oparnica (12:20)
- Re: PERSISTANT PREPARE (another point of view) Milan Oparnica (13:55)
July 14, 2008
- how to perform minus (-) operation in a dynamic query Anoop G (05:51)
- Re: how to perform minus (-) operation in a dynamic query A. Kretschmer (06:13)
- Re: how to perform minus (-) operation in a dynamic query Markus Wanner (11:43)
- Re: how to perform minus (-) operation in a dynamic query Tom Lane (14:02)
- Re: Rollback in Postgres samantha mahindrakar (15:20)
- Re: Rollback in Postgres Scott Marlowe (18:12)
- Re: Rollback in Postgres Kaare Rasmussen (19:59)
- Re: Rollback in Postgres Richard Broersma (20:06)
- Re: Rollback in Postgres Alvaro Herrera (20:10)
- Re: Rollback in Postgres Simon Riggs (20:20)
- Re: Rollback in Postgres Kaare Rasmussen (20:34)
- Re: Rollback in Postgres Kaare Rasmussen (20:38)
- Re: Rollback in Postgres Richard Broersma (20:47)
- Re: Rollback in Postgres Lewis Cunningham (20:51)
- Re: Rollback in Postgres Alvaro Herrera (20:54)
- Re: Rollback in Postgres Simon Riggs (21:09)
July 15, 2008
- Re: Rollback in Postgres Tom Lane (01:18)
- Re: Rollback in Postgres Jonah H. Harris (02:54)
- Re: how to perform minus (-) operation in a dynamic query Anoop G (04:17)
- COPY equivalent for updates Ivan Sergio Borgonovo (06:10)
- Re: Rollback in Postgres Simon Riggs (06:17)
- How to GROUP results BY month Oliveiros Cristina (12:12)
- Re: How to GROUP results BY month A. Kretschmer (12:31)
- Re: How to GROUP results BY month Herouth Maoz (12:32)
- Re: How to GROUP results BY month Herouth Maoz (12:39)
- Re: Rollback in Postgres Jonah H. Harris (13:59)
- Re: How to GROUP results BY month Scott Marlowe (21:57)
July 16, 2008
- Re: How to GROUP results BY month Mark Roberts (01:15)
- Re: How to GROUP results BY month Scott Marlowe (01:55)
- Re: COPY equivalent for updates Decibel! (03:13)
- Re: How to GROUP results BY month A. Kretschmer (05:37)
- Re: How to GROUP results BY month A. Kretschmer (05:39)
- Problem with ORDER BY and DISTINCT ON Steve Midgley (07:39)
- integrity check and visibility was: COPY equivalent for updates Ivan Sergio Borgonovo (09:06)
- Re: Problem with ORDER BY and DISTINCT ON Tom Lane (14:29)
- Re: Rollback in Postgres Kaare Rasmussen (16:10)
- Re: How to GROUP results BY month Mark Roberts (16:29)
- Re: Problem with ORDER BY and DISTINCT ON Steve Midgley (17:03)
- pg_advisory_lock(bigint) vs. LOCK TABLE Volkan YAZICI (20:20)
- Re: PERSISTANT PREPARE (another point of view) Milan Oparnica (20:51)
July 17, 2008
- Re: PERSISTANT PREPARE (another point of view) Pavel Stehule (06:13)
- Re: PERSISTANT PREPARE (another point of view) Richard Huxton (08:30)
- Generating table rows from arrays Florian Weimer (10:23)
- Re: Generating table rows from arrays Richard Huxton (10:37)
- Re: Generating table rows from arrays Pavel Stehule (10:38)
- Re: How to GROUP results BY month Oliveiros Cristina (11:18)
- Re: Generating table rows from arrays Florian Weimer (11:44)
- Re: pg_advisory_lock(bigint) vs. LOCK TABLE Alvaro Herrera (16:16)
July 18, 2008
- Re: pg_advisory_lock(bigint) vs. LOCK TABLE Volkan YAZICI (05:26)
- Re: pg_advisory_lock(bigint) vs. LOCK TABLE Tom Lane (05:40)
- Re: How to GROUP results BY month Lennin Caro (14:04)
- Re: How to GROUP results BY month Oliveiros Cristina (14:09)
- Re: pg_advisory_lock(bigint) vs. LOCK TABLE Mark Roberts (17:22)
- Re: pg_advisory_lock(bigint) vs. LOCK TABLE Alvaro Herrera (18:30)
July 20, 2008
- Whassup with this? (create table .... like ... fails) Karl Denninger (03:15)
- Re: Whassup with this? (create table .... like ... fails) Stephan Szabo (03:55)
- Re: PERSISTANT PREPARE (another point of view) Milan Oparnica (13:23)
- Re: PERSISTANT PREPARE (another point of view) Milan Oparnica (14:15)
- Re: PERSISTANT PREPARE (another point of view) Milan Oparnica (14:16)
July 21, 2008
- Size or efficiency differences "varchar(128) vs. varchar(32)" Emi Lu (14:06)
- Re: Size or efficiency differences "varchar(128) vs.varchar(32)" Alvaro Herrera (15:40)
- Re: Size or efficiency differences "varchar(128) vs. varchar(32)" Scott Marlowe (16:17)
- Re: Size or efficiency differences "varchar(128) vs. varchar(32)" Emi Lu (16:59)
- Re: PERSISTANT PREPARE (another point of view) Milan Oparnica (20:45)
July 22, 2008
- Re: PERSISTANT PREPARE (another point of view) Craig Ringer (01:04)
- Re: PERSISTANT PREPARE (another point of view) Craig Ringer (02:31)
- Re: PERSISTANT PREPARE (another point of view) Pavel Stehule (06:43)
- Re: PERSISTANT PREPARE (another point of view) Scott Marlowe (07:28)
- How to Select a Tupl by Nearest Date Christian Kindler (08:42)
- Re: How to Select a Tupl by Nearest Date A. Kretschmer (09:06)
- index for group by Patrick Scharrenberg (11:18)
- Re: index for group by A. Kretschmer (11:27)
- Re: How to Select a Tupl by Nearest Date Christian Kindler (18:12)
- Strange query duration Fernando Hevia (19:10)
- Re: Strange query duration Stephan Szabo (20:18)
- Re: Strange query duration Richard Broersma (20:19)
- Re: Strange query duration Fernando Hevia (20:45)
- Re: Strange query duration Tom Lane (20:46)
- Re: index for group by Steve Midgley (21:17)
- Re: PERSISTANT PREPARE (another point of view) Jeff Williams (23:16)
July 23, 2008
- Select default values Maximilian Tyrtania (08:32)
- Re: Select default values A. Kretschmer (09:26)
- Re: Select default values Pavel Stehule (09:28)
- Re: Select default values Maximilian Tyrtania (09:49)
- Re: Select default values Maximilian Tyrtania (09:57)
- Re: Select default values Pavel Stehule (10:19)
- Re: Select default values Maximilian Tyrtania (10:35)
- Re: Select default values Karsten Hilbert (10:44)
- Re: Select default values Pavel Stehule (11:26)
- Re: Select default values Maximilian Tyrtania (12:06)
- Re: Select default values Scott Marlowe (14:29)
- Query prepared plan Emi Lu (18:22)
July 24, 2008
- Cloning hierarchical data Maximilian Tyrtania (07:43)
- Re: Select default values Giorgio Valoti (10:30)
- Re: Select default values Richard Huxton (10:42)
- postgres time zone settings Anoop G (12:56)
- truncate vs. delete Emi Lu (13:34)
- Re: truncate vs. delete Emi Lu (13:47)
- Re: truncate vs. delete A. Kretschmer (13:53)
- Re: truncate vs. delete Lennin Caro (13:58)
- Re: truncate vs. delete Emi Lu (14:01)
- Re: truncate vs. delete A. Kretschmer (14:17)
- Re: truncate vs. delete Scott Marlowe (14:33)
- Re: truncate vs. delete Emi Lu (14:36)
- Re: truncate vs. delete Shane Ambler (14:38)
- Re: postgres time zone settings Jaime Casanova (16:47)
- Re: Select default values Giorgio Valoti (19:35)
- Re: Select default values Richard Broersma (21:15)
July 25, 2008
- Arrays, types and prodedures Chris Hoy (08:32)