Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance since 2013-01-15 20:11

Prev | Next

2013-01-15

Re: [PERFORM] Slow query: bitmap scan troubles Tom Lane (20:11)
Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer (23:44)

2013-01-17

Re: Performance on Bulk Insert to Partitioned Table Ali Pouya (14:38)
Re: Performance on Bulk Insert to Partitioned Table Charles Gomes (15:01)
Re: Performance on Bulk Insert to Partitioned Table Ali Pouya (16:03)
Re: Insert performance for large transaction with multiple COPY FROM Jeff Janes (18:12)

2013-01-18

Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer (23:15)

2013-01-21

High CPU usage after partitioning rudi (15:05)
Analyze and default_statistics_target AJ Weber (15:29)
Re: Analyze and default_statistics_target Heikki Linnakangas (15:47)
Re: Analyze and default_statistics_target Albe Laurenz (16:00)
Re: High CPU usage after partitioning Merlin Moncure (17:13)
Re: High CPU usage after partitioning Kevin Grittner (21:12)

2013-01-22

Re: High CPU usage after partitioning Andrew Dunstan (00:41)
Re: High CPU usage after partitioning rudi (13:34)
Re: High CPU usage after partitioning Merlin Moncure (14:04)
Re: High CPU usage after partitioning rudi (14:21)
Re: High CPU usage after partitioning Andrew Dunstan (14:46)
Re: High CPU usage after partitioning rudi (15:08)
Re: High CPU usage after partitioning Igor Neyman (15:42)
Re: High CPU usage after partitioning Tom Lane (18:38)
Effect of the WindowAgg on the Nested Loop Виктор Егоров (20:57)

2013-01-23

autovacuum fringe case? AJ Weber (16:53)
Re: autovacuum fringe case? Evgeniy Shishkin (19:03)
Re: autovacuum fringe case? Jeff Janes (19:13)
Re: autovacuum fringe case? Kevin Grittner (22:17)
Re: autovacuum fringe case? AJ Weber (22:48)

2013-01-24

Re: autovacuum fringe case? Alvaro Herrera (02:03)
Re: autovacuum fringe case? Jeff Janes (03:06)

2013-01-25

DML's to tpcw benchmark for postgresql Sachin D. Kotwal (06:38)
Nested loop and simple join query - slow after upgrade to 9.2 alexandre - aldeia digital (15:34)
Re: Nested loop and simple join query - slow after upgrade to 9.2 Jeff Janes (18:29)
Re: Nested loop and simple join query - slow after upgrade to 9.2 alexandre - aldeia digital (19:30)

2013-01-27

PostgreSQL over internet belal hamed (00:15)
Re: PostgreSQL over internet ktm@rice.edu (02:45)
Re: [PERFORM] pgbench to the MAXINT Satoshi Nagayasu (04:24)
Re: PostgreSQL over internet Richard Neill (06:13)
Re: PostgreSQL over internet belal hamed (12:09)
Re: PostgreSQL over internet ktm@rice.edu (17:33)
Re: PostgreSQL over internet David Rowley (20:23)

2013-01-28

Re: PostgreSQL over internet belal hamed (11:15)
Triggers and transactions Craig James (18:54)
Re: Triggers and transactions Richard Huxton (19:10)
Re: Triggers and transactions Rosser Schwarz (19:25)
Re: [PERFORM] pgbench to the MAXINT Gurjeet Singh (21:30)
Re: Simple join doesn't use index Alex Vinnik (23:43)

2013-01-29

Re: Simple join doesn't use index Filip Rembiałkowski (00:55)
Re: Simple join doesn't use index Merlin Moncure (02:31)
Re: [PERFORM] pgbench to the MAXINT Heikki Linnakangas (10:12)
Re: Simple join doesn't use index Alex Vinnik (14:24)
Re: Simple join doesn't use index Alex Vinnik (14:41)
Re: Simple join doesn't use index Filip Rembiałkowski (16:19)
Re: Simple join doesn't use index Merlin Moncure (16:41)
Re: Simple join doesn't use index Ben Chobot (17:39)
Re: Simple join doesn't use index Alex Vinnik (18:59)
Re: Simple join doesn't use index Merlin Moncure (19:35)
Re: Simple join doesn't use index Jeff Janes (20:06)
Re: Simple join doesn't use index Alex Vinnik (20:43)
Re: Simple join doesn't use index Alex Vinnik (20:48)
Re: Simple join doesn't use index Jeff Janes (23:15)

