Home > mailing lists

Mailing lists [pgsql-sql]

1 July 2008

11:01 Quick select, slow update - help with performance problems Gary Stainburn
11:36 Re: Quick select, slow update - help with performance problems Richard Huxton
12:49 Re: Quick select, slow update - help with performance problems Gary Stainburn
14:32 Need a sample Postgre SQL script Dhanushka Samarakoon
14:42 Re: Need a sample Postgre SQL script Richard Huxton
14:53 Re: Need a sample Postgre SQL script Dhanushka Samarakoon
15:17 Re: Need a sample Postgre SQL script Richard Huxton
20:12 column default dependant on another columns value Fernando Hevia
20:44 Re: column default dependant on another columns value Richard Broersma
21:51 Re: column default dependant on another columns value Fernando Hevia
22:29 Re: column default dependant on another columns value Tom Lane

2 July 2008

13:51 Re: column default dependant on another columns value Fernando Hevia
17:12 Re: Need a sample Postgre SQL script Dhanushka Samarakoon

3 July 2008

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

4 July 2008

12:36 query: last N price for each product? David Garamond
12:44 Re: query: last N price for each product? Claus Guttesen
12:56 Re: query: last N price for each product? Frank Bax

6 July 2008

20:23 Egroupware infolog query slow (includes query plan) Mark Stosberg
20:30 Re: Egroupware infolog query slow (includes query plan) Mark Stosberg
21:34 Re: Egroupware infolog query slow (includes query plan) Tom Lane

7 July 2008

09:16 How to find space occupied by postgres on harddisk dipesh
09:30 Re: How to find space occupied by postgres on harddisk Craig Ringer
09:40 how to control the execution plan ? Sabin Coanda
21:14 Re: how to control the execution plan ? Scott Marlowe

8 July 2008

12:27 exception handling and CONTINUE Marcin Krawczyk
13:06 Re: exception handling and CONTINUE Alvaro Herrera
13:13 Re: exception handling and CONTINUE Pavel Stehule
16:40 Re: how to control the execution plan ? Sabin Coanda
18:46 Re: exception handling and CONTINUE Marcin Krawczyk
21:16 Best practice for long-lived journal tables: bigint or recycling IDs? Mark Stosberg
21:20 Re: Best practice for long-lived journal tables: bigint or recycling IDs? Alvaro Herrera
21:35 Re: Best practice for long-lived journal tables: bigint or recycling IDs? Mark Stosberg
22:01 Re: Re: Best practice for long-lived journal tables: bigint or recycling IDs? Alvaro Herrera

9 July 2008

08:24 Profiling postgresql queries Nacef LABIDI
08:41 Re: Profiling postgresql queries A. Kretschmer
09:46 selecting N record for each group Ivan Sergio Borgonovo
12:50 Re: Best practice for long-lived journal tables: bigint or recycling IDs? Mark Stosberg

10 July 2008

07:04 i can't connect after some periode aldy
07:14 Re: i can't connect after some periode A. Kretschmer
08:19 Re: i can't connect after some periode aldy
12:52 Design and Question PostgreSQL Admin
12:57 Problem in dynamic query execution in plpgsql Anoop G
13:21 record type Marcin Krawczyk
13:30 Re: Problem in dynamic query execution in plpgsql Pavel Stehule
13:31 Re: Problem in dynamic query execution in plpgsql A. Kretschmer
13:33 Re: i can't connect after some periode Lennin Caro
14:23 Re: i can't connect after some periode Lennin Caro
14:49 Re: i can't connect after some periode Scott Marlowe
15:40 Converting Copy to insert statement in backup file Chris Preston
15:45 Re: Converting Copy to insert statement in backup file Scott Marlowe
17:14 Re: Design and Question Niklas Johansson

11 July 2008

