Продукты

О компании

Ресурсы

Мероприятия

Образование

...

Протестировать

Архив рассылок [pgsql-performance]

АпрельИюнь

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 28 29 30 31

1 мая 2005 г.

20:23Re: BLOB's bypassing the OS Filesystem for better Image PFC

2 мая 2005 г.

10:52batch inserts are "slow" Tim Terlegård

12:10Re: batch inserts are "slow" Christopher Kings-Lynne

12:17Re: batch inserts are "slow" Christopher Petrilli

12:20Re: batch inserts are "slow" Tim Terlegård

12:27Re: batch inserts are "slow" Christopher Petrilli

12:30Re: batch inserts are "slow" Tom Lane

12:53Re: batch inserts are "slow" David Parker

13:14Citation for "Bad n_distinct estimation; hacks suggested?" Gurmeet Manku

14:04Re: batch inserts are "slow" Chris Browne

3 мая 2005 г.

10:08Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Markus Schaber

11:42Re: batch inserts are "slow" Markus Schaber

12:11Foreign key constraints compile faster in 7.4 Ashish Arte

12:41Re: batch inserts are "slow" Josh Berkus

12:55 Steven Rosenstein

12:57Re: batch inserts are "slow" Kris Jurka

13:00Re: Foreign key constraints compile faster in 7.4 Tom Lane

13:12Re: Tom Lane

14:29Testing list access Jona

14:37Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 2 Jona

14:44Re: batch inserts are "slow" Tim Terlegård

14:57Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1b Jona

15:30Re: batch inserts are "slow" Steve Wampler

15:53Re: COPY vs INSERT Mischa Sandberg

16:17Re: batch inserts are "slow" Christopher Petrilli

16:59Re: batch inserts are "slow" Dave Cramer

18:33Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Mischa Sandberg

18:42Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus

21:45Re: [HACKERS] Bad n_distinct estimation; hacks suggested? John A Meinel

21:51Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus

22:13Kernel Resources and max_connections Chris Hebrard

22:46Re: Kernel Resources and max_connections Mark Kirkwood

23:04Re: Kernel Resources and max_connections Chris Hebrard

23:40Kernel Resources Solved Chris Hebrard

23:52Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Mischa Sandberg

4 мая 2005 г.

01:07Re: Kernel Resources and max_connections Jim C. Nasby

02:17Re: Kernel Resources and max_connections Mark Kirkwood

08:09Re: Mike Rylander

11:58Table stats Mike G.

19:41Re: COPY vs INSERT David Roussel

20:11Re: COPY vs INSERT Mischa Sandberg

20:24Re: COPY vs INSERT John A Meinel

20:29Re: COPY vs INSERT Christopher Petrilli

20:33Re: COPY vs INSERT Kris Jurka

22:49Re: COPY vs INSERT Christopher Kings-Lynne

23:23Re: COPY vs INSERT Tom Lane

5 мая 2005 г.

01:41Re: COPY vs INSERT Mischa Sandberg

06:15Re: COPY vs INSERT Kris Jurka

06:48Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1 Jona

13:02Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1 Tom Lane

20:59Re: Table stats David Roussel

21:53Re: COPY vs INSERT Keith Worthington

6 мая 2005 г.

03:51Re: COPY vs INSERT Jim C. Nasby

04:25Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona

04:30Re: COPY vs INSERT Dennis Bjorklund

04:31Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona

05:37Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Christopher Kings-Lynne

06:28Re: COPY vs INSERT Harald Fuchs

08:12Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona

09:18Re: COPY vs INSERT Bruno Wolff III

10:52Re: COPY vs INSERT Tom Lane

10:59Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Tom Lane

17:35Re: [SQL] ORDER BY Optimization Rosser Schwarz

17:59Re: [SQL] ORDER BY Optimization Derek Buttineau|Compu-SOLVE

18:39Whence the Opterons? Mischa Sandberg

19:09Re: Whence the Opterons? Ian Meyer

19:30Re: Whence the Opterons? Steve Poe

19:44Re: Whence the Opterons? Gavin M. Roy

7 мая 2005 г.

08:56Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona

11:57Re: Whence the Opterons? Andrew Sullivan

15:04Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Tom Lane

18:00Re: Whence the Opterons? Josh Berkus

