Home > mailing lists

Mailing lists [pgsql-performance]

1 January 2007

14:04 Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik
14:14 Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik
14:19 Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik
22:30 Re: Worse perfomance on 8.2.0 than on 7.4.14 Tom Lane

2 January 2007

00:29 glibc double-free error Craig A. James
00:40 Re: glibc double-free error Tom Lane
05:02 Re: glibc double-free error Craig A. James
05:11 Re: glibc double-free error Tom Lane
08:55 what work_mem needs a query needs? Arnau
11:45 Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik
13:35 Re: High update activity, PostgreSQL vs BigDBMS Geoffrey
13:50 Re: High update activity, PostgreSQL vs BigDBMS Ragnar
13:55 Re: High update activity, PostgreSQL vs BigDBMS Lars Heidieker
14:01 Re: High update activity, PostgreSQL vs BigDBMS Jeremy Haile
14:07 Re: Worse perfomance on 8.2.0 than on 7.4.14 Tom Lane
15:24 Config parameters Jeremy Haile
15:34 Re: Config parameters Richard Huxton
15:42 Slow dump? Erik Jones
16:08 Re: Config parameters Jeremy Haile
16:30 Re: Slow dump? Tom Lane
16:40 Re: Slow dump? Erik Jones
17:37 Re: High update activity, PostgreSQL vs BigDBMS Jeff Davis
17:52 Re: Config parameters Richard Huxton
18:22 Re: Config parameters Jeremy Haile
18:51 Re: Config parameters Scott Marlowe
19:04 Re: Config parameters Jeremy Haile
20:59 More 8.2 client issues (Was: [Slow dump?) Erik Jones
21:06 Re: More 8.2 client issues (Was: [Slow dump?) Richard Huxton
21:17 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
22:09 Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane

3 January 2007

07:01 Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik
14:31 Re: Worse perfomance on 8.2.0 than on 7.4.14 Tom Lane
15:13 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
15:24 Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane
15:41 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
15:50 Re: More 8.2 client issues (Was: [Slow dump?) Guillaume Smet
15:56 Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane
16:10 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
16:16 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
16:21 Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane
16:27 Performance of PostgreSQL on Windows vs Linux Jeremy Haile
16:58 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
17:26 Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane
17:59 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
22:18 Re: Performance of PostgreSQL on Windows vs Linux Magnus Hagander
22:46 Re: Performance of PostgreSQL on Windows vs Linux Dimitri Fontaine

4 January 2007

02:10 Trivial function query optimized badly Craig A. James
03:17 Re: Trivial function query optimized badly Adam Rich
04:41 Re: Trivial function query optimized badly Craig A. James
04:46 Re: Trivial function query optimized badly Tom Lane
05:56 Re: Trivial function query optimized badly Craig A. James
13:31 Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile
13:50 Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile
14:24 Re: Performance of PostgreSQL on Windows vs Linux Tom Lane
14:32 Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile
17:00 PostgreSQL to host e-mail? Charles A. Landemaine
17:04 PostgreSQL to host e-mail? Charles A. Landemaine
17:12 Re: PostgreSQL to host e-mail? Joshua D. Drake
17:33 Re: PostgreSQL to host e-mail? Frank Wiles
17:42 Re: PostgreSQL to host e-mail? Matthew Schumacher
23:31 Slow Query on Postgres 8.2 Dave Dutcher

5 January 2007

00:12 Re: Slow Query on Postgres 8.2 Tom Lane
00:18 Re: Slow Query on Postgres 8.2 Adam Rich
00:51 Re: Slow Query on Postgres 8.2 Dave Dutcher
01:01 Re: Slow Query on Postgres 8.2 Dave Dutcher
02:04 Re: Slow Query on Postgres 8.2 Tom Lane
02:42 Re: PostgreSQL to host e-mail? Grega Bremec
10:02 Partitioning Arnau
10:46 Re: Partitioning Mikael Carneholm
17:02 Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones
17:36 Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik
17:42 Re: PostgreSQL to host e-mail? Reid Thompson

6 January 2007

01:51 Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier
02:13 Re: High update activity, PostgreSQL vs BigDBMS Craig A. James
03:05 Re: High update activity, PostgreSQL vs BigDBMS Dave Cramer
09:18 Re: Worse perfomance on 8.2.0 than on 7.4.14 Simon Riggs
18:26 Missing the point of autovacuum Daryl Herzmann
18:33 Re: Missing the point of autovacuum Tobias Brox
18:46 Re: Missing the point of autovacuum Tom Lane

7 January 2007

03:23 Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier
03:33 Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier
03:37 table partioning performance Colin Taylor
03:56 Re: High update activity, PostgreSQL vs BigDBMS Joshua D. Drake
06:22 Re: High update activity, PostgreSQL vs BigDBMS Craig A. James
08:04 Re: High update activity, PostgreSQL vs BigDBMS Shane Ambler
14:29 Re: High update activity, PostgreSQL vs BigDBMS Dave Cramer
18:05 tweaking under repeatable load Ben
22:55 Re: High update activity, PostgreSQL vs BigDBMS Craig A. James

8 January 2007

01:25 Re: High update activity, PostgreSQL vs BigDBMS Adam Rich
01:48 Re: High update activity, PostgreSQL vs BigDBMS Tom Lane
02:10 Re: High update activity, PostgreSQL vs BigDBMS Joshua D. Drake
03:27 Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier
03:58 Re: High update activity, PostgreSQL vs BigDBMS Adam Rich
04:12 Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier
04:52 Re: High update activity, PostgreSQL vs BigDBMS Adam Rich
08:18 Re: tweaking under repeatable load Dimitri Fontaine
14:39 Re: table partioning performance Luke Lonergan
17:09 Re: High update activity, PostgreSQL vs BigDBMS Bruce Momjian
17:59 Re: Slow Query on Postgres 8.2 Dave Dutcher
19:02 Re: table partioning performance Steven Flatt
23:35 Re: table partioning performance Merlin Moncure

9 January 2007

10:54 Horribly slow query/ sequential scan Gregory S. Williamson
11:33 Re: High update activity, PostgreSQL vs BigDBMS Jim C. Nasby
11:41 Re: Horribly slow query/ sequential scan db@zigo.dhs.org
11:50 Re: table partioning performance Simon Riggs
11:54 Re: High update activity, PostgreSQL vs BigDBMS Jim C. Nasby
11:55 Re: Horribly slow query/ sequential scan Gregory S. Williamson
11:56 Re: Horribly slow query/ sequential scan Nörder-Tuitje, Marcus
11:58 Re: Horribly slow query/ sequential scan Gregory S. Williamson
13:10 Running PG on cluster files systems Hannes Dorbath
13:15 Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik
13:17 Re: Running PG on cluster files systems Devrim GUNDUZ
13:18 Re: Horribly slow query/ sequential scan Dave Cramer
14:13 Re: Horribly slow query/ sequential scan Tom Lane
14:52 Re: Horribly slow query/ sequential scan Plugge, Joe R.
15:45 Re: Postgresql Configutation and overflow Jim C. Nasby
16:11 Re: High update activity, PostgreSQL vs BigDBMS Jeff Frost
16:30 High inserts, bulk deletes - autovacuum vs scheduled vacuum Jeremy Haile
17:02 Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Florian Weimer
19:18 Re: High inserts, bulk deletes - autovacuum vs scheduled Jeremy Haile
22:05 group by will not use an index? tsuraan
22:32 Re: group by will not use an index? Adam Rich
22:39 Re: Horribly slow query/ sequential scan Gregory S. Williamson
22:42 Re: group by will not use an index? Scott Marlowe

10 January 2007

00:07 Re: group by will not use an index? Brian Herlihy
00:10 Re: group by will not use an index? Steinar H. Gunderson
01:14 Re: group by will not use an index? Andrew Lazarus
04:56 Re: Horribly slow query/ sequential scan Tom Lane
09:08 Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Florian Weimer
13:54 Re: Horribly slow query/ sequential scan Tom Lane
15:22 Slow inner join, but left join is fast Jeremy Haile
16:14 Re: group by will not use an index? tsuraan
16:16 Re: Slow inner join, but left join is fast Tom Lane
17:24 Re: Slow inner join, but left join is fast Jeremy Haile
17:38 Re: Slow inner join, but left join is fast Tom Lane
17:42 Re: Slow inner join, but left join is fast Jeremy Haile
17:48 Re: Slow inner join, but left join is fast Jeremy Haile
18:22 Re: Slow inner join, but left join is fast Tom Lane
18:30 Re: Slow inner join, but left join is fast Jeremy Haile
19:01 Re: performance implications of binary placement Jim C. Nasby
19:08 Re: More 8.2 client issues (Was: [Slow dump?) Jim C. Nasby
19:15 Re: Performance of PostgreSQL on Windows vs Linux Jim C. Nasby
19:18 Re: PostgreSQL to host e-mail? Jim C. Nasby
19:20 Re: Partitioning Jim C. Nasby
19:25 Re: table partioning performance Jim C. Nasby
19:27 Re: High update activity, PostgreSQL vs BigDBMS Jim C. Nasby
19:31 Re: Partitioning Erik Jones
19:32 Re: Partitioning Jeremy Haile
19:34 Re: High update activity, PostgreSQL vs BigDBMS Jeff Frost
19:36 Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile
19:36 Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby
19:45 Re: Performance of PostgreSQL on Windows vs Linux Scott Marlowe
20:00 Re: table partioning performance Steven Flatt
20:09 Re: Partitioning Jim C. Nasby
20:21 Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby
20:30 Re: Partitioning Scott Marlowe
20:37 Re: Partitioning Jeremy Haile
20:39 Re: table partioning performance Steven Flatt
20:52 Re: Partitioning Scott Marlowe
20:52 Re: High inserts, bulk deletes - autovacuum vs scheduled Jeremy Haile
23:56 UNSUBSCRIBE

11 January 2007

00:24 Re: table partioning performance Jim C. Nasby
00:27 Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby
02:11 Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Alvaro Herrera
02:42 Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby
09:56 Does it matters the column order in indexes and constraints creation? Arnau
10:29 Re: Does it matters the column order in indexes and constraints Richard Huxton
11:17 Re: table partioning performance Simon Riggs
11:51 Re: Partitioning Bernd Helmle
11:59 Re: Partitioning Mikael Carneholm
13:06 Re: Partitioning Jeremy Haile
13:17 Re: Partitioning Adam Rich
13:33 Re: Partitioning Bernd Helmle
16:47 unusual performance for vac following 8.2 upgrade Kim
17:07 Re: unusual performance for vac following 8.2 upgrade Russell Smith
17:17 Improving SQL performance Carlos H. Reimer
17:17 Re: unusual performance for vac following 8.2 upgrade Tom Lane
17:21 Re: unusual performance for vac following 8.2 upgrade Tom Lane
17:28 Re: Improving SQL performance Russell Smith
17:31 Re: Improving SQL performance Tom Lane
18:14 Re: unusual performance for vac following 8.2 upgrade Kim
18:45 Re: unusual performance for vac following 8.2 upgrade Tom Lane
18:49 Re: [HACKERS] unusual performance for vac following 8.2 upgrade Alvaro Herrera
19:41 Re: unusual performance for vac following 8.2 upgrade Simon Riggs
20:01 Re: [HACKERS] table partioning performance Jim C. Nasby
20:11 Re: [HACKERS] unusual performance for vac following 8.2 upgrade Tom Lane
20:15 RES: Improving SQL performance Carlos H. Reimer
20:16 Re: [HACKERS] unusual performance for vac following 8.2 upgrade Jim C. Nasby
20:52 Re: unusual performance for vac following 8.2 upgrade Kim
21:27 Re: unusual performance for vac following 8.2 upgrade Tom Lane
22:10 Re: [HACKERS] unusual performance for vac following 8.2 upgrade Tom Lane
22:12 Re: unusual performance for vac following 8.2 upgrade Kim
22:16 Re: [HACKERS] unusual performance for vac following 8.2upgrade Simon Riggs
22:48 Re: RES: Improving SQL performance Cesar Suga

12 January 2007

00:09 Re: [HACKERS] unusual performance for vac following 8.2upgrade Alvaro Herrera
01:51 Re: [HACKERS] unusual performance for vac following 8.2upgrade Tom Lane
07:16 Planner statistics, correlations Tobias Brox
07:57 Re: Planner statistics, correlations Peter Childs
08:07 Re: Planner statistics, correlations Tobias Brox
08:11 Re: [HACKERS] unusual performance for vac following 8.2upgrade Richard Huxton
08:24 Re: Planner statistics, correlations Richard Huxton
08:57 Re: Planner statistics, correlations Tobias Brox
09:41 Re: Planner statistics, correlations Heikki Linnakangas
09:44 Re: Planner statistics, correlations Tobias Brox
09:56 Re: Planner statistics, correlations Heikki Linnakangas
10:40 Partitioning Gauri Kanekar
16:37 RES: Improving SQL performance Carlos H. Reimer
18:52 Re: [HACKERS] table partioning performance Simon Riggs
23:31 Large table performance Mark Dobbrow
23:40 Re: Large table performance Dave Cramer

13 January 2007

00:34 Re: Large table performance Steinar H. Gunderson
08:21 Physical separation of tables and indexes - where pg_xlog should go? Ireneusz Pluta
14:55 Re: Large table performance Daniel Cristian Cruz
22:38 Performance of Parser? Jignesh Shah
23:24 Re: Performance of Parser? Tom Lane

14 January 2007

01:40 Re: Large table performance Dave Dutcher
02:09 Re: Performance of Parser? Dave Cramer
10:47 Re: Large table performance Shoaib Mir
11:31 Rolf Østvik (HA/EXA)
11:44 Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) Rolf Østvik (HA/EXA)
12:46 Re: Dave Cramer
14:34 Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) Rolf Østvik (HA/EXA)
15:12 Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) Dave Dutcher
15:52 Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) Dave Cramer
18:02 Re: Large table performance Luke Lonergan
18:20 Re: Large table performance Luke Lonergan