06:06 record type Marcin Krawczyk
07:29 Re: record type Pawel Socha
09:54 Re: record type Marcin Krawczyk
13:55 ESQL CREATE DATABASE Krejci, Pavel
15:54 Rollback in Postgres samantha mahindrakar
16:27 Unnecessary repeat condition for a self inner join Robins Tharakan
16:29 Re: Rollback in Postgres Mark Roberts
17:15 When was my database created Matthew T. O'Connor
17:22 Re: Rollback in Postgres Scott Marlowe
18:34 function that returns a set of records and integer(both of them)‏ daniel blanco
19:19 Re: Rollback in Postgres Simon Riggs
19:22 Re: When was my database created Steve Crawford
20:00 Re: Unnecessary repeat condition for a self inner join Tom Lane
23:31 PERSISTANT PREPARE (another point of view) Milan Oparnica
23:42 Re: PERSISTANT PREPARE (another point of view) Tom Lane
23:54 Re: PERSISTANT PREPARE (another point of view) Steve Midgley

12 July 2008

01:56 Re: Rollback in Postgres Lewis Cunningham
07:05 Re: function that returns a set of records and integer(both of them)‏ Pavel Stehule
07:50 Re: Rollback in Postgres Simon Riggs
08:05 Re: Unnecessary repeat condition for a self inner join Robins Tharakan
08:40 Re: Rollback in Postgres Dave Page
09:15 Re: Problem in dynamic query execution in plpgsql Anoop G
09:15 Re: Rollback in Postgres Simon Riggs
10:06 Re: Problem in dynamic query execution in plpgsql Ragnar
13:15 CHAR to INT Martín Marqués
13:19 Re: Rollback in Postgres Scott Marlowe
13:47 Re: CHAR to INT Pavel Stehule
14:01 Re: CHAR to INT Martín Marqués
15:20 Re: Unnecessary repeat condition for a self inner join Tom Lane
18:59 Re: Rollback in Postgres Lewis Cunningham
19:05 Re: Rollback in Postgres Lewis Cunningham
19:24 Re: Copyright and Paper walls (was: Rollback in Postgres) Steve Midgley
23:12 Re: Copyright and Paper walls John Hasler

13 July 2008

02:34 RE: function that returns a set of records and integer(both of them)‏ daniel blanco
05:06 Re: function that returns a set of records and integer(both of them)‏ Pavel Stehule
06:53 RE: function that returns a set of records and integer(both of them)‏ daniel blanco
10:40 Re: function that returns a set of records and integer(both of them)‏ Pavel Stehule
12:20 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
14:10 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica

14 July 2008

05:51 how to perform minus (-) operation in a dynamic query Anoop G
06:17 Re: how to perform minus (-) operation in a dynamic query A. Kretschmer
11:44 Re: how to perform minus (-) operation in a dynamic query Markus Wanner
14:02 Re: how to perform minus (-) operation in a dynamic query Tom Lane
15:20 Re: Rollback in Postgres samantha mahindrakar
18:14 Re: Rollback in Postgres Scott Marlowe
19:59 Re: Rollback in Postgres Kaare Rasmussen
20:07 Re: Rollback in Postgres Richard Broersma
20:11 Re: Rollback in Postgres Alvaro Herrera
20:14 Re: Rollback in Postgres Simon Riggs
20:34 Re: Rollback in Postgres Kaare Rasmussen
20:39 Re: Rollback in Postgres Kaare Rasmussen
20:47 Re: Rollback in Postgres Richard Broersma
20:51 Re: Rollback in Postgres Lewis Cunningham
20:55 Re: Rollback in Postgres Alvaro Herrera
21:03 Re: Rollback in Postgres Simon Riggs

15 July 2008

01:18 Re: Rollback in Postgres Tom Lane
02:54 Re: Rollback in Postgres Jonah H. Harris
04:27 Re: how to perform minus (-) operation in a dynamic query Anoop G
06:24 COPY equivalent for updates Ivan Sergio Borgonovo
06:25 Re: Rollback in Postgres Simon Riggs
12:28 How to GROUP results BY month Oliveiros Cristina
12:32 Re: How to GROUP results BY month A. Kretschmer
12:40 Re: How to GROUP results BY month Herouth Maoz
12:54 Re: How to GROUP results BY month Herouth Maoz
13:59 Re: Rollback in Postgres Jonah H. Harris
21:58 Re: How to GROUP results BY month Scott Marlowe

16 July 2008

