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 - October 2012

Prev | Next

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

2012-10-01

Re: Postgres becoming slow, only full vacuum fixes it Igor Neyman (14:09)
deadlock_timeout affect on performance pg noob (16:49)
A Tale of 2 algorithms Colin Taylor (21:24)
Re: NestedLoops over BitmapScan question Виктор Егоров (23:09)

2012-10-02

Re: Inserts in 'big' table slowing down the database Stefan Keller (00:15)
Re: Inserts in 'big' table slowing down the database Greg Williamson (00:35)
Re: A Tale of 2 algorithms Craig Ringer (04:54)
Re: deadlock_timeout affect on performance Heikki Linnakangas (08:11)
Re: hardware advice Glyn Astill (08:20)
Re: hardware advice - opinions about HP? Franklin, Dan (FEN) (14:51)
Re: Inserts in 'big' table slowing down the database Shaun Thomas (15:09)
Re: hardware advice - opinions about HP? Bruce Momjian (15:14)
Re: hardware advice David Boreham (15:14)
Re: hardware advice - opinions about HP? Scott Marlowe (16:01)
suboptimal query plan Nick Hofstede (16:46)

2012-10-03

Re: suboptimal query plan Tom Lane (03:54)
Re: suboptimal query plan Nick Hofstede (08:02)
Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets Andrea Suisani (11:45)
Re: hardware advice Glyn Astill (11:56)
Re: Postgres becoming slow, only full vacuum fixes it Kiriakos Tsourapas (13:39)
Re: Inserts in 'big' table slowing down the database Jeff Janes (19:35)

2012-10-04

how to avoid deadlock on masive update with multiples delete Anibal David Acosta (14:01)
Re: how to avoid deadlock on masive update with multiples delete Jeff Janes (16:10)

2012-10-05

Re: A Tale of 2 algorithms Colin Taylor (00:34)
Re: how to avoid deadlock on masive update with multiples delete Igor Neyman (14:06)
Re: how to avoid deadlock on masive update with multiples delete Claudio Freire (14:27)
Re: how to avoid deadlock on masive update with multiples delete Maciek Sakrejda (15:08)
Re: how to avoid deadlock on masive update with multiples delete Tom Lane (15:31)
Re: how to avoid deadlock on masive update with multiples delete Andres Freund (15:36)
Re: how to avoid deadlock on masive update with multiples delete Tom Lane (15:46)
Re: how to avoid deadlock on masive update with multiples delete Merlin Moncure (15:55)
Re: how to avoid deadlock on masive update with multiples delete Claudio Freire (15:58)
Re: how to avoid deadlock on masive update with multiples delete Tom Lane (16:21)
Re: how to avoid deadlock on masive update with multiples delete Andres Freund (16:33)
Re: how to avoid deadlock on masive update with multiples delete Anibal David Acosta (18:33)

2012-10-07

UPDATE execution time is increasing virag (13:49)
Re: Same query doing slow then quick Ants Aasma (14:27)
Re: Guide to Posting Slow Query Questions Ants Aasma (14:43)
hash aggregation speedup Korisk (17:33)

2012-10-08

