Home > mailing lists

Mailing lists [pgsql-performance]

1 November 2012

01:51 dbt2 performance regresses from 9.1.6 to 9.2.1 Dong Ye
22:19 Re: Replaying 48 WAL files takes 80 minutes Jeff
22:19 Re: Replaying 48 WAL files takes 80 minutes Jeff Trout
22:20 Re: Prepared statements slow in 9.2 still (bad query plan) Daniel Burbridge
22:20 pg_buffercache pg noob
22:21 Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
22:24 Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
22:41 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Marcos Ortiz
23:53 dbt2 performance regresses from 9.1.6 to 9.2.1 Dong Ye

2 November 2012

00:26 Re: pg_buffercache Merlin Moncure
02:25 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth
08:40 Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Scott Marlowe
10:47 Re: High %SYS CPU usage Cesar Martin
14:28 Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Ants Aasma
21:17 Constraint exclusion in views Claudio Freire

3 November 2012

13:31 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth
20:09 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth
22:37 Re: Constraint exclusion in views Josh Berkus

4 November 2012

00:23 Re: Constraint exclusion in views Tom Lane
02:53 Re: How to keep queries low latency as concurrency increases Jeff Janes
11:48 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth
20:33 Re: Constraint exclusion in views Claudio Freire

5 November 2012

02:55 Suggested test points for a performance tool? Christoffer Lernö
03:08 Re: Suggested test points for a performance tool? Claudio Freire
09:43 DBT-1 Samrat
09:46 DBT-1 Revagade, Samrat
12:21 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
12:21 help with too slow query Pedro Jiménez Pérez
12:21 Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
12:21 freebsd or linux list, mailing
12:22 Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Dong Ye
12:24 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
12:25 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
12:26 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
12:54 Re: help with too slow query Виктор Егоров
13:52 Re: help with too slow query Albe Laurenz
17:32 Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Claudio Freire
19:44 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Jeff Janes
19:48 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Claudio Freire
20:09 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Jeff Janes
20:27 Re: [HACKERS] out of memory Robert Haas
20:40 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Claudio Freire
20:59 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Claudio Freire
23:28 Re: Constraint exclusion in views Claudio Freire

6 November 2012

01:51 Re: How to keep queries low latency as concurrency increases Merlin Moncure
01:58 Re: How to keep queries low latency as concurrency increases Marko Kreen
02:31 Re: How to keep queries low latency as concurrency increases Jeff Janes
02:58 Re: How to keep queries low latency as concurrency increases Marko Kreen
04:30 Re: How to keep queries low latency as concurrency increases Jeff Janes
14:37 Re: help with too slow query Pedro Jiménez Pérez
15:17 Re: help with too slow query Виктор Егоров
17:16 Re: [HACKERS] pg_dump and thousands of schemas Denis
17:20 Re: help with too slow query Willem Leenen
17:52 Re: help with too slow query Виктор Егоров
18:07 Re: [HACKERS] pg_dump and thousands of schemas Tom Lane
18:12 Re: help with too slow query Willem Leenen
18:40 Re: [HACKERS] pg_dump and thousands of schemas Denis
20:12 Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
20:22 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure
20:36 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane
20:51 Re: [HACKERS] pg_dump and thousands of schemas Tom Lane
21:08 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 ktm@rice.edu
21:09 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
21:22 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
21:31 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
21:42 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure
21:59 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
22:08 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth
22:24 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane
22:31 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
22:38 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth
22:45 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane
23:18 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth
23:50 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar \"Nick\" Bluth

7 November 2012

00:11 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure
00:18 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane
00:48 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure
06:31 HT on or off for E5-26xx ? David Boreham
07:15 Re: HT on or off for E5-26xx ? Mark Kirkwood
13:42 Re: [HACKERS] pg_dump and thousands of schemas Denis
14:16 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
14:42 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
14:43 Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Heikki Linnakangas
16:33 Re: HT on or off for E5-26xx ? David Boreham
16:37 Re: HT on or off for E5-26xx ? Devrim GÜNDÜZ
16:45 Re: HT on or off for E5-26xx ? David Boreham
18:02 Re: [HACKERS] pg_dump and thousands of schemas Tom Lane
18:22 Unique values across a table of arrays - documents and tags Ivan Voras
18:34 Re: Unique values across a table of arrays - documents and tags François Beausoleil
18:39 Re: Unique values across a table of arrays - documents and tags Ivan Voras
18:54 Re: Unique values across a table of arrays - documents and tags Florent Guillaume
19:01 Re: Unique values across a table of arrays - documents and tags Ivan Voras
19:34 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure
19:48 Re: Unique values across a table of arrays - documents and tags Florent Guillaume
19:58 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane
21:36 Re: How to upgrade from 9.1 to 9.2 with replication? Bruce Momjian
21:44 Re: How to upgrade from 9.1 to 9.2 with replication? Claudio Freire
23:29 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
23:59 Re: How to upgrade from 9.1 to 9.2 with replication? Bruce Momjian