19:56Re: [SQL] ORDER BY Optimization Tom Lane

8 мая 2005 г.

08:06Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona

09:59sequence scan on PK Jeroen van Iddekinge

10:44Re: sequence scan on PK John A Meinel

12:49Re: sequence scan on PK Jeroen van Iddekinge

13:19Re: sequence scan on PK Matteo Beccati

13:24Re: sequence scan on PK John A Meinel

13:32Re: sequence scan on PK Jeroen van Iddekinge

13:49Re: sequence scan on PK Tom Lane

14:05Re: sequence scan on PK Matteo Beccati

14:12Re: COPY vs INSERT Jim C. Nasby

15:15Re: sequence scan on PK Jeroen van Iddekinge

18:59Re: Whence the Opterons? Sam Vilain

19:33Re: Whence the Opterons? Mischa Sandberg

20:20Query tuning help Dan Harris

21:48Re: Query tuning help Josh Berkus

21:51Re: Query tuning help Russell Smith

21:58Re: Query tuning help Tom Lane

22:49Re: Query tuning help Dan Harris

23:06Re: Query tuning help Josh Berkus

23:17Re: Whence the Opterons? Geoffrey

23:29Re: Query tuning help Tom Lane

23:31Re: Query tuning help Dan Harris

23:32Re: Query tuning help Russell Smith

23:49Re: Query tuning help Dan Harris

9 мая 2005 г.

01:14Re: Query tuning help Klint Gore

02:49Re: sequence scan on PK Grega Bremec

08:42Re: Query tuning help Harald Fuchs

10:40"Hash index" vs. "b-tree index" (PostgreSQL 8.0) Ying Lu

11:37Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL 8.0) Neil Conway

12:06Re: Whence the Opterons? Anjan Dave

12:18Re: Whence the Opterons? John A Meinel

12:22Re: Whence the Opterons? John A Meinel

12:28Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL 8.0) Christopher Petrilli

12:30Re: Whence the Opterons? Anjan Dave

12:35Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway

12:40Re: Whence the Opterons? John A Meinel

13:34Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby

13:39Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway

13:51Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby

14:10Re: Whence the Opterons? Jeff Frost

14:23Re: Whence the Opterons? William Yu

14:32Re: Query tuning help Mischa Sandberg

15:10Re: ORDER BY Optimization Derek Buttineau|Compu-SOLVE

16:23PGSQL Capacity bouchia.nazha@free.fr

16:41Re: PGSQL Capacity John A Meinel

16:55Re: PGSQL Capacity Dave Held

17:01Re: Whence the Opterons? Geoffrey

17:10Re: Whence the Opterons? Anjan Dave

17:35Re: PGSQL Capacity Steinar H. Gunderson

17:55Configing 8 gig box. Joel Fradkin

19:04Re: PGSQL Capacity Chris Browne

19:39Re: "Hash index" vs. "b-tree index" (PostgreSQL 8.0) David Roussel

21:14Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway

23:20Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Bruce Momjian

10 мая 2005 г.

00:04Re: Whence the Opterons? Andrew Rawnsley

01:11Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

01:25Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway

01:55Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

02:30Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway

03:12Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark

06:03full outer performance problem Kim Bisgaard

07:03Partitioning / Clustering Alex Stapleton

10:52Prefetch Matt Olson

10:53Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

11:16Re: Prefetch Tom Lane

11:29Re: full outer performance problem John A Meinel

11:41Re: Partitioning / Clustering John A Meinel

11:47Re: full outer performance problem Tom Lane

12:03Re: Partitioning / Clustering Adam Haberlach

12:05Re: Prefetch Rod Taylor

12:10Re: Partitioning / Clustering Alex Stapleton

12:24Re: Partitioning / Clustering Alex Stapleton

12:32Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby

12:39Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby

12:45Re: Partitioning / Clustering Richard_D_Levine@raytheon.com

12:47Re: Partitioning / Clustering John A Meinel

12:50Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

14:26Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby

14:31Re: Partitioning / Clustering PFC

14:36Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark

14:46Re: Partitioning / Clustering Josh Berkus

15:07Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

15:12Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg

15:13Re: Prefetch Greg Stark

15:28RE: Partitioning / Clustering