01:15 Re: How to GROUP results BY month Mark Roberts
01:55 Re: How to GROUP results BY month Scott Marlowe
04:31 Re: COPY equivalent for updates Decibel!
05:58 Re: How to GROUP results BY month A. Kretschmer
05:59 Re: How to GROUP results BY month A. Kretschmer
07:40 Problem with ORDER BY and DISTINCT ON Steve Midgley
09:09 integrity check and visibility was: COPY equivalent for updates Ivan Sergio Borgonovo
15:44 Re: Problem with ORDER BY and DISTINCT ON Tom Lane
16:37 Re: Rollback in Postgres Kaare Rasmussen
16:45 Re: How to GROUP results BY month Mark Roberts
17:03 Re: Problem with ORDER BY and DISTINCT ON Steve Midgley
20:20 pg_advisory_lock(bigint) vs. LOCK TABLE Volkan YAZICI
21:10 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica

17 July 2008

06:13 Re: PERSISTANT PREPARE (another point of view) Pavel Stehule
08:30 Re: PERSISTANT PREPARE (another point of view) Richard Huxton
10:32 Generating table rows from arrays Florian Weimer
10:37 Re: Generating table rows from arrays Richard Huxton
10:38 Re: Generating table rows from arrays Pavel Stehule
11:18 Re: How to GROUP results BY month Oliveiros Cristina
11:44 Re: Generating table rows from arrays Florian Weimer
17:04 Re: pg_advisory_lock(bigint) vs. LOCK TABLE Alvaro Herrera

18 July 2008

05:26 Re: pg_advisory_lock(bigint) vs. LOCK TABLE Volkan YAZICI
05:40 Re: pg_advisory_lock(bigint) vs. LOCK TABLE Tom Lane
14:04 Re: How to GROUP results BY month Lennin Caro
14:09 Re: How to GROUP results BY month Oliveiros Cristina
17:22 Re: pg_advisory_lock(bigint) vs. LOCK TABLE Mark Roberts
18:30 Re: pg_advisory_lock(bigint) vs. LOCK TABLE Alvaro Herrera

20 July 2008

03:35 Whassup with this? (create table .... like ... fails) Karl Denninger
04:00 Re: Whassup with this? (create table .... like ... fails) Stephan Szabo
13:41 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
14:41 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
14:41 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica

21 July 2008

15:04 Size or efficiency differences "varchar(128) vs. varchar(32)" Emi Lu
15:41 Re: Size or efficiency differences "varchar(128) vs. varchar(32)" Alvaro Herrera
16:19 Re: Size or efficiency differences "varchar(128) vs. varchar(32)" Scott Marlowe
16:59 Re: Size or efficiency differences "varchar(128) vs. varchar(32)" Emi Lu
21:11 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica

22 July 2008

01:05 Re: PERSISTANT PREPARE (another point of view) Craig Ringer
02:31 Re: PERSISTANT PREPARE (another point of view) Craig Ringer
06:43 Re: PERSISTANT PREPARE (another point of view) Pavel Stehule
07:28 Re: PERSISTANT PREPARE (another point of view) Scott Marlowe
08:43 How to Select a Tupl by Nearest Date Christian Kindler
09:06 Re: How to Select a Tupl by Nearest Date A. Kretschmer
11:18 index for group by Patrick Scharrenberg
11:27 Re: index for group by A. Kretschmer
19:40 Re: How to Select a Tupl by Nearest Date Christian Kindler
20:04 Strange query duration Fernando Hevia
20:48 Re: Strange query duration Stephan Szabo
20:49 Re: Strange query duration Richard Broersma
21:11 Re: Strange query duration Fernando Hevia
21:12 Re: Strange query duration Tom Lane
21:28 Re: index for group by Steve Midgley

23 July 2008

00:42 Re: PERSISTANT PREPARE (another point of view) Jeff Williams
08:38 Select default values Maximilian Tyrtania
09:27 Re: Select default values A. Kretschmer
09:29 Re: Select default values Pavel Stehule
09:49 Re: Select default values Maximilian Tyrtania
09:57 Re: Select default values Maximilian Tyrtania
10:24 Re: Select default values Pavel Stehule
10:35 Re: Select default values Maximilian Tyrtania
10:44 Re: Select default values Karsten Hilbert
11:26 Re: Select default values Pavel Stehule
12:06 Re: Select default values Maximilian Tyrtania
14:30 Re: Select default values Scott Marlowe
18:39 Query prepared plan Emi Lu

24 July 2008