8 November 2012

00:18 Re: How to upgrade from 9.1 to 9.2 with replication? Claudio Freire
00:20 Re: HT on or off for E5-26xx ? Mark Kirkwood
00:38 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
03:58 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane
06:16 Re: HT on or off for E5-26xx ? David Boreham
12:04 Re: [HACKERS] pg_dump and thousands of schemas Denis
12:36 Thousands databases or schemas Denis
13:32 Re: Thousands databases or schemas Samuel Gendler
16:29 Re: Thousands databases or schemas Denis
16:49 Re: Thousands databases or schemas Pavel Stehule
16:50 Re: Thousands databases or schemas Mark Thornton
16:58 Re: HT on or off for E5-26xx ? Shaun Thomas
17:19 Re: HT on or off for E5-26xx ? David Boreham
18:30 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas
18:39 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Alvaro Herrera
18:44 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas

9 November 2012

09:16 Re: Thousands databases or schemas Craig Ringer
09:38 Re: Thousands databases or schemas Magnus Hagander
17:34 Re: HT on or off for E5-26xx ? David Boreham
18:04 Re: Thousands databases or schemas Merlin Moncure
20:53 Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Andres Freund
23:47 Re: [HACKERS] pg_dump and thousands of schemas Jeff Janes

10 November 2012

17:01 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
17:01 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
17:01 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
17:02 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 aasat
17:05 parallel query evaluation Oliver Seidel
17:28 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus
18:32 Re: parallel query evaluation Tom Lane

12 November 2012

10:11 Planner sometimes doesn't use a relevant index with IN (subquery) condition Rafał Rzepecki
10:31 Index is not using K P Manoj
11:31 Re: Index is not using Albe Laurenz
11:42 Re: Index is not using K P Manoj
12:44 Re: Index is not using Albe Laurenz
13:45 fast read of binary data Eildert Groeneveld
14:18 Re: fast read of binary data Albe Laurenz
14:38 Re: fast read of binary data Arjen van der Meijden
17:17 PostreSQL v9.2 uses a lot of memory in Windows XP Wu Ming
17:29 Re: PostreSQL v9.2 uses a lot of memory in Windows XP Albe Laurenz
17:53 Re: PostreSQL v9.2 uses a lot of memory in Windows XP Merlin Moncure
19:57 Re: fast read of binary data Merlin Moncure
21:48 Re: Planner sometimes doesn't use a relevant index with IN (subquery) condition Rafał Rzepecki
22:49 performance regression with 9.2 Dave Cramer
23:43 Re: performance regression with 9.2 Tom Lane
23:53 Re: performance regression with 9.2 Dave Cramer

13 November 2012

00:13 Re: performance regression with 9.2 Willem Leenen
00:26 Re: performance regression with 9.2 Tom Lane
05:08 Re: PostreSQL v9.2 uses a lot of memory in Windows XP Craig Ringer
18:28 Re: Planner sometimes doesn't use a relevant index with IN (subquery) condition Gavin Flower
22:14 postgres 8.4, COPY, and high concurrency Jon Nelson
22:27 Re: postgres 8.4, COPY, and high concurrency Heikki Linnakangas
22:30 Re: postgres 8.4, COPY, and high concurrency Jeff Janes
23:03 Re: postgres 8.4, COPY, and high concurrency Jon Nelson
23:43 Re: postgres 8.4, COPY, and high concurrency Jeff Janes

14 November 2012

02:07 Re: PostreSQL v9.2 uses a lot of memory in Windows XP Craig Ringer
04:10 Re: postgres 8.4, COPY, and high concurrency Jon Nelson
06:12 Re: [HACKERS] pg_dump and thousands of schemas Denis
06:41 Re: [HACKERS] pg_dump and thousands of schemas Jeff Janes
06:56 Re: [HACKERS] pg_dump and thousands of schemas Andrew Dunstan
08:56 Re: PostreSQL v9.2 uses a lot of memory in Windows XP Wu Ming
09:47 Re: PostreSQL v9.2 uses a lot of memory in Windows XP Craig Ringer
15:05 Re: PostreSQL v9.2 uses a lot of memory in Windows XP Peter Geoghegan
17:42 Re: postgres 8.4, COPY, and high concurrency Jon Nelson
18:23 Poor performance using CTE David Greco
18:51 Re: Poor performance using CTE Andrew Dunstan
18:57 Re: Poor performance using CTE David Greco
19:07 Re: Poor performance using CTE Andrew Dunstan
19:18 SOLVED - RE: Poor performance using CTE David Greco
19:29 Re: SOLVED - RE: Poor performance using CTE Tom Lane
22:02 Re: postgres 8.4, COPY, and high concurrency Jeff Janes
23:04 Re: postgres 8.4, COPY, and high concurrency Jon Nelson
23:36 Re: Setting Statistics on Functional Indexes Robert Haas
23:55 Re: Setting Statistics on Functional Indexes Claudio Freire