15:36Re: Prefetch Matt Olson

15:54Re: Prefetch Tom Lane

16:17Prefetch - OffTopic Mohan, Ross

16:50Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

17:49Re: Partitioning / Clustering Mischa Sandberg

18:04Re: Prefetch - OffTopic Chris Browne

18:29Re: Prefetch - OffTopic Mohan, Ross

18:36Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg

18:40Re: PGSQL Capacity Jim C. Nasby

18:45Re: Configing 8 gig box. Jim C. Nasby

18:50Re: Partitioning / Clustering Jim C. Nasby

18:55Re: Partitioning / Clustering Mischa Sandberg

19:16Re: Partitioning / Clustering Jim C. Nasby

19:47Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mark Lewis

19:56Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

20:24Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg

20:56Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark

22:23Re: Partitioning / Clustering Christopher Kings-Lynne

22:34Re: Partitioning / Clustering Mischa Sandberg

22:48Re: Partitioning / Clustering Joshua D. Drake

22:58Re: Partitioning / Clustering Christopher Kings-Lynne

23:06Re: Partitioning / Clustering Mischa Sandberg

23:18Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

23:19Re: Partitioning / Clustering Mischa Sandberg

23:49Re: Partitioning / Clustering Neil Conway

11 мая 2005 г.

00:11Re: Partitioning / Clustering Joshua D. Drake

00:52Re: Partitioning / Clustering Bruno Wolff III

01:10Re: Configing 8 gig box. Tom Lane

01:34Re: Prefetch Sam Vilain

01:39Re: Partitioning / Clustering Neil Conway

01:44Re: Partitioning / Clustering Josh Berkus

01:52Re: Prefetch Christopher Kings-Lynne

04:20Re: Partitioning / Clustering Simon Riggs

04:55Re: Partitioning / Clustering Neil Conway

04:58Re: Partitioning / Clustering David Roussel

05:35Optimizer wrongly picks Nested Loop Left Join Edin Kadribasic

05:40Re: Partitioning / Clustering Alex Stapleton

05:50Re: Partitioning / Clustering Alex Stapleton

06:04Re: Partitioning / Clustering Alex Stapleton

06:12Re: Partitioning / Clustering Christopher Kings-Lynne

09:46Re: Query tuning help Ulrich Wisser

10:28Re: Partitioning / Clustering Tom Lane

10:46Re: Prefetch Rod Taylor

10:57Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane

10:59Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark

11:09Re: Optimizer wrongly picks Nested Loop Left Join John A Meinel

11:15Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway

11:18Re: Optimizer wrongly picks Nested Loop Left Join Tom Lane

11:23Re: Prefetch Bricklen Anderson

12:04Re: Optimizer wrongly picks Nested Loop Left Join Tom Lane

12:56Re: Sort and index Manfred Koizar

14:12Re: Partitioning / Clustering Josh Berkus

14:23Bad plan after vacuum analyze Guillaume Smet

15:09Re: Bad plan after vacuum analyze Josh Berkus

15:59Re: Bad plan after vacuum analyze Tom Lane

16:07Re: Prefetch Mischa Sandberg

16:32Re: Bad plan after vacuum analyze Guillaume Smet

16:38Re: Bad plan after vacuum analyze Tom Lane

16:57Re: Bad plan after vacuum analyze Guillaume Smet

17:02Re: Partitioning / Clustering Greg Stark

17:26Re: Partitioning / Clustering Simon Riggs

17:32Re: Bad plan after vacuum analyze Tom Lane

18:02Re: Bad plan after vacuum analyze Guillaume Smet

18:15Re: Sort and index Jim C. Nasby

18:21Federated PG servers -- Was: Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg

18:27Re: Bad plan after vacuum analyze Mischa Sandberg

18:28Re: Partitioning / Clustering Jim C. Nasby

19:35Re: Partitioning / Clustering PFC

20:25Re: Optimizer wrongly picks Nested Loop Left Join Edin Kadribasic

20:26Re: BLOB's bypassing the OS Filesystem for better Image loading speed? Enrico Weigelt

23:26Re: Intel SRCS16 SATA raid? Bruce Momjian

12 мая 2005 г.

05:48Re: Partitioning / Clustering Alex Stapleton