07:43 Cloning hierarchical data Maximilian Tyrtania
10:36 Re: Select default values Giorgio Valoti
10:43 Re: Select default values Richard Huxton
12:56 postgres time zone settings Anoop G
13:34 truncate vs. delete Emi Lu
13:48 Re: truncate vs. delete Emi Lu
13:54 Re: truncate vs. delete A. Kretschmer
13:58 Re: truncate vs. delete Lennin Caro
14:01 Re: truncate vs. delete Emi Lu
14:17 Re: truncate vs. delete A. Kretschmer
14:38 Re: truncate vs. delete Scott Marlowe
14:42 Re: truncate vs. delete Emi Lu
14:43 Re: truncate vs. delete Shane Ambler
16:47 Re: postgres time zone settings Jaime Casanova
20:49 Re: Select default values Giorgio Valoti
21:15 Re: Select default values Richard Broersma

25 July 2008

08:32 Arrays, types and prodedures Chris Hoy
08:38 Re: Arrays, types and prodedures Pavel Stehule
09:12 Re: postgres time zone settings(time difference in Server and client) Anoop G
09:23 Re: postgres time zone settings(time difference in Server and client) Richard Huxton
09:24 Re: postgres time zone settings(time difference in Server and client) Pawel Socha
10:02 Re: postgres time zone settings(time difference in Server and client) Anoop G
12:13 A table with two names or table alias Tk421
12:25 Re: A table with two names or table alias A. Kretschmer
13:56 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
14:38 Re: Query prepared plan Emi Lu
15:26 Re: A table with two names or table alias Igor Neyman
17:21 Re: Query prepared plan Tom Lane
18:12 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
19:08 Re: PERSISTANT PREPARE (another point of view) Pavel Stehule

26 July 2008

00:36 Re: PERSISTANT PREPARE (another point of view) chester c young
05:25 Test if a table is present Ole Ekerhovd
05:33 Re: Test if a table is present Anoop G
05:48 Re: Test if a table is present Volkan YAZICI
13:18 Efficiently determining the number of bits set in the contents of a VARBIT field Allan Kamau
20:22 Re: Select default values Giorgio Valoti

28 July 2008

00:08 Re: Efficiently determining the number of bits set in the contents of, a VARBIT field TJ O'Donnell
00:52 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
01:15 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
01:29 Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field Jean-David Beyer
03:36 Re: PERSISTANT PREPARE (another point of view) chester c young
06:48 Re: PERSISTANT PREPARE (another point of view) Pavel Stehule
13:27 Encrytion in postgres field in table Chris Preston
16:18 Accessing array datatype maria s
16:56 Re: Accessing array datatype Oliveiros Cristina
17:21 Re: Accessing array datatype Oliveiros Cristina
17:28 Re: Accessing array datatype maria s
18:26 Re: Encrytion in postgres field in table Andrej Ricnik-Bay
19:02 Re: Query prepared plan Emi Lu
21:30 Re: PERSISTANT PREPARE (another point of view) Milan Oparnica
23:08 Re: Query prepared plan Alvaro Herrera

29 July 2008

04:25 Re: Encrytion in postgres field in table Lennin Caro
13:39 Re: Query prepared plan Emi Lu
16:07 column names with - and ( maria s
16:27 Re: column names with - and ( Oliveiros Cristina
16:35 Re: column names with - and ( maria s
16:37 Re: column names with - and ( Oliveiros Cristina
16:39 Re: column names with - and ( maria s
18:32 Identifying which column matches a full text search Ryan Wallace
19:14 Re: column names with - and ( Igor Neyman
21:29 Re: Identifying which column matches a full text search Richard Huxton

30 July 2008

15:09 Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date Emi Lu
15:22 Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date Milen A. Radev
15:23 Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date Pavel Stehule
15:24 Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date Bricklen Anderson
15:32 order function in aggregate Michael Toews
15:32 Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date Emi Lu
17:28 Re: order function in aggregate Richard Huxton
17:45 Re: order function in aggregate Tom Lane
17:53 Re: Identifying which column matches a full text search Ryan Wallace
18:33 Re: Identifying which column matches a full text search Richard Huxton

31 July 2008

13:03 Function returning setof taking parameters from another table Marcin Stępnicki
22:51 Re: Problem with ORDER BY and DISTINCT ON Tom Lane