Продукты

О компании

Ресурсы

Мероприятия

Образование

...

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

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 21 22 23 24 25 26 30

1 апреля 2013 г.

00:37query plan estimate pg noob

00:53Re: query plan estimate Tom Lane

13:42Re: Question about postmaster's CPU usage Merlin Moncure

22:36Problems with pg_locks explosion Armand du Plessis

22:56Fwd: Problems with pg_locks explosion Vasilis Ventirozos

23:10Re: Problems with pg_locks explosion Armand du Plessis

23:15Re: Problems with pg_locks explosion Armand du Plessis

23:43Re: Problems with pg_locks explosion Vasilis Ventirozos

2 апреля 2013 г.

00:10Postgres upgrade, security release, where? Tory M Blue

00:11Re: Problems with pg_locks explosion Mark Kirkwood

00:21Re: Problems with pg_locks explosion Jeff Janes

00:27Re: Postgres upgrade, security release, where? Bruce Momjian

00:32Fwd: Problems with pg_locks explosion Armand du Plessis

00:40Re: Postgres upgrade, security release, where? Ian Lawrence Barwick

00:41Re: Problems with pg_locks explosion Armand du Plessis

00:55Re: Postgres upgrade, security release, where? Bruce Momjian

00:59Re: Problems with pg_locks explosion Armand du Plessis

01:07Re: Problems with pg_locks explosion Steven Crandell

02:54Re: Problems with pg_locks explosion Armand du Plessis

03:36Re: Postgres upgrade, security release, where? Tory M Blue

03:41Re: Fwd: Problems with pg_locks explosion Mark Kirkwood

03:43Re: Postgres upgrade, security release, where? Mark Kirkwood

06:08Re: Problems with pg_locks explosion Jeff Janes

06:08Re: Problems with pg_locks explosion Jeff Janes

06:22Re: Problems with pg_locks explosion Armand du Plessis

06:25Re: Problems with pg_locks explosion Mark Kirkwood

06:33Re: Problems with pg_locks explosion Armand du Plessis

06:43Re: Problems with pg_locks explosion Mark Kirkwood

08:17Re: Problems with pg_locks explosion Armand du Plessis

08:34Re: Postgres upgrade, security release, where? Dave Page

08:47Re: Postgres upgrade, security release, where? Mark Kirkwood

08:52Join between 2 tables always executes a sequential scan on the larger table Dieter Rehbein

09:55Re: Problems with pg_locks explosion Armand du Plessis

14:56Re: Join between 2 tables always executes a sequential scan on the larger table Igor Neyman

15:46Re: Re: Join between 2 tables always executes a sequential scan on the larger table Tom Lane

18:16Re: Problems with pg_locks explosion Armand du Plessis

18:57Planner is getting wrong row count AI Rumman

3 апреля 2013 г.

08:19Re: Join between 2 tables always executes a sequential scan on the larger table Dieter Rehbein

08:25Re: Join between 2 tables always executes a sequential scan on the larger table Dieter Rehbein

08:50Re: Join between 2 tables always executes a sequential scan on the larger table Vasilis Ventirozos

15:34Re: Planner is getting wrong row count Kevin Grittner

4 апреля 2013 г.

08:52Re: Postgres upgrade, security release, where? Mark Kirkwood

09:11Re: Postgres upgrade, security release, where? Ian Lawrence Barwick

14:48What happens between end of explain analyze and end of query execution ? Franck Routier

15:02Re: What happens between end of explain analyze and end of query execution ? Nikolas Everett

15:44Re: What happens between end of explain analyze and end of query execution ? Franck Routier

16:25Re: What happens between end of explain analyze and end of query execution ? Tom Lane

18:50Re: What happens between end of explain analyze and end of query execution ? Franck Routier

19:06Re: What happens between end of explain analyze and end of query execution ? nik9000@gmail.com

19:08Re: What happens between end of explain analyze and end of query execution ? Tom Lane

19:19Re: What happens between end of explain analyze and end of query execution ? Merlin Moncure

5 апреля 2013 г.

13:55Re: What happens between end of explain analyze and end of query execution ? Franck Routier

14:17Re: What happens between end of explain analyze and end of query execution ? Tom Lane

14:17Re: What happens between end of explain analyze and end of query execution ? Merlin Moncure

14:18Re: What happens between end of explain analyze and end of query execution ? Nikolas Everett

15:51INDEX Performance Issue Mark Davidson

16:37Re: INDEX Performance Issue Kevin Grittner

16:54Re: Picking out the most recent row using a time stamp column Dave Johansen