06:07AND OR combination: index not being used David Teran

07:03Re: BLOB's bypassing the OS Filesystem for better Image loading speed? PFC

07:09Re: Partitioning / Clustering PFC

07:34tuning Postgres for large data import (using Copy from) Marc Mamin

11:08Re: Partitioning / Clustering Alex Turner

11:15Re: AND OR combination: index not being used Tom Lane

11:31Re: tuning Postgres for large data import (using Copy from) Tom Lane

11:53Re: tuning Postgres for large data import (using Copy from) John A Meinel

12:17Re: Partitioning / Clustering Alex Stapleton

13:05Re: Partitioning / Clustering Alex Turner

13:22Re: Partitioning / Clustering John A Meinel

13:27Re: Partitioning / Clustering PFC

14:25Re: tuning Postgres for large data import (using Copy from) Josh Berkus

14:33Re: Partitioning / Clustering Josh Berkus

14:45Re: Partitioning / Clustering Alex Stapleton

15:50Re: Partitioning / Clustering Josh Berkus

15:51Re: Sort and index Manfred Koizar

19:31Optimize complex join to use where condition before join Sebastian Hennebrueder

19:38Re: AND OR combination: index not being used David Teran

23:13Re: Optimize complex join to use where condition before Sebastian Hennebrueder

23:44Re: Optimize complex join to use where condition before Sebastian Hennebrueder

23:52Recommendations for set statistics Sebastian Hennebrueder

13 мая 2005 г.

00:36Re: Recommendations for set statistics John A Meinel

01:50Re: Recommendations for set statistics Christopher Browne

02:57Re: Optimize complex join to use where condition before Greg Stark

09:52PostgreSQL strugling during high load Mindaugas Riauba

10:00Re: PostgreSQL strugling during high load Steinar H. Gunderson

10:43Re: PostgreSQL strugling during high load Tom Lane

11:10Re: PostgreSQL strugling during high load Mindaugas Riauba

11:12Re: PostgreSQL strugling during high load Tom Lane

11:45Re: PostgreSQL strugling during high load Mindaugas Riauba

12:23Re: PostgreSQL strugling during high load Cosimo Streppone

12:41Re: PostgreSQL strugling during high load Mindaugas Riauba

13:12Re: PostgreSQL strugling during high load Steinar H. Gunderson

13:22Re: Recommendations for set statistics Josh Berkus

13:42Re: PostgreSQL strugling during high load Tom Lane

14:33Re: PostgreSQL strugling during high load Mischa Sandberg

15:33Re: Optimize complex join to use where condition before John A Meinel

15:35Re: Bad plan after vacuum analyze Markus Bertheau

16:27ok you all win what is best opteron (I dont want a hosed system again) Joel Fradkin

16:56Re: ok you all win what is best opteron (I dont want a hosed system again) Merlin Moncure

18:07Re: Whence the Opterons? Andrew Sullivan

18:22Re: Whence the Opterons? Magnus Hagander

19:05Re: Optimize complex join to use where condition before Sebastian Hennebrueder

19:15Re: Optimize complex join to use where condition before John Arbash Meinel