15 November 2012

00:00 Re: Setting Statistics on Functional Indexes Tom Lane
00:25 Re: postgres 8.4, COPY, and high concurrency Jeff Janes
04:21 Re: SOLVED - RE: Poor performance using CTE Craig Ringer
04:31 Re: SOLVED - RE: Poor performance using CTE Tom Lane
04:46 Re: SOLVED - RE: Poor performance using CTE Andrew Dunstan
05:03 Re: SOLVED - RE: Poor performance using CTE Peter Geoghegan
18:50 Re: Thousands databases or schemas Bruce Momjian
22:21 Re: performance regression with 9.2 Tom Lane

16 November 2012

14:40 PostgreSQL strange query plan for my query David Popiashvili
15:55 Re: PostgreSQL strange query plan for my query Albe Laurenz
16:04 Re: PostgreSQL strange query plan for my query David Popiashvili
16:18 Re: PostgreSQL strange query plan for my query Julien Cigar
17:28 intercepting where clause on a view or other performance tweak Russell Keane
18:05 Re: intercepting where clause on a view or other performance tweak Tom Lane
18:17 Re: intercepting where clause on a view or other performance tweak Russell Keane
18:22 Re: intercepting where clause on a view or other performance tweak Russell Keane
18:41 Re: intercepting where clause on a view or other performance tweak Tom Lane
19:32 Re: PostgreSQL strange query plan for my query Craig James
19:35 Re: PostgreSQL strange query plan for my query David Popiashvili
19:53 Re: PostgreSQL strange query plan for my query Julien Cigar

20 November 2012

10:13 Poor performance using CTE David Greco
10:13 Re: postgres 8.4, COPY, and high concurrency Strange, John W
10:13 PQconnectStart/PQconnectPoll Sergio Mayoral
10:14 slow query on postgres 8.4 Maria L. Wilson
10:16 help on slow query using postgres 8.4 Maria L. Wilson
10:17 partitioning versus clustering Andrew W. Gibbs
10:17 PostgreSQL strange query plan for my query David Popiashvili
10:19 Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7 Antti Jokipii
10:21 Re: SOLVED - RE: Poor performance using CTE Gavin Flower
10:28 Re: Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7 Pavel Stehule
14:16 FW: slow query on postgres 8.4 Russell Keane
16:06 Re: help on slow query using postgres 8.4 Kevin Grittner
16:38 Re: PQconnectStart/PQconnectPoll Kevin Grittner
18:04 Re: Poor performance using CTE Merlin Moncure
18:10 Re: Poor performance using CTE Claudio Freire
18:46 Re: Poor performance using CTE Merlin Moncure
19:06 Re: Poor performance using CTE Claudio Freire
22:22 Re: SOLVED - RE: Poor performance using CTE Merlin Moncure
22:26 Re: SOLVED - RE: Poor performance using CTE Claudio Freire
22:53 Re: SOLVED - RE: Poor performance using CTE Jon Nelson
23:24 Re: SOLVED - RE: Poor performance using CTE Merlin Moncure
23:28 Re: SOLVED - RE: Poor performance using CTE Claudio Freire

21 November 2012