2013-02-01

Fighting the planner >:-( Casey Allen Shobe (17:11)
Re: Fighting the planner >:-( Casey Allen Shobe (17:54)
Re: Fighting the planner >:-( Richard Huxton (18:50)
Re: Fighting the planner >:-( Casey Allen Shobe (19:18)
Re: Fighting the planner >:-( Casey Allen Shobe (21:02)
Re: Fighting the planner >:-( Виктор Егоров (21:12)
Re: Fighting the planner >:-( Casey Allen Shobe (21:18)
Re: Fighting the planner >:-( Виктор Егоров (21:55)
Re: Fighting the planner >:-( Casey Allen Shobe (22:03)
Re: Fighting the planner >:-( Виктор Егоров (22:17)

2013-02-02

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

2013-02-04

Re: Simple join doesn't use index Dan Fairs (21:14)
numerical primary key vs alphanumerical primary key Anne Rosset (21:52)
Re: numerical primary key vs alphanumerical primary key Виктор Егоров (21:57)

2013-02-05

Slow Query Help Will Platnick (03:45)
Re: Slow Query Help Heikki Linnakangas (13:58)
postgresql.conf recommendations Johnny Tan (22:02)
Re: postgresql.conf recommendations Josh Krupka (22:37)
Re: postgresql.conf recommendations Johnny Tan (23:46)

2013-02-06

Re: postgresql.conf recommendations Josh Krupka (04:23)
Re: postgresql.conf recommendations Pavan Deolasee (06:00)
Re: postgresql.conf recommendations ac@hsk.hk (06:18)
Re: Slow Query Help Pavan Deolasee (08:51)
Re: postgresql.conf recommendations Kevin Grittner (12:49)
Re: Slow Query Help Will Platnick (13:17)
Re: postgresql.conf recommendations David Whittaker (15:42)
Re: Slow Query Help Kevin Grittner (16:22)
Re: Slow Query Help Will Platnick (16:24)
Re: Slow Query Help Pavan Deolasee (16:27)
Re: postgresql.conf recommendations Josh Krupka (18:20)
Re: postgresql.conf recommendations David Whittaker (19:13)
Re: postgresql.conf recommendations Johnny Tan (19:33)
Re: postgresql.conf recommendations Johnny Tan (19:45)
Re: postgresql.conf recommendations Johnny Tan (19:47)
Re: postgresql.conf recommendations Jeff Janes (20:12)
Re: postgresql.conf recommendations Josh Krupka (20:27)
Re: postgresql.conf recommendations Kevin Grittner (21:12)

2013-02-07

Re: postgresql.conf recommendations Strahinja Kustudić (12:06)
Re: postgresql.conf recommendations Charles Gomes (14:41)
Re: postgresql.conf recommendations Johnny Tan (17:29)
Re: postgresql.conf recommendations Josh Krupka (17:49)

2013-02-08

FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller (00:52)
Re: FTS performance issue probably due to wrong planner estimate of detoasting Pavel Stehule (05:45)
Re: FTS performance issue probably due to wrong planner estimate of detoasting Jesper Krogh (06:56)
Slow query even with aggressive auto analyze Karolis Pocius (12:36)
Re: FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller (17:30)
temp tablespaces and SSDs, etc.. Jon Nelson (20:52)
Query Time is Slow Foster, Kristian B (HSC) (22:13)
Re: Query Time is Slow Kevin Grittner (22:45)

2013-02-09

Re: postgresql.conf recommendations Johnny Tan (13:19)
Re: postgresql.conf recommendations Johnny Tan (13:24)
Re: postgresql.conf recommendations Scott Marlowe (14:51)
Re: postgresql.conf recommendations Josh Krupka (19:37)
Re: postgresql.conf recommendations Jeff Janes (20:16)
Re: postgresql.conf recommendations Scott Marlowe (21:03)

2013-02-10

Re: postgresql.conf recommendations Jeff Janes (04:02)
Re: Slow query even with aggressive auto analyze Amit kapila (06:52)

2013-02-11

Is it correct to optimize a query with subselect in the "where"? Alexandre Riveira (12:52)
Re: postgresql.conf recommendations Charles Gomes (14:57)
Re: Partition insert trigger using C language Ali Pouya (15:24)
Re: postgresql.conf recommendations Johnny Tan (22:10)
Re: postgresql.conf recommendations Scott Marlowe (22:57)
Re: postgresql.conf recommendations Will Platnick (23:29)

2013-02-12

Re: postgresql.conf recommendations Scott Marlowe (02:54)
Re: numerical primary key vs alphanumerical primary key Julien Cigar (13:06)
Re: numerical primary key vs alphanumerical primary key Grant Johnson (15:05)
Re: numerical primary key vs alphanumerical primary key Florent Guillaume (15:14)
Re: numerical primary key vs alphanumerical primary key Claudio Freire (16:26)
High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan (17:25)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan (19:59)

2013-02-13

Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan (01:28)
Re: Partition insert trigger using C language Matheus de Oliveira (11:00)
connection poolers' db connections Yetkin Öztürk (13:47)
Re: connection poolers' db connections Kevin Grittner (14:56)
Re: connection poolers' db connections Yetkin Öztürk (15:35)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (19:24)

2013-02-14

Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (00:25)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan (01:30)
700K Inserts in transaction Asmir Mustafic (10:28)
PG_XLOG 27028 files running out of space Tory M Blue (10:49)
Re: PG_XLOG 27028 files running out of space Ian Lawrence Barwick (11:01)
Re: PG_XLOG 27028 files running out of space Tory M Blue (11:06)
Re: PG_XLOG 27028 files running out of space Heikki Linnakangas (11:08)
Re: PG_XLOG 27028 files running out of space Albe Laurenz (11:09)
Re: PG_XLOG 27028 files running out of space Tory M Blue (11:11)
Re: 700K Inserts in transaction nik9000 (11:51)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Merlin Moncure (14:07)
Surprising no use of indexes - low performance Nicolas Charles (15:35)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan (17:27)
Re: Surprising no use of indexes - low performance Ireneusz Pluta (18:25)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (18:38)
Re: Surprising no use of indexes - low performance Jeff Janes (19:27)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan (20:41)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (23:57)

2013-02-15

Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan (04:32)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe (04:47)
Re: Partition insert trigger using C language Ali Pouya (08:47)
Re: Surprising no use of indexes - low performance Nicolas Charles (09:00)
Very slow update statement on 40mio rows Florian Schröck (14:30)
Re: Very slow update statement on 40mio rows Kevin Grittner (14:59)
Re: Very slow update statement on 40mio rows Florian Schröck (15:32)
Re: Surprising no use of indexes - low performance Jeff Janes (18:04)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (18:26)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe (18:52)
Re: Surprising no use of indexes - low performance Merlin Moncure (21:27)

2013-02-16

Re: temp tablespaces and SSDs, etc.. Bruce Momjian (00:32)
Re: Surprising no use of indexes - low performance Nicolas Charles (09:25)

2013-02-18

slow query plans caused by under-estimation of CTE cardinality John Lumby (16:45)
Re: slow query plans caused by under-estimation of CTE cardinality Vitalii Tymchyshyn (20:40)
Re: slow query plans caused by under-estimation of CTE cardinality John Lumby (23:26)

2013-02-19

Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (00:19)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (00:39)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jon Nelson (00:46)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (00:51)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe (03:41)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood (04:28)
Speed of exist Bastiaan Olij (06:34)
Re: Speed of exist Andy (07:31)
Re: Speed of exist Bastiaan Olij (07:36)
Re: Speed of exist Pavel Stehule (07:39)
Re: slow query plans caused by under-estimation of CTE cardinality Tom Lane (10:09)
Re: Speed of exist Bastiaan Olij (10:18)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (17:51)
Re: Very slow update statement on 40mio rows Merlin Moncure (20:04)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood (23:17)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (23:24)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood (23:37)

2013-02-20

Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe (03:15)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (22:44)

2013-02-21

Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe (01:15)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus (03:14)
Wrong actual number of rows in the Query Plan Vahe Evoyan (07:24)
Poor performance after update from SLES11 SP1 to SP2 Mark Smith (09:59)
Re: Poor performance after update from SLES11 SP1 to SP2 Vasilis Ventirozos (10:25)
Re: Poor performance after update from SLES11 SP1 to SP2 Scott Marlowe (10:36)
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Glyn Astill (11:24)
Re: Poor performance after update from SLES11 SP1 to SP2 Sergey Konoplev (16:23)
Are bitmap index scans slow to start? Carlo Stonebanks (16:57)
Re: Are bitmap index scans slow to start? Jeff Janes (18:19)
Re: Are bitmap index scans slow to start? Marc Mamin (19:40)

Prev | Next

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group