Re: Same query doing slow then quick Undertaker Rude (07:39)
Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki (08:18)
Re: Strange behavior after upgrade from 9.0 to 9.2 Craig Ringer (10:15)
Re: Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki (11:40)
Re: UPDATE execution time is increasing Valentine Gogichashvili (12:20)
Re: [repost] Help me develop new commit_delay advice Peter Geoghegan (12:38)
Re: Strange behavior after upgrade from 9.0 to 9.2 Tom Lane (14:52)
Scaling 10 million records in PostgreSQL table Navaneethan R (15:26)
Re: Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki (15:41)
Re: Strange behavior after upgrade from 9.0 to 9.2 Tom Lane (15:56)
Re: Strange behavior after upgrade from 9.0 to 9.2 Andrzej Zawadzki (16:14)
Re: Scaling 10 million records in PostgreSQL table Merlin Moncure (19:50)
Re: Scaling 10 million records in PostgreSQL table Julien Cigar (19:52)
Re: Scaling 10 million records in PostgreSQL table Larry Rosenman (19:53)
Re: Scaling 10 million records in PostgreSQL table Steve Crawford (20:09)
Re: Scaling 10 million records in PostgreSQL table Navaneethan R (20:25)
Re: Scaling 10 million records in PostgreSQL table Craig Ringer (20:27)
Two identical systems, radically different performance Craig James (21:45)
Re: Two identical systems, radically different performance Evgeny Shishkin (21:57)
Re: Two identical systems, radically different performance Craig James (22:06)
Re: Two identical systems, radically different performance Evgeny Shishkin (22:08)
Re: Two identical systems, radically different performance Claudio Freire (22:09)
Re: Two identical systems, radically different performance Steve Crawford (22:16)
Re: Two identical systems, radically different performance Craig James (22:25)
Re: Two identical systems, radically different performance Imre Samu (22:28)
Re: Two identical systems, radically different performance Craig James (22:29)
Re: Two identical systems, radically different performance Evgeny Shishkin (22:33)
Re: Two identical systems, radically different performance Craig James (22:42)
Re: Scaling 10 million records in PostgreSQL table Samuel Gendler (22:42)
Re: Two identical systems, radically different performance Claudio Freire (22:44)
Re: Two identical systems, radically different performance Evgeny Shishkin (22:46)
Re: Two identical systems, radically different performance Craig James (22:48)
Re: Two identical systems, radically different performance Claudio Freire (22:50)
Re: Two identical systems, radically different performance Craig James (23:03)
Re: Two identical systems, radically different performance Mark Kirkwood (23:10)
Re: Two identical systems, radically different performance Claudio Freire (23:12)
Re: Two identical systems, radically different performance Tomas Vondra (23:16)
Re: Two identical systems, radically different performance Tomas Vondra (23:24)
Re: Two identical systems, radically different performance Evgeny Shishkin (23:30)
Re: Two identical systems, radically different performance Craig James (23:40)
Re: Two identical systems, radically different performance Gavin Flower (23:52)

2012-10-09

Re: Two identical systems, radically different performance Ants Aasma (00:00)
Re: Two identical systems, radically different performance Yeb Havinga (11:20)
Re: Two identical systems, radically different performance Shaun Thomas (16:02)
Re: Two identical systems, radically different performance David Thomas (16:14)
Re: Two identical systems, radically different performance Craig James (16:41)
Re: Two identical systems, radically different performance Craig James (16:43)
Hyperthreading (was: Two identical systems, radically different performance) Craig James (20:12)
Re: Hyperthreading (was: Two identical systems, radically different performance) Tom Lane (20:53)
Re: Hyperthreading (was: Two identical systems, radically different performance) Shaun Thomas (20:56)
Re: Hyperthreading (was: Two identical systems, radically different performance) Josh Berkus (20:56)
Re: Hyperthreading (was: Two identical systems, radically different performance) Jeff Janes (21:24)
Ways to speed up ts_rank Shane Hathaway (21:38)
Re: Scaling 10 million records in PostgreSQL table Samuel Gendler (21:47)
Re: Scaling 10 million records in PostgreSQL table Daniel Farina (21:49)
Why am I getting great/terrible estimates with these CTE queries? Tomas Vondra (22:21)
Re: Why am I getting great/terrible estimates with these CTE queries? Tom Lane (23:09)
Re: Hyperthreading (was: Two identical systems, radically different performance) Craig James (23:30)

2012-10-10