00:26 Re: SOLVED - RE: Poor performance using CTE Tom Lane
02:34 Re: SOLVED - RE: Poor performance using CTE Craig Ringer
02:38 Re: Poor performance using CTE Craig Ringer
02:45 Re: Poor performance using CTE Claudio Freire
02:53 Re: Poor performance using CTE Tom Lane
04:35 Hints (was Poor performance using CTE) Craig James
05:15 Re: Hints (was Poor performance using CTE) Craig Ringer
16:04 Re: Poor performance using CTE Heikki Linnakangas
16:15 Re: Poor performance using CTE Peter Geoghegan
16:27 Re: Hints (was Poor performance using CTE) Shaun Thomas
17:44 Re: Hints (was Poor performance using CTE) Kevin Grittner
17:47 Re: Poor performance using CTE Andrew Dunstan
17:59 Re: Poor performance using CTE Tom Lane
18:21 Re: Poor performance using CTE Andrew Dunstan
18:32 Re: Poor performance using CTE Andres Freund
18:32 Re: Poor performance using CTE Peter Geoghegan
18:56 Re: Poor performance using CTE Heikki Linnakangas
19:05 Re: Hints (was Poor performance using CTE) Heikki Linnakangas
19:16 Re: Poor performance using CTE Claudio Freire
19:24 Re: Poor performance using CTE Andres Freund
19:32 Re: Poor performance using CTE Claudio Freire
19:34 Re: Hints (was Poor performance using CTE) Craig James
19:35 Re: Poor performance using CTE Andres Freund
19:35 Re: Poor performance using CTE Andrew Dunstan
19:37 Re: Poor performance using CTE Claudio Freire
20:10 Re: Poor performance using CTE Tom Lane
20:25 Re: Hints (was Poor performance using CTE) Joe Conway
20:28 Re: Hints (was Poor performance using CTE) Craig James
20:30 Re: Hints (was Poor performance using CTE) Joe Conway
20:40 Re: Hints (was Poor performance using CTE) Tom Lane
20:48 Re: Hints (was Poor performance using CTE) Andreas Kretschmer
22:04 Re: Hints - experiences from other rdbms Willem Leenen
22:42 Re: Poor performance using CTE Andrew Dunstan

22 November 2012

03:09 Re: Poor performance using CTE Craig Ringer
03:43 Re: Poor performance using CTE Craig Ringer
03:54 Re: Hints (was Poor performance using CTE) Jeff Janes
10:54 Re: fast read of binary data Eildert Groeneveld
12:11 Re: Hints (was Poor performance using CTE) Heikki Linnakangas
12:28 Re: fast read of binary data Heikki Linnakangas
13:35 Re: PQconnectStart/PQconnectPoll Craig Ringer
15:06 SQL performance question Niklas Paulsson
16:42 Re: Poor performance using CTE Jeremy Harris
17:24 Re: Poor performance using CTE Jon Nelson
20:37 Re: SOLVED - RE: Poor performance using CTE Vitalii Tymchyshyn

23 November 2012

11:07 Re: Poor performance using CTE Gavin Flower
11:07 Re: Poor performance using CTE Gavin Flower
11:07 Re: Hints (was Poor performance using CTE) Gavin Flower
11:07 Re: Poor performance using CTE Gavin Flower
11:09 Re: Poor performance using CTE Gavin Flower
13:06 Re: Hints (was Poor performance using CTE) Cédric Villemain

24 November 2012

03:22 Re: SOLVED - RE: Poor performance using CTE Bruce Momjian

25 November 2012

19:30 Re: How to keep queries low latency as concurrency increases Catalin Iacob

26 November 2012

10:46 Re: How to keep queries low latency as concurrency increases Heikki Linnakangas

27 November 2012

16:34 Postgres configuration for 8 CPUs, 6 GB RAM Syed Asif Tanveer
16:43 Re: Postgres configuration for 8 CPUs, 6 GB RAM Heikki Linnakangas
16:56 Re: Postgres configuration for 8 CPUs, 6 GB RAM Andrew Dunstan
22:53 Re: Postgres configuration for 8 CPUs, 6 GB RAM Scott Marlowe

28 November 2012