18:40Re: Picking out the most recent row using a time stamp column Merlin Moncure

6 апреля 2013 г.

01:38slow joins? Joe Van Dyk

01:43Re: slow joins? Joe Van Dyk

01:51Re: slow joins? Joe Van Dyk

01:54Re: slow joins? Greg Williamson

02:56Re: slow joins? Joe Van Dyk

03:33Re: slow joins? Greg Williamson

08:02Re: What happens between end of explain analyze and end of query execution ? Franck Routier

08:04Re: What happens between end of explain analyze and end of query execution ? Franck Routier

08:14Re: What happens between end of explain analyze and end of query execution ? Franck Routier

09:05Re: What happens between end of explain analyze and end of query execution ? Franck Routier

10:53Re: slow joins? Julien Cigar

14:22Re: slow joins? Kevin Grittner

14:44Re: slow joins? Julien Cigar

15:26Re: What happens between end of explain analyze and end of query execution ? Kevin Grittner

16:27Re: What happens between end of explain analyze and end of query execution ? Tom Lane

7 апреля 2013 г.

04:59Find how much memory is postgres using Nik Tek

07:15Re: Find how much memory is postgres using Yetkin Öztürk

09:49Re: Find how much memory is postgres using hubert depesz lubaczewski

10:03Re: INDEX Performance Issue Mark Davidson

10:21Re: INDEX Performance Issue Greg Williamson

12:12Re: What happens between end of explain analyze and end of query execution ? Franck Routier

15:15Re: INDEX Performance Issue Kevin Grittner

22:22Re: INDEX Performance Issue Mark Davidson

8 апреля 2013 г.

10:18Re: Find how much memory is postgres using hubert depesz lubaczewski

16:39Re: What happens between end of explain analyze and end of query execution ? Jeff Janes

16:46Re: What happens between end of explain analyze and end of query execution ? Tom Lane

17:03Re: INDEX Performance Issue Mark Davidson

17:19Re: INDEX Performance Issue Vasilis Ventirozos

19:31Re: INDEX Performance Issue Mark Davidson

20:03Re: INDEX Performance Issue Vasilis Ventirozos

20:25Re: INDEX Performance Issue Mark Davidson

20:28Re: INDEX Performance Issue Vasilis Ventirozos

20:39Re: INDEX Performance Issue Jeff Janes

20:57Re: INDEX Performance Issue Mark Davidson

21:01Re: INDEX Performance Issue Mark Davidson

21:10Re: Picking out the most recent row using a time stamp column Dave Johansen

9 апреля 2013 г.

18:24Re: Find how much memory is postgres using Nik Tek

18:34Re: Find how much memory is postgres using hubert depesz lubaczewski

18:42Re: Find how much memory is postgres using Nik Tek

10 апреля 2013 г.

13:50slow bitmap heap scans on pg 9.2 Steve Singer

13:57Re: slow bitmap heap scans on pg 9.2 ktm@rice.edu

15:56Re: slow bitmap heap scans on pg 9.2 Steve Singer

17:50Re: slow bitmap heap scans on pg 9.2 ktm@rice.edu

18:06Re: slow bitmap heap scans on pg 9.2 Jeff Janes

18:15Re: slow bitmap heap scans on pg 9.2 Jeff Janes

21:25Postgresql.conf file from like 7.x to 9.2 Tory M Blue

21:42Re: Postgresql.conf file from like 7.x to 9.2 Shaun Thomas

21:53Re: Postgresql.conf file from like 7.x to 9.2 Tory M Blue

21:58Postgres log(pg_logs) have lots of message Nik Tek

22:06Re: [ADMIN] Postgres log(pg_logs) have lots of message Nik Tek

23:54Re: slow bitmap heap scans on pg 9.2 Steve Singer

11 апреля 2013 г.

07:47Performance ts_vector fulltext search Luigi Saggese

14:20Re: slow bitmap heap scans on pg 9.2 Steve Singer

14:58Re: Performance ts_vector fulltext search Tom Lane

21:09PsqL8.3 Thiyagarajan, Palaniappan

12 апреля 2013 г.

06:14Re: Postgres log(pg_logs) have lots of message Jeff Janes

10:02Re: PsqL8.3 Richard Huxton

16:45Segment best size Rodrigo Barboza

16:51Changing ORDER BY column slows query dramatically brick pglists

17:52Re: Segment best size Ben Chobot

19:17Re: Segment best size Rodrigo Barboza

19:59Re: Changing ORDER BY column slows query dramatically Shaun Thomas

20:38Re: Changing ORDER BY column slows query dramatically brick pglists