21:02Re: ok you all win what is best opteron (I dont want a David Brown

21:17Postgresql Performance via the LSI MegaRAID 2x Card Steve Poe

21:27Re: Postgresql Performance via the LSI MegaRAID 2x Card Josh Berkus

14 мая 2005 г.

10:00Re: Partitioning / Clustering PFC

10:37Re: Sort and index Jim C. Nasby

15:19Re: ok you all win what is best opteron (I dont want a hosed system again) Joel Fradkin

18:18Re: ok you all win what is best opteron (I dont want a hosed system again) Josh Berkus

19:16Re: ok you all win what is best opteron (I dont want a hosed system again) Mike Nolan

21:44Re: ok you all win what is best opteron (I dont want a hosed system William Yu

15 мая 2005 г.

15:28Prefetch Matt Olson

15:30Swapping and Kernel 2.6 Guillaume Nobiron

15:30Re: full outer performance problem Kim Bisgaard

15:30Re: full outer performance problem Kim Bisgaard

16:36Re: ok you all win what is best opteron (I dont want a hosed system Greg Stark

17:40Re: ok you all win what is best opteron (I dont want a William Yu

18:15Re: Postgresql Performance via the LSI MegaRAID 2x Card William Yu

18:56Re: Swapping and Kernel 2.6 Grega Bremec

21:22checkpoint segments David Parker

23:26Re: PostgreSQL strugling during high load Matthew T. O'Connor

23:45Re: PostgreSQL strugling during high load Thomas F. O'Connell

16 мая 2005 г.

00:26Re: checkpoint segments Josh Berkus

00:27Re: Postgresql Performance via the LSI MegaRAID 2x Card Josh Berkus

01:34Re: checkpoint segments Tom Lane

01:39Re: checkpoint segments Alvaro Herrera

01:41Re: checkpoint segments Alvaro Herrera

07:05Re: PostgreSQL strugling during high load Mindaugas Riauba

13:19Re: checkpoint segments Josh Berkus

14:41Re: Prefetch Joel Fradkin

17 мая 2005 г.

13:54[pgsql-benchmarks] Error when try installing pgbench ? Andre Nas

13:55Trigger performance problem Manuel Wenger

14:47Re: Trigger performance problem Tom Lane

14:55Re: Trigger performance problem lists@boutiquenumerique.com

19:51Is there any other way to do this? Wei Weng

19:57Re: Is there any other way to do this? Steinar H. Gunderson

21:22Tuning planner cost estimates Jim C. Nasby

23:11Re: Is there any other way to do this? Christopher Kings-Lynne

18 мая 2005 г.

11:31where+orderby+limit not (always) using appropriate index? Szűcs Gábor

12:07Re: where+orderby+limit not (always) using appropriate index? PFC

12:14Re: where+orderby+limit not (always) using appropriate index? Tom Lane

16:08Re: [pgsql-benchmarks] Error when try installing pgbench ? Vivek Khera

19 мая 2005 г.

13:31Re: Tuning planner cost estimates Josh Berkus

13:55Re: PostgreSQL strugling during high load Donald Courtney

14:16Re: Tuning planner cost estimates Tom Lane

14:20Re: Tuning planner cost estimates Josh Berkus

15:12Re: PostgreSQL strugling during high load Anjan Dave

15:30Re: PostgreSQL strugling during high load Donald Courtney

16:43Re: PostgreSQL strugling during high load Vivek Khera

16:56Re: PostgreSQL strugling during high load Josh Berkus

17:11Re: PostgreSQL strugling during high load Steve Poe

17:19Re: PostgreSQL strugling during high load Anjan Dave

18:50Which is better, correlated subqueries or joins? Jeffrey Tenny

18:53Re: Which is better, correlated subqueries or joins? Joshua D. Drake

19:21Optimizing for writes. Data integrity not critical Steve Bergman

19:27Re: Optimizing for writes. Data integrity not critical Steinar H. Gunderson

20:44Re: Optimizing for writes. Data integrity not critical Tom Lane

22:42Re: Optimizing for writes. Data integrity not critical Christopher Kings-Lynne

20 мая 2005 г.

16:46performance on a querry with many group by's any way to speed it up? Joel Fradkin

16:57cant seem to post the explain Joel Fradkin

17:20Re: Tuning planner cost estimates Jim C. Nasby

17:47Re: Tuning planner cost estimates Tom Lane

19:21Re: Tuning planner cost estimates Josh Berkus

19:40Re: Tuning planner cost estimates Jim C. Nasby

19:48Re: Tuning planner cost estimates Jim C. Nasby

20:06Re: Tuning planner cost estimates Tom Lane

21 мая 2005 г.

12:16Re: Optimizing for writes. Data integrity not critical Alex Stapleton

14:26Re: Optimizing for writes. Data integrity not critical Alex Stapleton

23 мая 2005 г.

14:41Fwd: Index on table when using DESC clause Yves Vindevogel

15:04Re: Fwd: Index on table when using DESC clause Steinar H. Gunderson

16:02Re: Fwd: Index on table when using DESC clause Yves Vindevogel

16:47Re: Fwd: Index on table when using DESC clause Oleg Bartunov

17:19Re: Fwd: Index on table when using DESC clause Andrew Lazarus

17:50Re: Tuning planner cost estimates Simon Riggs

17:58seqential vs random io David Parker

18:19Re: Fwd: Index on table when using DESC clause Yves Vindevogel

19:23Re: seqential vs random io John A Meinel

19:31Re: seqential vs random io Josh Berkus

19:35Re: seqential vs random io Anjan Dave

24 мая 2005 г.

02:47Select performance vs. mssql mark durrant

03:18Re: Select performance vs. mssql Christopher Kings-Lynne

03:40Re: Select performance vs. mssql mark durrant

03:47Re: Select performance vs. mssql Neil Conway

05:47Re: Select performance vs. mssql Harald Lau (Sector-X)

12:36Re: Select performance vs. mssql mark durrant

14:06Need help to decide Mysql vs Postgres Amit V Shah

14:14Re: Need help to decide Mysql vs Postgres Joshua D. Drake

14:22Re: Need help to decide Mysql vs Postgres Amit V Shah

14:28Re: Select performance vs. mssql Bruno Wolff III

14:30Re: Need help to decide Mysql vs Postgres Joel Fradkin

14:36Re: Need help to decide Mysql vs Postgres Josh Berkus

14:57Re: Need help to decide Mysql vs Postgres Amit V Shah

15:02Re: Need help to decide Mysql vs Postgres Steinar H. Gunderson

15:19Re: Need help to decide Mysql vs Postgres Josh Berkus

16:15Re: Select performance vs. mssql mark durrant

18:18Re: Need help to decide Mysql vs Postgres PFC

18:36Re: Need help to decide Mysql vs Postgres Joshua D. Drake

20:12Re: Select performance vs. mssql Alex Turner

20:33Re: Select performance vs. mssql Josh Berkus

21:14Re: Select performance vs. mssql PFC

21:20Re: Select performance vs. mssql Michael Stone

21:38Re: Select performance vs. mssql John A Meinel

22:29Re: Select performance vs. mssql Christopher Kings-Lynne

23:07Can anyone explain this: duplicate dbs. SpaceBallOne

23:21Re: Can anyone explain this: duplicate dbs. Christopher Kings-Lynne

23:22Re: Can anyone explain this: duplicate dbs. Christopher Kings-Lynne

23:39Re: Can anyone explain this: duplicate dbs. John A Meinel

23:52Re: Can anyone explain this: duplicate dbs. SpaceBallOne

25 мая 2005 г.

00:00Re: Can anyone explain this: duplicate dbs. Christopher Kings-Lynne

00:00Re: Can anyone explain this: duplicate dbs. John A Meinel

00:02Re: Can anyone explain this: duplicate dbs. Tom Lane

00:04Re: Can anyone explain this: duplicate dbs. Tom Lane

00:34Re: Can anyone explain this: duplicate dbs. Bruno Wolff III

12:52Re: Need help to decide Mysql vs Postgres Philip Hallstrom

15:07Re: [PORTS] Which library has these symbols? -- Eureka Mohan, Ross

17:12Inner join on two OR conditions dont use index Jocelyn Turcotte

17:19Re: Inner join on two OR conditions dont use index John A Meinel

17:37test - pls delete and ignore Mohan, Ross

18:22Re: Inner join on two OR conditions dont use index Jocelyn Turcotte

18:43Re: Inner join on two OR conditions dont use index Tom Lane

22:39Re: [PORTS] Which library has these symbols? -- Eureka Christopher Kings-Lynne

26 мая 2005 г.

12:22Optimising queries involving unions Sam Mason

13:53Re: Optimising queries involving unions Tom Lane

14:42Re: Optimising queries involving unions Sam Mason

14:55Specific query performance problem help requested - postgresql 7.4 Brad Might

15:02Re: Optimising queries involving unions Tom Lane

15:32Re: Specific query performance problem help requested - postgresql 7.4 Tom Lane

15:41Re: Specific query performance problem help requested - postgresql 7.4 Brad Might

17:24slow queries, possibly disk io Josh Close

18:14Re: slow queries, possibly disk io John Arbash Meinel

18:23Re: slow queries, possibly disk io Dawid Kuroczko

22:28Re: slow queries, possibly disk io Christopher Kings-Lynne

27 мая 2005 г.

04:40Re: Optimising queries involving unions Marc Mamin

09:52Re: slow queries, possibly disk io Josh Close

10:04slow queries, possibly disk io Josh Close

10:05Re: slow queries, possibly disk io Josh Close

10:43postgresql-8.0.1 performance tuning Martin Fandel

11:29Re: slow queries, possibly disk io Tom Lane

11:54Re: slow queries, possibly disk io Josh Close

12:00Re: slow queries, possibly disk io Josh Close

14:06OID vs overall system performances on high load databases. Eric Lauzon

18:28Redundant indexes? Jeffrey Tenny

21:09Re: Redundant indexes? Tom Lane

28 мая 2005 г.

02:08Re: OID vs overall system performances on high load Andrew McMillan

14:47Re: OID vs overall system performances on high load PFC

29 мая 2005 г.

10:27sequential scan performance Michael Engelhart

10:47Re: sequential scan performance Steinar H. Gunderson

11:43Re: sequential scan performance Christopher Kings-Lynne

13:33Re: Select performance vs. mssql Jim C. Nasby

16:44Re: sequential scan performance Oleg Bartunov

17:17OID vs overall system performances on high load Eric Lauzon

18:47Re: OID vs overall system performances on high load Andrew McMillan

18:47Re: OID vs overall system performances on high load Tom Lane

30 мая 2005 г.

01:03Re: OID vs overall system performances on high load Neil Conway

02:18Re: slow queries, possibly disk io Rudi Starcevic

06:26timestamp indexing Tobias Brox

10:43Postgresql and xeon. Eric Lauzon

10:54Re: timestamp indexing Michael Fuhr

13:01Index not used on join with inherited tables Sebastian Böck

13:19Re: Postgresql and xeon. Josh Berkus

13:21Re: Index not used on join with inherited tables Josh Berkus

13:33Re: sequential scan performance Michael Engelhart

13:36Re: Index not used on join with inherited tables Sebastian Böck

13:53Re: sequential scan performance Steve Atkins

13:54Re: Postgresql and xeon. Steinar H. Gunderson

14:02Re: Postgresql and xeon. Eric Lauzon

14:02Re: timestamp indexing Tobias Brox

14:15Re: Postgresql and xeon. Tom Lane

14:58Re: timestamp indexing Tom Lane

18:52poor performance involving a small table Colton A Smith

18:53Specific query performance problem help requested - postgresql 7.4 Brad Might

18:53tuning list

18:54Re: Need help to decide Mysql vs Postgres ellis@no.spam ()

19:00Re: poor performance involving a small table Bricklen Anderson

19:07Drop / create indexes and vacuumdb Yves Vindevogel

19:42Re: tuning Mark Kirkwood

22:51Re: poor performance involving a small table Christopher Kings-Lynne

23:06Re: timestamp indexing Tobias Brox

23:20Re: timestamp indexing Tobias Brox

23:31Re: poor performance involving a small table andrew@pillette.com

31 мая 2005 г.

00:02Index on a NULL-value Tobias Brox

00:18Re: Index on a NULL-value Bruno Wolff III

00:23Re: Index on a NULL-value Tobias Brox

00:34Re: Index on a NULL-value Tobias Brox

00:45Re: Index on a NULL-value Bruno Wolff III

00:47Re: Index on a NULL-value Tobias Brox

01:09Re: Index on a NULL-value Bruno Wolff III

01:18Re: Index on a NULL-value Tom Lane

01:21Re: Index on a NULL-value Greg Stark

02:13Re: Index on a NULL-value Tom Lane

02:59Re: Index on a NULL-value Tobias Brox

06:37very large table Praveen Raja

10:16SURVEY: who is running postgresql on 8 or more CPUs? Dirk Lutzebäck

10:17Re: slow queries, possibly disk io Josh Close

11:06Re: very large table Tom Lane

11:33Re: slow queries, possibly disk io Tom Lane

13:37Re: slow queries, possibly disk io Josh Close

14:02'Fastest' PC's are slowest in the house Justin Davis

15:00Major flood of mail to lists ... Marc G. Fournier

15:49Re: slow queries, possibly disk io Manfred Koizar

16:40Re: postgresql-8.0.1 performance tuning John A Meinel

Ответы на вопросы