15 January 2007

03:51 Re: max() versus order/limit (WAS: High update activity, PostgreSQL vs BigDBMS) Adam Rich
06:41 Re: max() versus order/limit (WAS: High update Luke Lonergan
07:58 Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) Rolf Østvik (HA/EXA)
09:16 pg_trgm performance Florian Weimer
09:36 Re: max() versus order/limit (WAS: High update activity, PostgreSQL vs BigDBMS) Alvaro Herrera
09:38 Re: max() versus order/limit (WAS: High update Alvaro Herrera
11:58 Re: pg_trgm performance Steinar H. Gunderson
14:54 Re: max() versus order/limit (WAS: High update Joshua D. Drake
16:56 FiberChannel cards for FreeBSD on AMD64 Andrew Hammond

16 January 2007

07:43 Caching in PostgreSQL
08:34 Re: Caching in PostgreSQL Heikki Linnakangas
08:43 Re: Caching in PostgreSQL
09:13 Re: Caching in PostgreSQL Heikki Linnakangas
09:29 Re: Caching in PostgreSQL David Levy
12:48 Table Size Gauri Kanekar
16:04 Re: Caching in PostgreSQL Chris Browne
18:24 Re: Table Size Richard Huxton
20:23 PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
20:39 Re: PG8.2.1 choosing slow seqscan over idx scan Tom Lane
21:21 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
21:45 Re: PG8.2.1 choosing slow seqscan over idx scan Chad Wagner

17 January 2007

02:01 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
03:53 Re: PG8.2.1 choosing slow seqscan over idx scan Chad Wagner
04:47 Re: PG8.2.1 choosing slow seqscan over idx scan Scott Marlowe
05:37 Re: Table Size Guillaume Lelarge
09:43 Table Inheritence and Partioning
10:04 Re: Table Inheritence and Partioning Albert Cervera Areny
13:38 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
13:53 Re: PG8.2.1 choosing slow seqscan over idx scan Shoaib Mir
14:12 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
14:14 Re: PG8.2.1 choosing slow seqscan over idx scan Dave Cramer
14:23 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
14:57 Raid 10 or Raid 5 on Dell PowerEdge Dave Dutcher
15:19 Re: PG8.2.1 choosing slow seqscan over idx scan Scott Marlowe
15:28 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
15:56 Re: [HACKERS] unusual performance for vac following 8.2 Kim
16:27 Re: PG8.2.1 choosing slow seqscan over idx scan Chad Wagner
16:29 Monitoring Transaction Log size Ziegelwanger, Silvio
16:54 Re: Monitoring Transaction Log size Joshua D. Drake
17:04 Re: Monitoring Transaction Log size Shoaib Mir
17:30 Re: Monitoring Transaction Log size Stefan Kaltenbrunner
17:35 Re: PG8.2.1 choosing slow seqscan over idx scan Scott Marlowe
17:47 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
17:55 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
18:23 Re: PG8.2.1 choosing slow seqscan over idx scan Tomas Vondra
18:35 Re: PG8.2.1 choosing slow seqscan over idx scan Tomas Vondra
18:39 Re: PG8.2.1 choosing slow seqscan over idx scan Jeremy Haile
19:59 Configuration Advice Steve
20:24 Re: Configuration Advice Adam Rich
20:29 Re: Configuration Advice Bricklen Anderson
20:33 Re: Configuration Advice Tomas Vondra
20:40 Re: Configuration Advice Chad Wagner
20:41 Re: Configuration Advice Heikki Linnakangas
20:54 Re: Configuration Advice Steve
20:56 Re: Configuration Advice Steve
21:07 Re: Configuration Advice Benjamin Minshall
21:12 Re: Configuration Advice Joshua D. Drake
21:12 Re: Configuration Advice Bruno Wolff III
21:16 DB benchmark and pg config file help Kevin Hunter
21:39 Re: Monitoring Transaction Log size Tom Lane
22:14 Re: Configuration Advice Scott Marlowe
22:32 Re: Configuration Advice Steve
22:37 Re: Configuration Advice Adam Rich
22:43 Re: Configuration Advice Dave Cramer
22:53 Re: Configuration Advice Steve
22:57 Re: Configuration Advice Steve
23:02 Re: Configuration Advice Chad Wagner
23:04 Re: Configuration Advice Chris Browne
23:25 Re: Configuration Advice Steve
23:30 Re: Configuration Advice Steve
23:48 Re: Configuration Advice Steve

18 January 2007

03:43 Version Change Gauri Kanekar
03:57 Re: Version Change Michael Glaesemann
04:00 Re: Version Change Michael Glaesemann
04:35 Re: Version Change Michael Glaesemann
08:57 Re: Monitoring Transaction Log size Simon Riggs
09:19 Re: Monitoring Transaction Log size Shoaib Mir
09:52 Re: Configuration Advice Arjen van der Meijden
12:24 Vacuum v/s Autovacuum Gauri Kanekar
12:31 Re: Vacuum v/s Autovacuum Michael Glaesemann
12:46 Re: Vacuum v/s Autovacuum Gauri Kanekar
13:05 Re: Vacuum v/s Autovacuum Bill Moran
13:14 Re: Vacuum v/s Autovacuum Shoaib Mir
14:38 Re: Configuration Advice Scott Marlowe
15:21 Re: Configuration Advice Scott Marlowe
15:42 Re: Configuration Advice Arjen van der Meijden
16:28 Re: Configuration Advice Jeremy Haile
17:37 Autoanalyze settings with zero scale factor Jeremy Haile
18:20 Re: Autoanalyze settings with zero scale factor Matthew T. O'Connor
19:21 Re: Autoanalyze settings with zero scale factor Jeremy Haile
19:31 Postgres and really huge tables Brian Hurt
19:37 Re: [pgsql-advocacy] Postgres and really huge tables Joshua D. Drake
19:40 Re: Autoanalyze settings with zero scale factor Matthew T. O'Connor
20:04 Re: Postgres and really huge tables Scott Marlowe
20:10 Re: Configuration Advice Arjen van der Meijden
20:30 Re: Autoanalyze settings with zero scale factor Tom Lane
20:43 Re: [pgsql-advocacy] Postgres and really huge tables Chris Mair
20:53 Re: Postgres and really huge tables Tom Lane
20:53 Re: Autoanalyze settings with zero scale factor Jeremy Haile
21:11 Re: Configuration Advice Tom Lane
21:42 Re: [pgsql-advocacy] Postgres and really huge tables Luke Lonergan
22:10 Re: Postgres and really huge tables Gavin Sherry

19 January 2007

05:15 Re: Configuration Advice Arjen van der Meijden
09:03 Re: [pgsql-advocacy] Postgres and really huge tables Oleg Bartunov
12:46 Re: DB benchmark and pg config file help Merlin Moncure
13:06 Re: DB benchmark and pg config file help Kevin Hunter
13:11 Re: Postgres and really huge tables Merlin Moncure
15:52 Re: DB benchmark and pg config file help Bruno Wolff III
18:16 Re: Configuration Advice Merlin Moncure
20:41 Re: DB benchmark and pg config file help Kevin Hunter
23:01 Re: [pgsql-advocacy] Postgres and really huge tables Josh Berkus

22 January 2007

08:42 Re: Table Inheritence and Partioning Simon Riggs

23 January 2007

09:35 slow result Laurent Manchon
09:44 Re: slow result Heiko W.Rupp
09:53 Re: slow result A. Kretschmer
09:55 Re: slow result Steinar H. Gunderson
09:58 Re: slow result Steinar H. Gunderson
11:35 slow result Laurent Manchon
11:43 Re: slow result A. Kretschmer
11:49 extract(field from timestamp) vs date dimension Tobias Brox
12:24 Re: extract(field from timestamp) vs date dimension Chad Wagner
12:35 Re: extract(field from timestamp) vs date dimension Tobias Brox
12:53 Re: slow result Bill Moran
13:43 Re: slow result Ron
15:11 Postgres processes have a burst of CPU usage Subramaniam Aiylam
15:23 Re: extract(field from timestamp) vs date dimension Merlin Moncure
17:00 Re: slow result Bruno Wolff III
21:08 Bad Row Count Estimate on View with 8.2 Dave Dutcher
23:52 Re: slow result Mark Kirkwood

24 January 2007

02:21 Re: extract(field from timestamp) vs date dimension Mark Kirkwood
04:38 how to plan for vacuum? Galy Lee
06:44 Re: Bad Row Count Estimate on View with 8.2 Tom Lane
06:45 Re: how to plan for vacuum? Galy Lee
07:49 Auto Vacuum Problem Gauri Kanekar
07:49 Re: Postgres processes have a burst of CPU usage Richard Huxton
07:54 Re: Auto Vacuum Problem Richard Huxton
08:14 Re: Auto Vacuum Problem Heiko W.Rupp
09:19 Re: slow result Shoaib Mir

25 January 2007

02:39 Re: how to plan for vacuum? Jim C. Nasby
02:52 Re: how to plan for vacuum? Alvaro Herrera
02:57 Re: [HACKERS] how to plan for vacuum? Jim C. Nasby
09:29 Re: how to plan for vacuum? Galy Lee
12:47 Re: how to plan for vacuum? Ray Stell
14:54 Re: how to plan for vacuum? Jim C. Nasby
15:02 Re: [HACKERS] how to plan for vacuum? Joshua D. Drake
15:33 Re: [HACKERS] how to plan for vacuum? Ray Stell

26 January 2007

10:28 Tuning John Parnefjord
13:07 Re: Tuning Dave Cramer
15:22 Re: Tuning Anton Rommerskirchen
20:08 Re: [HACKERS] how to plan for vacuum? Jim Nasby

27 January 2007

02:14 Seqscan/Indexscan still a known issue? Carlos Moreno
06:26 Re: Seqscan/Indexscan still a known issue? Dennis Bjorklund
06:35 Re: Seqscan/Indexscan still a known issue? Russell Smith
07:38 Re: Seqscan/Indexscan still a known issue? Guido Neitzer
08:54 Re: Seqscan/Indexscan still a known issue? Tomas Vondra
09:44 Re: Seqscan/Indexscan still a known issue? Russell Smith
10:34 Re: Seqscan/Indexscan still a known issue? Scott Marlowe
16:11 Re: Seqscan/Indexscan still a known issue? Carlos Moreno
16:28 Re: Seqscan/Indexscan still a known issue? Tom Lane
20:10 Re: Seqscan/Indexscan still a known issue? Carlos Moreno
22:35 IN operator causes sequential scan (vs. multiple OR expressions) Ryan Holmes
22:53 Re: IN operator causes sequential scan (vs. multiple OR expressions) Tom Lane

28 January 2007

00:34 Re: IN operator causes sequential scan (vs. multiple OR expressions) Ryan Holmes
00:56 Re: IN operator causes sequential scan (vs. multiple OR expressions) Tom Lane
01:32 Re: IN operator causes sequential scan (vs. multiple OR expressions) Ryan Holmes
16:09 Re: Bad Row Count Estimate on View with 8.2 Dave Dutcher
17:48 Re: Bad Row Count Estimate on View with 8.2 Tom Lane
19:18 work-mem Campbell, Lance
19:26 Re: work-mem imad
21:11 Re: work_mem Bill Moran
22:23 Re: Tuning Josh Berkus
22:38 Re: Tuning Tom Lane

29 January 2007

02:07 work-mem how do I identify the proper size Campbell, Lance
11:22 [OT] Very strange postgresql behaviour Arnau
12:27 Re: [OT] Very strange postgresql behaviour Bill Moran
12:36 Re: [OT] Very strange postgresql behaviour Heikki Linnakangas
13:54 Re: work-mem how do I identify the proper size Bill Moran
14:41 Re: [OT] Very strange postgresql behaviour Arnau
15:15 Re: Tuning Ron
15:22 int4 vs varchar to store ip addr Pomarede Nicolas
15:26 Re: int4 vs varchar to store ip addr Florian Weimer
16:21 Re: int4 vs varchar to store ip addr Cosimo Streppone
18:43 Re: [OT] Very strange postgresql behaviour Carlos Moreno
19:51 Thanks All! Saranya Sivakumar

30 January 2007

05:49 Partitioning Abu Mushayeed
06:10 Re: Partitioning Tomas Vondra
07:59 Querying distinct values from a large table Igor Lobanov
08:13 Re: Querying distinct values from a large table Richard Huxton
08:33 Re: Querying distinct values from a large table Igor Lobanov
08:36 Re: Querying distinct values from a large table Igor Lobanov
09:02 Re: Querying distinct values from a large table Richard Huxton
09:05 Re: Tuning John Parnefjord
09:21 Re: Partitioning Rigmor Ukuhe
09:54 Re: int4 vs varchar to store ip addr Pomarede Nicolas
10:39 Re: Querying distinct values from a large table imad
13:06 Re: Querying distinct values from a large table Simon Riggs
13:12 Re: Querying distinct values from a large table Richard Huxton
13:13 Re: Querying distinct values from a large table Chad Wagner
13:38 Re: Querying distinct values from a large table Brian Herlihy
13:54 Re: Bad Row Count Estimate on View with 8.2 Dave Dutcher
13:57 Re: Querying distinct values from a large table Luke Lonergan
14:03 Re: Querying distinct values from a large table Chad Wagner
15:34 Re: Querying distinct values from a large table Luke Lonergan
15:39 Re: Querying distinct values from a large table Gregory Stark
16:00 Re: Querying distinct values from a large table Bruno Wolff III
17:07 Re: Querying distinct values from a large table Alvaro Herrera
19:56 Re: Querying distinct values from a large table Luke Lonergan
20:00 Re: Querying distinct values from a large table Steinar H. Gunderson
20:09 Very slow queries Sidar López Cruz
20:19 Re: Very slow queries Sidar López Cruz
20:46 Re: Very slow queries Ted Allen
21:37 Re: Very slow queries Chad Wagner
21:57 Re: Querying distinct values from a large table Josh Berkus
22:07 Re: Querying distinct values from a large table Alvaro Herrera
22:18 Re: Querying distinct values from a large table Luke Lonergan

31 January 2007

04:55 Re: Querying distinct values from a large table Tom Lane
05:59 Re: Querying distinct values from a large table Luke Lonergan
12:25 Re: Querying distinct values from a large table Gregory Stark
13:19 Re: Very slow queries Sidar López Cruz
13:32 Re: Very slow queries Ted Allen
13:46 Re: Querying distinct values from a large table Ron
13:58 Re: Very slow queries Sidar López Cruz
14:16 Re: Querying distinct values from a large table Tom Lane
14:28 Re: Very slow queries Sidar López Cruz
23:57 Slow update Abu Mushayeed