Re: Why am I getting great/terrible estimates with these CTE queries? Tomas Vondra (00:19)
shared_buffers/effective_cache_size on 96GB server Strahinja Kustudić (07:12)
Re: shared_buffers/effective_cache_size on 96GB server Strahinja Kustudić (07:18)
Re: shared_buffers/effective_cache_size on 96GB server Tomas Vondra (07:32)
Re: shared_buffers/effective_cache_size on 96GB server Albe Laurenz (07:39)
Re: shared_buffers/effective_cache_size on 96GB server Julien Cigar (08:11)
Re: shared_buffers/effective_cache_size on 96GB server Strahinja Kustudić (08:30)
Re: shared_buffers/effective_cache_size on 96GB server Julien Cigar (08:52)
Re: shared_buffers/effective_cache_size on 96GB server Strahinja Kustudić (11:33)
Re: Ways to speed up ts_rank François Beausoleil (12:38)
Re: Hyperthreading (was: Two identical systems, radically different performance) Shaun Thomas (12:52)
Re: shared_buffers/effective_cache_size on 96GB server Shaun Thomas (13:09)
Re: shared_buffers/effective_cache_size on 96GB server Shaun Thomas (14:38)
Re: shared_buffers/effective_cache_size on 96GB server Strahinja Kustudić (14:49)
Re: shared_buffers/effective_cache_size on 96GB server Shaun Thomas (14:54)
Re: Hyperthreading (was: Two identical systems, radically different performance) Bruce Momjian (15:46)
Re: shared_buffers/effective_cache_size on 96GB server Bruce Momjian (16:05)
hash aggregation Korisk (16:09)
Re: shared_buffers/effective_cache_size on 96GB server Bruce Momjian (16:10)
Re: shared_buffers/effective_cache_size on 96GB server Claudio Freire (17:05)
Drawbacks of create index where is not null ? Franck Routier (17:06)
Re: Hyperthreading (was: Two identical systems, radically different performance) Craig James (17:28)
Re: shared_buffers/effective_cache_size on 96GB server Bruce Momjian (17:56)
Re: Hyperthreading (was: Two identical systems, radically different performance) Claudio Freire (18:08)
Re: shared_buffers/effective_cache_size on 96GB server Shaun Thomas (18:18)
Re: shared_buffers/effective_cache_size on 96GB server Claudio Freire (18:24)
Re: Ways to speed up ts_rank Shane Hathaway (18:25)
Re: Ways to speed up ts_rank Shane Hathaway (18:32)
Re: shared_buffers/effective_cache_size on 96GB server Jeff Janes (19:30)
Re: shared_buffers/effective_cache_size on 96GB server Strahinja Kustudić (20:12)
Re: shared_buffers/effective_cache_size on 96GB server Claudio Freire (20:48)
Re: shared_buffers/effective_cache_size on 96GB server Bruce Momjian (21:03)
Re: hash aggregation Sergey Konoplev (21:30)
Re: shared_buffers/effective_cache_size on 96GB server Ondrej Ivanič (22:06)
Re: shared_buffers/effective_cache_size on 96GB server Claudio Freire (22:14)
Re: shared_buffers/effective_cache_size on 96GB server Jeff Janes (22:33)
Re: shared_buffers/effective_cache_size on 96GB server Claudio Freire (22:37)

2012-10-11

Re: hash aggregation Korisk (04:13)
Re: hash aggregation Craig Ringer (04:38)
Re: Drawbacks of create index where is not null ? Craig Ringer (05:26)
Re: shared_buffers/effective_cache_size on 96GB server Scott Marlowe (05:36)
Re: Drawbacks of create index where is not null ? Scott Marlowe (05:42)
Re: Drawbacks of create index where is not null ? Scott Marlowe (05:44)
Re: hash aggregation Sergey Konoplev (06:15)
Re: Drawbacks of create index where is not null ? Franck Routier (08:22)
Re: Two identical systems, radically different performance Andrea Suisani (14:14)
Re: Two identical systems, radically different performance Claudio Freire (14:19)
Re: Two identical systems, radically different performance Andrea Suisani (14:40)
Re: hash aggregation Korisk (15:15)
Re: hash aggregation Sergey Konoplev (17:55)
Re: shared_buffers/effective_cache_size on 96GB server Josh Berkus (18:17)
Re: problems with large objects dump Sergio Gabriel Rodriguez (21:46)
Re: problems with large objects dump Tom Lane (22:16)
Re: problems with large objects dump Marcos Ortiz (22:26)
Re: Drawbacks of create index where is not null ? Sergey Konoplev (22:31)

