Mailing lists [pgsql-performance]
- Re: [GENERAL] Can't make backup Sebastián Baioni
- Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Commit takes a long time. Peter Childs
- Re: Commit takes a long time. Pavel Stehule
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Sven Geisler
- Re: Commit takes a long time. Tom Lane
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Alvaro Herrera
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Commit takes a long time. Peter Childs
- Re: Commit takes a long time. Simon Riggs
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores James Mansion
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores David Boreham
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Alvaro Herrera
- concurrent inserts into two separate tables are very slow Sergei Shelukhin
- Re: concurrent inserts into two separate tables are very slow Scott Marlowe
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Re: concurrent inserts into two separate tables are very slow Sergei Shelukhin
- Re: concurrent inserts into two separate tables are very slow Scott Marlowe
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Loss of cache when persistent connexion is closed Guillaume Pungeot
- Re: Loss of cache when persistent connexion is closed Tom Lane
- Performance of aggregates over set-returning functions John Smith
- Re: Performance of aggregates over set-returning functions Tom Lane
- Re: Performance of aggregates over set-returning functions John Smith
- Re: Performance of aggregates over set-returning functions Tom Lane
- After Vacuum Analyse - Procedure performance not improved - Innner select is faster Anoo Sivadasan Pillai
- Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster Alvaro Herrera
- Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster Anoo Sivadasan Pillai
- big database performance Adrian Moisey
- Re: big database performance Joshua D. Drake
- Re: big database performance Frank Habermann
- Search for fixed set of keywords Jörg Kiegeland
- Re: Search for fixed set of keywords Oleg Bartunov
- Re: big database performance Adrian Moisey
- Re: big database performance Alan Hodgson
- Re: big database performance Joshua D. Drake
- Re: big database performance Guillaume Smet
- Re: big database performance Jared Mauch
- Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster Erik Jones
- Re: big database performance Greg Smith
- Re: big database performance Simon Riggs
- Re: big database performance Adrian Moisey
- Re: big database performance Adrian Moisey
- Re: Search for fixed set of keywords Jörg Kiegeland
- Re: big database performance Stephane Bailliez
- Re: Search for fixed set of keywords Oleg Bartunov
- Re: big database performance Jared Mauch
- Re: big database performance Jared Mauch
- not exists clause S Golly
- Re: not exists clause Josh Berkus
- Best way to index IP data? Kevin Kempter
- Re: Best way to index IP data? Joshua D. Drake
- Re: Best way to index IP data? Steve Atkins
- Re: Best way to index IP data? Jonah H. Harris
- Re: not exists clause Guy Rouillier
- Re: Best way to index IP data? Pomarede Nicolas
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Re: Best way to index IP data? Tom Lane
- Re: Best way to index IP data? Andrew Sullivan
- Re: Best way to index IP data? Pomarede Nicolas
- Re: Best way to index IP data? Steve Atkins
- Re: Best way to index IP data? Joshua D. Drake
- Re: Best way to index IP data? Michael Stone
- Evaluating boolean formula: slow performance Jörg Kiegeland
- Re: Evaluating boolean formula: slow performance Jörg Kiegeland
- Re: Best way to index IP data? Tom Lane
- Re: Best way to index IP data? D'Arcy J.M. Cain
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Alvaro Herrera
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Andrew Sullivan
- Re: Best way to index IP data? Steve Atkins
- Re: Best way to index IP data? Pomarede Nicolas
- Re: Best way to index IP data? Andrew Sullivan
- Re: Best way to index IP data? Steve Atkins
- Re: Best way to index IP data? Joshua D. Drake
- Re: Best way to index IP data? Steve Atkins
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Tom Lane
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Joshua D. Drake
- Re: Best way to index IP data? Tom Lane
- Re: Best way to index IP data? Joshua D. Drake
- Re: Best way to index IP data? Michael Stone
- Re: Best way to index IP data? Michael Stone
- Simple select, but takes long time James DeMichele
- Re: Best way to index IP data? Michael Stone
- Re: Simple select, but takes long time Tom Lane
- Re: Best way to index IP data? Greg Smith
- Re: Best way to index IP data? david@lang.hm
- Re: Simple select, but takes long time andrew@pillette.com
- Re: Simple select, but takes long time Tom Lane
- Re: Best way to index IP data? D'Arcy J.M. Cain
- Inheritance, unique keys and performance Julian Scarfe
- Re: Inheritance, unique keys and performance Tom Lane
- Re: Inheritance, unique keys and performance Julian Scarfe
- Re: Inheritance, unique keys and performance Tom Lane
- Re: Inheritance, unique keys and performance Julian Scarfe
- Re: Inheritance, unique keys and performance Tom Lane
- Re: Best way to index IP data? Florian Weimer
- Re: Best way to index IP data? Michael Stone
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Best way to index IP data? Florian Weimer
- Re: Best way to index IP data? Michael Stone
- Seq scans on indexed columns. Yannick Le Guédart
- Re: Seq scans on indexed columns. Guillaume Cottenceau
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Saving result set of SELECT to table column Patric
- Re: Saving result set of SELECT to table column Ansgar -59cobalt- Wiechers
- Re: Seq scans on indexed columns. Shane Ambler
- Re: Saving result set of SELECT to table column Robins Tharakan
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Adrian Moisey
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Tom Lane
- Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list] Doug Knight
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Jakub Ouhrabka
- strange pauses Adrian Moisey
- Re: strange pauses Richard Huxton
- Re: strange pauses Tom Lane
- Re: strange pauses Scott Marlowe
- Re: strange pauses Greg Smith
- Re: strange pauses Adrian Moisey
- Re: strange pauses Brian Herlihy
- Re: strange pauses Scott Marlowe
- [OT] RAID controllers blocking one another? Sean Davis
- Re: [OT] RAID controllers blocking one another? Scott Marlowe
- Re: [OT] RAID controllers blocking one another? Greg Smith
- Re: [OT] RAID controllers blocking one another? Steinar H. Gunderson
- Re: strange pauses Adrian Moisey
- Re: strange pauses Adrian Moisey
- Re: strange pauses Alvaro Herrera
- Re: [OT] RAID controllers blocking one another? Sean Davis
- Re: strange pauses Scott Marlowe
- Re: [OT] RAID controllers blocking one another? Greg Smith
- Re: [OT] RAID controllers blocking one another? Sean Davis
- Re: Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list] Kevin Grittner
- Re: [OT] RAID controllers blocking one another? david@lang.hm
- Slow set-returning functions Dean Rasheed
- Re: Slow set-returning functions Heikki Linnakangas
- Re: Slow set-returning functions Merlin Moncure
- Re: Slow set-returning functions Dean Rasheed
- Re: Slow set-returning functions Tom Lane
- Re: strange pauses Adrian Moisey
- Slow performance with left outer join Marten Verhoeven
- Re: Slow performance with left outer join Pavel Stehule
- Re: Slow performance with left outer join Tom Lane
- Re: Slow performance with left outer join Pavel Stehule
- Re: strange pauses Decibel!
- 8.3 synchronous_commit Hannes Dorbath
- Re: 8.3 synchronous_commit Pavel Stehule
- Re: 8.3 synchronous_commit Jeff Davis
- Re: 8.3 synchronous_commit Greg Smith
- Re: 8.3 synchronous_commit Jeff Davis
- Re: 8.3 synchronous_commit Greg Smith
- Re: 8.3 synchronous_commit Fernando Ike
- scheduler Adrian Moisey
- Re: scheduler Claus Guttesen
- Re: scheduler Adrian Moisey
- Re: 8.3 synchronous_commit Florian Weimer
- Re: scheduler david@lang.hm
- Re: scheduler Luke Lonergan
- Re: 8.3 synchronous_commit Guillaume Smet
- Re: 8.3 synchronous_commit Florian Weimer
- Re: 8.3 synchronous_commit Hannes Dorbath
- Re: 8.3 synchronous_commit Hannes Dorbath
- Optimizing queries that use temporary tables Luiz K. Matsumura
- Re: SELECT * FROM table is too slow Luiz K. Matsumura
- Re: SELECT * FROM table is too slow Joshua D. Drake
- Re: Optimizing queries that use temporary tables Scott Marlowe
- Workaround for cross column stats dependency Guillaume Smet
- Re: Workaround for cross column stats dependency Tom Lane
- Re: Workaround for cross column stats dependency Guillaume Smet
- Making the most of memory? Joshua Fielek
- Re: Making the most of memory? Scott Marlowe
- Re: SELECT * FROM table is too slow Guillaume Cottenceau
- Re: Workaround for cross column stats dependency Guillaume Smet
- *_cost recommendation with 8.3 and a fully cached db Guillaume Smet
- planner chooses unoptimal plan on joins with complex key Dmitry Potapov
- Re: planner chooses unoptimal plan on joins with complex key Guillaume Smet
- Re: Making the most of memory? Bill Moran
- Re: planner chooses unoptimal plan on joins with complex key Tom Lane
- Postgres 8.2 memory weirdness Tory M Blue
- Vacuum and FSM page size Thomas Lozza
- Re: Making the most of memory? Scott Marlowe
- Re: Making the most of memory? Rich
- Re: Vacuum and FSM page size Vivek Khera
- Re: Making the most of memory? Guy Rouillier
- Re: Vacuum and FSM page size Tom Lane
- Re: Making the most of memory? A.M.
- Re: Making the most of memory? Brian Hurt
- Re: Making the most of memory? Craig James
- Re: Postgres 8.2 memory weirdness Greg Smith
- Re: Making the most of memory? Greg Smith
- Re: Making the most of memory? Scott Marlowe
- Re: Making the most of memory? Steinar H. Gunderson
- Re: Making the most of memory? Heikki Linnakangas
- Re: Making the most of memory? Merlin Moncure
- Re: Making the most of memory? Matthew
- Re: Making the most of memory? Florian Weimer
- Re: Vacuum and FSM page size Scott Marlowe
- Re: Making the most of memory? Chris Browne
- Re: Making the most of memory? Chris Browne
- Re: Postgres 8.2 memory weirdness Tory M Blue
- Configuration settings (shared_buffers, etc) in Linux: puzzled Rick Schumeyer
- Re: Making the most of memory? Merlin Moncure
- Re: Making the most of memory? Merlin Moncure
- Re: Postgres 8.2 memory weirdness Greg Smith
- Re: Configuration settings (shared_buffers, etc) in Linux: puzzled Greg Smith
- 8.3rc1 Out of memory when performing update Stephen Denne
- Re: 8.3rc1 Out of memory when performing update Fernando Ike
- Re: Configuration settings (shared_buffers, etc) in Linux: puzzled Fernando Ike
- Re: planner chooses unoptimal plan on joins with complex key Tom Lane
- Re: 8.3rc1 Out of memory when performing update Tom Lane
- Re: 8.3rc1 Out of memory when performing update Stephen Denne
- Re: 8.3rc1 Out of memory when performing update Tom Lane
- Re: Making the most of memory? Florian Weimer
- Re: 8.3rc1 Out of memory when performing update Stephen Denne
- 1 or 2 servers for large DB scenario. David Brain
- Re: 1 or 2 servers for large DB scenario. Greg Smith
- Re: 1 or 2 servers for large DB scenario. Matthew
- Re: 1 or 2 servers for large DB scenario. Matthew
- Re: Postgres 8.2 memory weirdness Tory M Blue
- Re: 8.3rc1 Out of memory when performing update cgallant@gmail.com
- Re: 8.3rc1 Out of memory when performing update Roberts, Jon
- Re: 8.3rc1 Out of memory when performing update Magnus Hagander
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Simon Riggs
- How do I bulk insert to a table without affecting read performance on that table? growse
- Re: How do I bulk insert to a table without affecting read performance on that table? Scott Marlowe
- Re: How do I bulk insert to a table without affecting read performance on that table? growse
- Re: How do I bulk insert to a table without affecting read performance on that table? Scott Marlowe
- Re: 1 or 2 servers for large DB scenario. Heikki Linnakangas
- Re: Slow set-returning functions Dean Rasheed
- Re: Slow set-returning functions Marcin Stępnicki
- Re: 8.3rc1 Out of memory when performing update Stephen Denne
- Re: Slow set-returning functions Merlin Moncure
- Re: Vacuum and FSM page size Thomas Lozza
- Re: Vacuum and FSM page size Scott Marlowe
- Re: Postgres 8.2 memory weirdness Greg Smith
- Re: 1 or 2 servers for large DB scenario. Jignesh K. Shah
- Re: 8.3rc1 Out of memory when performing update Tom Lane
- Re: 1 or 2 servers for large DB scenario. Merlin Moncure
- Re: 8.3rc1 Out of memory when performing update Stephen Denne
- Re: Postgres 8.2 memory weirdness Tory M Blue
- Re: 8.3rc1 Out of memory when performing update Guillaume Smet
- Performance issues migrating from 743 to 826 Matthew Lunnon
- Performance problems inside a stored procedure. Matthew Lunnon
- Re: Performance problems inside a stored procedure. Heikki Linnakangas
- Re: Performance problems inside a stored procedure. Matthew Lunnon
- Re: Slow set-returning functions Dean Rasheed
- Re: Performance issues migrating from 743 to 826 Gregory Stark
- Hard Drive Usage for Speeding up Big Queries Alex Hochberger
- Re: Linux/PostgreSQL scalability issue - problem with 8 cores Matthew
- Re: Performance issues migrating from 743 to 826 Scott Marlowe
- Re: Hard Drive Usage for Speeding up Big Queries Scott Marlowe
- Re: Performance issues migrating from 743 to 826 Matthew Lunnon
- Re: Performance issues migrating from 743 to 826 Scott Marlowe
- Re: Performance issues migrating from 743 to 826 Matthew Lunnon
- Re: Performance issues migrating from 743 to 826 Matthew Lunnon
- JDBC/Stored procedure performance issue Claire McLister
- 8x2.5" or 6x3.5" disks Christian Nicolaisen
- Re: Vacuum and FSM page size Decibel!
- Re: 8x2.5" or 6x3.5" disks Arjen van der Meijden
- Re: JDBC/Stored procedure performance issue Tom Lane
- Re: Hard Drive Usage for Speeding up Big Queries Merlin Moncure
- Re: 8x2.5" or 6x3.5" disks david@lang.hm
- Re: 8x2.5" or 6x3.5" disks Claus Guttesen
- Re: JDBC/Stored procedure performance issue Matthew Lunnon
- Re: 8x2.5" or 6x3.5" disks Arjen van der Meijden
- Re: 8x2.5" or 6x3.5" disks Mike Smith
- Re: Performance problems inside a stored procedure. Euler Taveira de Oliveira
- analyze Adrian Moisey
- Re: RAID arrays and performance Gregory Stark
- Re: 8x2.5" or 6x3.5" disks Scott Marlowe
- Re: 8x2.5" or 6x3.5" disks Craig James
- Re: RAID arrays and performance Matthew
- Re: planner chooses unoptimal plan on joins with complex key Dmitry Potapov
- Re: RAID arrays and performance Gregory Stark
- Re: RAID arrays and performance Kevin Grittner
- Re: RAID arrays and performance Gregory Stark
- Re: RAID arrays and performance Kevin Grittner
- Re: Performance problems inside a stored procedure. Matthew Lunnon
- Re: JDBC/Stored procedure performance issue Tom Lane
- Re: analyze Andrew Sullivan
- Re: analyze Scott Marlowe
- Re: 8x2.5" or 6x3.5" disks Mike Smith
- Re: planner chooses unoptimal plan on joins with complex key Tom Lane
- Re: planner chooses unoptimal plan on joins with complex key Dmitry Potapov
- Re: JDBC/Stored procedure performance issue Claire McLister