Продукты

О компании

Ресурсы

Мероприятия

Образование

...

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

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

ЯнварьМарт

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

1 февраля 2013 г.

17:11Fighting the planner >:-( Casey Allen Shobe

17:54Re: Fighting the planner >:-( Casey Allen Shobe

18:50Re: Fighting the planner >:-( Richard Huxton

19:18Re: Fighting the planner >:-( Casey Allen Shobe

21:02Re: Fighting the planner >:-( Casey Allen Shobe

21:12Re: Fighting the planner >:-( Виктор Егоров

21:18Re: Fighting the planner >:-( Casey Allen Shobe

21:55Re: Fighting the planner >:-( Виктор Егоров

22:03Re: Fighting the planner >:-( Casey Allen Shobe

22:17Re: Fighting the planner >:-( Виктор Егоров

2 февраля 2013 г.

16:39Re: Simple join doesn't use index Jeff Janes

4 февраля 2013 г.

21:15Re: Simple join doesn't use index Dan Fairs

21:52numerical primary key vs alphanumerical primary key Anne Rosset

21:58Re: numerical primary key vs alphanumerical primary key Виктор Егоров

5 февраля 2013 г.

03:46Slow Query Help Will Platnick

13:58Re: Slow Query Help Heikki Linnakangas

22:02postgresql.conf recommendations Johnny Tan

22:37Re: postgresql.conf recommendations Josh Krupka

23:46Re: postgresql.conf recommendations Johnny Tan

6 февраля 2013 г.

04:24Re: postgresql.conf recommendations Josh Krupka

06:00Re: postgresql.conf recommendations Pavan Deolasee

06:18Re: postgresql.conf recommendations ac@hsk.hk

08:51Re: Slow Query Help Pavan Deolasee

12:49Re: postgresql.conf recommendations Kevin Grittner

13:17Re: Slow Query Help Will Platnick

15:42Re: postgresql.conf recommendations David Whittaker

16:22Re: Slow Query Help Kevin Grittner

16:24Re: Slow Query Help Will Platnick

16:28Re: Slow Query Help Pavan Deolasee

18:20Re: postgresql.conf recommendations Josh Krupka

19:14Re: postgresql.conf recommendations David Whittaker

19:33Re: postgresql.conf recommendations Johnny Tan

19:45Re: postgresql.conf recommendations Johnny Tan

19:48Re: postgresql.conf recommendations Johnny Tan

20:12Re: postgresql.conf recommendations Jeff Janes

20:28Re: postgresql.conf recommendations Josh Krupka

21:12Re: postgresql.conf recommendations Kevin Grittner

7 февраля 2013 г.

12:07Re: postgresql.conf recommendations Strahinja Kustudić

14:41Re: postgresql.conf recommendations Charles Gomes

17:29Re: postgresql.conf recommendations Johnny Tan

17:50Re: postgresql.conf recommendations Josh Krupka

8 февраля 2013 г.

00:52FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller

05:46Re: FTS performance issue probably due to wrong planner estimate of detoasting Pavel Stehule

06:56Re: FTS performance issue probably due to wrong planner estimate of detoasting Jesper Krogh

12:37Slow query even with aggressive auto analyze Karolis Pocius

17:30Re: FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller

20:53temp tablespaces and SSDs, etc.. Jon Nelson

22:14Query Time is Slow Foster, Kristian B (HSC)

22:46Re: Query Time is Slow Kevin Grittner

9 февраля 2013 г.

13:19Re: postgresql.conf recommendations Johnny Tan

13:24Re: postgresql.conf recommendations Johnny Tan

14:51Re: postgresql.conf recommendations Scott Marlowe

19:37Re: postgresql.conf recommendations Josh Krupka

20:16Re: postgresql.conf recommendations Jeff Janes

21:03Re: postgresql.conf recommendations Scott Marlowe

10 февраля 2013 г.

04:03Re: postgresql.conf recommendations Jeff Janes

06:52Re: Slow query even with aggressive auto analyze Amit kapila

11 февраля 2013 г.

12:52Is it correct to optimize a query with subselect in the "where"? Alexandre Riveira

14:57Re: postgresql.conf recommendations Charles Gomes

15:30Re: Partition insert trigger using C language Ali Pouya

22:10Re: postgresql.conf recommendations Johnny Tan

22:57Re: postgresql.conf recommendations Scott Marlowe

23:29Re: postgresql.conf recommendations Will Platnick

12 февраля 2013 г.

13:07Re: numerical primary key vs alphanumerical primary key Julien Cigar

15:05Re: numerical primary key vs alphanumerical primary key Grant Johnson

15:14Re: numerical primary key vs alphanumerical primary key Florent Guillaume

16:26Re: numerical primary key vs alphanumerical primary key Claudio Freire

17:26High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

19:59Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

13 февраля 2013 г.

01:28Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

11:00Re: Partition insert trigger using C language Matheus de Oliveira

13:48connection poolers' db connections Yetkin Öztürk

14:56Re: connection poolers' db connections Kevin Grittner

15:35Re: connection poolers' db connections Yetkin Öztürk

19:24Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

14 февраля 2013 г.

00:26Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

01:30Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

10:28700K Inserts in transaction Asmir Mustafic

10:49PG_XLOG 27028 files running out of space Tory M Blue

11:01Re: PG_XLOG 27028 files running out of space Ian Lawrence Barwick

11:06Re: PG_XLOG 27028 files running out of space Tory M Blue

11:09Re: PG_XLOG 27028 files running out of space Heikki Linnakangas

11:09Re: PG_XLOG 27028 files running out of space Albe Laurenz

11:11Re: PG_XLOG 27028 files running out of space Tory M Blue

11:51Re: 700K Inserts in transaction nik9000@gmail.com

14:07Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Merlin Moncure

15:35Surprising no use of indexes - low performance Nicolas Charles

17:27Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

18:26Re: Surprising no use of indexes - low performance Ireneusz Pluta

18:38Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

19:27Re: Surprising no use of indexes - low performance Jeff Janes

20:41Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

23:58Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

15 февраля 2013 г.

04:32Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

04:47Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe

08:47Re: Partition insert trigger using C language Ali Pouya

09:00Re: Surprising no use of indexes - low performance Nicolas Charles

14:31Very slow update statement on 40mio rows Florian Schröck

14:59Re: Very slow update statement on 40mio rows Kevin Grittner

15:32Re: Very slow update statement on 40mio rows Florian Schröck

18:04Re: Surprising no use of indexes - low performance Jeff Janes

18:26Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

18:52Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe

19:13Re: postgresql.conf recommendations Scott Marlowe

21:27Re: Surprising no use of indexes - low performance Merlin Moncure

16 февраля 2013 г.

00:32Re: temp tablespaces and SSDs, etc.. Bruce Momjian

09:25Re: Surprising no use of indexes - low performance Nicolas Charles

18 февраля 2013 г.

16:45slow query plans caused by under-estimation of CTE cardinality John Lumby

20:40Re: slow query plans caused by under-estimation of CTE cardinality Vitalii Tymchyshyn

23:26Re: slow query plans caused by under-estimation of CTE cardinality John Lumby

19 февраля 2013 г.

00:19Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

00:40Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

00:47Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jon Nelson

00:52Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

03:41Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe

04:23Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood

06:35Speed of exist Bastiaan Olij

07:31Re: Speed of exist Andy

07:36Re: Speed of exist Bastiaan Olij

07:40Re: Speed of exist Pavel Stehule

10:09Re: slow query plans caused by under-estimation of CTE cardinality Tom Lane

10:19Re: Speed of exist Bastiaan Olij

17:51Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

20:04Re: Very slow update statement on 40mio rows Merlin Moncure

23:12Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood

23:24Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

23:33Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood

20 февраля 2013 г.

03:15Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe

22:44Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

21 февраля 2013 г.

03:14Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

09:59Poor performance after update from SLES11 SP1 to SP2 Mark Smith

10:25Re: Poor performance after update from SLES11 SP1 to SP2 Vasilis Ventirozos

10:36Re: Poor performance after update from SLES11 SP1 to SP2 Scott Marlowe

16:23Re: Poor performance after update from SLES11 SP1 to SP2 Sergey Konoplev

16:57Are bitmap index scans slow to start? Carlo Stonebanks

18:19Re: Are bitmap index scans slow to start? Jeff Janes

22 февраля 2013 г.

08:25BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Markus Schulz

13:36Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Heikki Linnakangas

13:38Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Stephen Frost

16:36Avoiding Recheck Cond when using Select Distinct jackrg

17:19Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes

17:51Re: Are bitmap index scans slow to start? Carlo Stonebanks

17:51Re: Are bitmap index scans slow to start? Carlo Stonebanks

17:59Re: Avoiding Recheck Cond when using Select Distinct Vitalii Tymchyshyn

18:10Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Markus Schulz

18:22Bad query plan with high-cardinality column Alexander Staubo

19:05Re: Are bitmap index scans slow to start? Nikolas Everett

19:06Re: Avoiding Recheck Cond when using Select Distinct Maciek Sakrejda

20:05Re: Are bitmap index scans slow to start? Carlo Stonebanks

20:33Re: Bad query plan with high-cardinality column Tom Lane

20:48Re: Bad query plan with high-cardinality column Kevin Grittner

21:31Re: Bad query plan with high-cardinality column Alexander Staubo

21:34Re: Bad query plan with high-cardinality column Alexander Staubo

22:17Re: Bad query plan with high-cardinality column Kevin Grittner

23 февраля 2013 г.

10:10Re: Bad query plan with high-cardinality column Tom Lane

15:58Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Heikki Linnakangas

16:14Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Tom Lane

16:15Are bitmap index scans slow to start? Jeff Janes

17:45Re: Are bitmap index scans slow to start? Jeff Janes

23:53Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes

24 февраля 2013 г.

14:08Server stalls, all CPU 100% system time Andre

14:13Re: Server stalls, all CPU 100% system time Bèrto ëd Sèra

14:39Re: Server stalls, all CPU 100% system time Andre

14:46Re: Server stalls, all CPU 100% system time Tom Lane

16:43Re: Server stalls, all CPU 100% system time Scott Marlowe

25 февраля 2013 г.

17:05Re: Are bitmap index scans slow to start? Carlo Stonebanks

18:11Re: Avoiding Recheck Cond when using Select Distinct Maciek Sakrejda

18:48Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes

22:30Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jeff Frost

26 февраля 2013 г.

08:01Re: Very slow update statement on 40mio rows Florian Schröck

12:53Re: Server stalls, all CPU 100% system time Andre

18:12Re: Are bitmap index scans slow to start? Jeff Janes

19:36Estimation question... Matt Daw

21:30Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jeff Janes

21:46Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe

23:29Re: Server stalls, all CPU 100% system time Josh Berkus

27 февраля 2013 г.

00:33Re: Are bitmap index scans slow to start? Carlo Stonebanks

01:02Re: Server stalls, all CPU 100% system time Scott Marlowe

10:03seqscan on UNION'ed views Dmitry Karasik

10:52Re: Server stalls, all CPU 100% system time Andre

14:21Re: seqscan on UNION'ed views Tom Lane

17:08Re: Estimation question... Matt Daw

18:03Re: Are bitmap index scans slow to start? Jeff Janes

21:38Re: Are bitmap index scans slow to start? Carlo Stonebanks

23:07Re: Server stalls, all CPU 100% system time Josh Berkus

28 февраля 2013 г.

05:12Re: Are bitmap index scans slow to start? Carlo Stonebanks

15:11SELECT is slow on smaller table? Ao Jianwang

15:20Re: SELECT is slow on smaller table? Julien Cigar

16:31Re: Estimation question... Matt Daw

17:00Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe

17:01Wrong actual number of rows in the Query Plan Vahe Evoyan

17:07pgbench intriguing results: better tps figures for larger scale factor Costin Oproiu

17:07Re: Are bitmap index scans slow to start? Gavin Flower

17:08xmlconcat performance Davide Berra

17:08Using a window function in a view Chris Hanks

17:11Bad query plan with high-cardinality column Alexander Staubo

17:12Re: Are bitmap index scans slow to start? Marc Mamin

17:13Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Glyn Astill

17:20Re: pgbench intriguing results: better tps figures for larger scale factor Pavan Deolasee

17:48Re: xmlconcat performance Merlin Moncure

17:58Re: Wrong actual number of rows in the Query Plan Tom Lane

20:14Re: Are bitmap index scans slow to start? Carlo Stonebanks

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