pgsql-sql - July 2008

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

July 1, 2008

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
nesting XmlAgg	Isaac Dover	02:08
Re: nesting XmlAgg	Peter Eisentraut	13:15

July 4, 2008

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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 or recycling 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: bigint or recycling IDs?	Alvaro Herrera	22:00

July 9, 2008

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
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

Thread	Author	Time
Arrays, types and prodedures	Chris Hoy	08:32

Browse Archives

Prev | Next