2012-10-12

Re: hash aggregation Korisk (03:55)
Re: hash aggregation Sergey Konoplev (04:01)
Re: hash aggregation Korisk (04:14)
Re: hash aggregation Ondrej Ivanič (04:32)
Re: hash aggregation Sergey Konoplev (07:10)
Re: hash aggregation Korisk (14:37)
Do cast affects index usage? Anibal David Acosta (20:05)
Re: Do cast affects index usage? Scott Marlowe (20:37)
Re: Do cast affects index usage? Tom Lane (20:38)
Re: hash aggregation Tomas Vondra (21:14)
Re: hash aggregation Tomas Vondra (21:28)
Re: problems with large objects dump Sergio Gabriel Rodriguez (22:35)
Re: problems with large objects dump Tom Lane (23:18)

2012-10-13

Re: Do cast affects index usage? Anibal David Acosta (00:27)
Re: problems with large objects dump Tom Lane (01:31)
Re: Do cast affects index usage? Tom Lane (01:34)

2012-10-14

Index over all partitions (aka global index)? Stefan Keller (00:43)
Re: Index over all partitions (aka global index)? Jeff Janes (05:39)
Query with limit goes from few ms to hours henk de wit (06:55)
Re: Query with limit goes from few ms to hours henk de wit (07:04)
Re: Index over all partitions (aka global index)? Stefan Keller (12:22)
Re: Query with limit goes from few ms to hours Tom Lane (16:15)

2012-10-15

Re: Memory issues Shiran Kleiderman (00:45)
Mapping PostgreSQL data types to DB2 Federated Server Alexander Gataric (00:52)
Re: Mapping PostgreSQL data types to DB2 Federated Server John R Pierce (01:05)
Re: Memory issues Shiran Kleiderman (02:36)
WebSphere Application Server support for postgres John Nash (08:22)
Re: Two identical systems, radically different performance Andrea Suisani (08:27)
Re: WebSphere Application Server support for postgres Dave Page (08:28)
Re: problems with large objects dump Sergio Gabriel Rodriguez (10:19)
Re: WebSphere Application Server support for postgres lst_hoe02 (11:30)
Re: Query with limit goes from few ms to hours Robert Klemme (12:31)
Re: Two identical systems, radically different performance Craig James (15:01)
Re: Two identical systems, radically different performance Claudio Freire (15:01)
Re: Two identical systems, radically different performance Andrea Suisani (15:24)
Re: Two identical systems, radically different performance Claudio Freire (15:28)
Re: Two identical systems, radically different performance Scott Marlowe (15:32)
Re: Two identical systems, radically different performance Scott Marlowe (15:34)
Re: Two identical systems, radically different performance Andrea Suisani (15:45)
Re: Two identical systems, radically different performance Andrea Suisani (15:56)
Re: Two identical systems, radically different performance Andrea Suisani (15:56)
Re: WebSphere Application Server support for postgres Joshua D. Drake (17:18)
limit order by performance issue Pedro Jiménez (17:44)
Re: Query with limit goes from few ms to hours henk de wit (17:50)
SELECT AND AGG huge tables houmanb (20:59)
Re: SELECT AND AGG huge tables Merlin Moncure (21:09)
Re: SELECT AND AGG huge tables Matheus de Oliveira (21:42)
Re: SELECT AND AGG huge tables Ondrej Ivanič (21:54)

Prev | Next

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

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