01:04 Savepoints in transactions for speed? Mike Blackwell
01:52 Re: Savepoints in transactions for speed? Richard Huxton
02:18 Re: How to keep queries low latency as concurrency increases Scott Marlowe
02:26 Re: Savepoints in transactions for speed? Steve Atkins
02:37 Re: Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7 Merlin Moncure
02:42 Re: Hints (was Poor performance using CTE) Scott Marlowe
03:16 Re: Savepoints in transactions for speed? Bob Lunney
03:29 Re: Postgres configuration for 8 CPUs, 6 GB RAM Dave Crooke
04:08 Re: Savepoints in transactions for speed? Mike Blackwell
04:18 Re: Savepoints in transactions for speed? Claudio Freire
05:20 Re: Hints (was Poor performance using CTE) Craig Ringer
05:26 Re: Hints (was Poor performance using CTE) Scott Marlowe
06:09 Re: Savepoints in transactions for speed? Franklin, Dan
09:03 Re: Savepoints in transactions for speed? Willem Leenen
09:45 pgsql_tmp( Temporary tablespace) suhas.basavaraj12
11:29 Re: pgsql_tmp( Temporary tablespace) Albe Laurenz
11:37 Re: pgsql_tmp( Temporary tablespace) suhas.basavaraj12
13:28 Re: pgsql_tmp( Temporary tablespace) Albe Laurenz
15:41 Database design - best practice Niels Kristian Schjødt
15:57 Optimize update query Niels Kristian Schjødt
16:10 Re: Database design - best practice Willem Leenen
16:20 Re: Database design - best practice Niels Kristian Schjødt
16:27 Re: Database design - best practice Willem Leenen
16:29 Re: Database design - best practice Bèrto ëd Sèra
17:08 Re: Optimize update query Shaun Thomas
17:39 Re: Optimize update query Marcin Mirosław
17:40 Re: Database design - best practice Kevin Grittner
17:41 Re: Database design - best practice Vitalii Tymchyshyn
17:51 Re: Optimize update query Kevin Grittner
18:11 Re: Optimize update query Willem Leenen
18:18 Re: Savepoints in transactions for speed? Mike Blackwell
18:23 Re: Savepoints in transactions for speed? Willem Leenen
19:19 Re: Optimize update query Niels Kristian Schjødt
19:29 Re: Optimize update query Bèrto ëd Sèra
19:54 Re: Optimize update query Shaun Thomas
21:01 Re: Optimize update query Shaun Thomas
21:05 Re: Database design - best practice Jeff Janes
21:12 NEED REPLICATION SOLUTION -POSTGRES 9.1 suhas.basavaraj12
21:15 Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Claudio Freire
21:30 Re: NEED REPLICATION SOLUTION -POSTGRES 9.1 Rick Otten
21:37 Comparative tps question John Lister
22:21 Re: Comparative tps question Merlin Moncure

29 November 2012

02:18 Re: Savepoints in transactions for speed? Jeff Davis
02:28 Re: Savepoints in transactions for speed? Jeff Davis
06:32 Re: Optimize update query Niels Kristian Schjødt
06:48 Re: Savepoints in transactions for speed? Claudio Freire
07:31 Re: Optimize update query Mark Kirkwood
14:33 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL Guillaume Cottenceau
14:50 Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL Pavan Deolasee
15:12 Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL Andres Freund
15:30 Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL Pavan Deolasee
15:36 Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL Andres Freund
15:45 Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL Pavan Deolasee
19:38 Re: Savepoints in transactions for speed? Mike Blackwell
19:54 Re: Savepoints in transactions for speed? Scott Marlowe
19:56 Re: Comparative tps question John Lister
20:33 Re: Comparative tps question Merlin Moncure
21:07 Re: Savepoints in transactions for speed? Mike Blackwell
21:09 Re: Savepoints in transactions for speed? Jeff Janes
21:14 Re: Savepoints in transactions for speed? Mike Blackwell
21:32 Re: Savepoints in transactions for speed? Jeff Davis
22:58 Re: Savepoints in transactions for speed? Claudio Freire
23:25 Re: Savepoints in transactions for speed? Jeff Janes

30 November 2012

03:59 Re: Optimize update query Niels Kristian Schjødt
04:24 Re: Optimize update query Kevin Grittner
04:43 Re: Optimize update query Niels Kristian Schjødt
05:32 Re: Optimize update query Niels Kristian Schjødt
11:38 Re: Optimize update query Vitalii Tymchyshyn
12:19 Re: Optimize update query Mark Kirkwood
12:39 Re: Optimize update query Mark Kirkwood
13:07 Re: Optimize update query Vitalii Tymchyshyn
13:14 Re: Optimize update query Willem Leenen
13:31 Re: Optimize update query Vitalii Tymchyshyn
15:04 Re: Optimize update query Kevin Grittner
16:31 Re: Optimize update query Niels Kristian Schjødt
16:49 Re: Optimize update query Shaun Thomas
17:02 Re: Optimize update query Shaun Thomas
17:06 Re: Optimize update query Shaun Thomas
17:34 deadlock under load Bob Jolliffe
17:49 Re: Optimize update query Niels Kristian Schjødt
18:00 Re: Optimize update query Shaun Thomas
18:44 Re: Optimize update query Niels Kristian Schjødt
18:57 Re: deadlock under load Tom Lane
19:06 Re: Optimize update query Shaun Thomas
19:13 Re: deadlock under load Bob Jolliffe
22:57 shared_buffers on ubuntu precise Ben Chobot
22:59 Re: Comparative tps question John Lister
23:01 Re: shared_buffers on ubuntu precise Shaun Thomas
23:38 Re: shared_buffers on ubuntu precise Bruce Momjian
23:46 Re: shared_buffers on ubuntu precise Shaun Thomas