21:05Recommended Swap space Nik Tek

21:15Re: Recommended Swap space Scott Marlowe

21:21Re: Recommended Swap space Claudio Freire

21:41Default value checkpoint_completion_target Rodrigo Barboza

23:06Re: Recommended Swap space Scott Marlowe

13 апреля 2013 г.

01:20Re: Segment best size Jeff Janes

01:20Re: slow bitmap heap scans on pg 9.2 Jeff Janes

08:25limit is sometimes not pushed in view with order Rikard Pavelic

15:21Re: limit is sometimes not pushed in view with order Tom Lane

15:37Re: limit is sometimes not pushed in view with order Julian

16:14Re: slow bitmap heap scans on pg 9.2 Steve Singer

17:29Re: Segment best size Rodrigo Barboza

18:08Re: limit is sometimes not pushed in view with order Rikard Pavelic

19:51Re: Segment best size Jeff Janes

20:54Re: slow bitmap heap scans on pg 9.2 Jeff Janes

22:08Re: limit is sometimes not pushed in view with order Rikard Pavelic

14 апреля 2013 г.

03:01Re: Segment best size Rodrigo Barboza

05:21Re: Segment best size Scott Marlowe

10:34Re: limit is sometimes not pushed in view with order Rikard Pavelic

14:34Re: limit is sometimes not pushed in view with order Rikard Pavelic

22:34Re: Segment best size Jeff Janes

23:30Re: Segment best size Rodrigo Barboza

15 апреля 2013 г.

00:07Re: slow bitmap heap scans on pg 9.2 Steve Singer

06:09Advice on testing buffer spin lock contention Atri Sharma

17:54Re: Advice on testing buffer spin lock contention Atri Sharma

19:31Re: INDEX Performance Issue Jeff Janes

19:37Re: INDEX Performance Issue Jeff Janes

20:16Re: INDEX Performance Issue Jeff Janes

21:00Poor performance on an aggregate query Anne Rosset

21:04Re: Poor performance on an aggregate query Peter Geoghegan

16 апреля 2013 г.

09:16Re: Postgresql performance degrading... how to diagnose the root cause Franck Routier

18 апреля 2013 г.

14:20"WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan dmitry potapov

14:43Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Richard Huxton

14:47Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Tom Lane

20:42Query planner ignoring constraints on partitioned tables when joining Michael Okner

20:44SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object itishree sukla

20:45Re: [GENERAL] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object Alfonso Afonso

20:47High CPU usage buy low I/O wait bing1221

20:54Re: High CPU usage buy low I/O wait ktm@rice.edu

21:17Re: SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object Vitalii Tymchyshyn

21:42Re: Query planner ignoring constraints on partitioned tables when joining Tom Lane

19 апреля 2013 г.

17:05Re: slow bitmap heap scans on pg 9.2 Steve Singer

21:55maintenance_work_mem and autovacuum_max_workers Rodrigo Barboza

21 апреля 2013 г.

12:46 sunil virmani

17:01Re: Rob Wultsch

17:28Re: Scott Marlowe

17:32Re: Scott Marlowe

21:30Issues with OSX and SHMMAX? Josh Berkus

21:33Re: Issues with OSX and SHMMAX? Evgeny Shishkin

22 апреля 2013 г.

08:26Re: - why only 9.1? Ireneusz Pluta

11:31template1 vacuuming consuming much time compared to another production DBs pradeep singh

12:08Re: template1 vacuuming consuming much time compared to another production DBs Andrew Dunstan

16:49Performance with the new security release Anne Rosset

17:41Re: Performance with the new security release Heikki Linnakangas

18:19Re: Issues with OSX and SHMMAX? Josh Berkus

22:31Re: Issues with OSX and SHMMAX? Steve Atkins

23 апреля 2013 г.

00:39Re: Issues with OSX and SHMMAX? Tom Lane

01:49Re: template1 vacuuming consuming much time compared to another production DBs pradeep singh

24 апреля 2013 г.

23:56Question about network bandwidth usage between PostgreSQL’s client and server Kelphet Xiong

25 апреля 2013 г.

11:26Re: [PERFORM] Question about network bandwidth usage between PostgreSQL’s client and server Heikki Linnakangas

12:18different plans for the same query - different filter values Misa Simic

26 апреля 2013 г.

02:33In progress INSERT wrecks plans on table Mark Kirkwood

03:20Re: In progress INSERT wrecks plans on table Mark Kirkwood

30 апреля 2013 г.

17:13Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables Mark Hampton

19:24Re: Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables Vitalii Tymchyshyn

20:03Re: Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables Mark Hampton

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