• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2004-11 Thread Index (2/3)

• Main Index
• [Prev Page]
• [Next Page]

• Efficient way to remove OID data James Gunzelman (Tue 16 15:58)
• Tsearch2 really slower than ilike ? Hervé Piedvache (Tue 16 14:56)
• Re: Tsearch2 really slower than ilike ? Michael Fuhr (Tue 16 15:33)
• Re: Tsearch2 really slower than ilike ? Hervé Piedvache (Tue 16 15:48)
• Re: Tsearch2 really slower than ilike ? Joshua D. Drake (Tue 16 16:05)
• Re: Tsearch2 really slower than ilike ? Oleg Bartunov (Tue 16 16:27)
• Re: Tsearch2 really slower than ilike ? Oleg Bartunov (Tue 16 16:18)
• Re: Tsearch2 really slower than ilike ? Joshua D. Drake (Tue 16 16:07)
• Re: Tsearch2 really slower than ilike ? Hervé Piedvache (Tue 16 16:21)
• Re: Tsearch2 really slower than ilike ? Oleg Bartunov (Tue 16 21:13)
• Re: Tsearch2 really slower than ilike ? Hervé Piedvache (Wed 17 17:16)
• Re: Tsearch2 really slower than ilike ? Oleg Bartunov (Wed 17 17:23)
• Re: Tsearch2 really slower than ilike ? Hervé Piedvache (Thu 18 09:27)
• Re: Tsearch2 really slower than ilike ? Oleg Bartunov (Thu 18 09:37)
• Re: Tsearch2 really slower than ilike ? Hervé Piedvache (Thu 18 10:30)
• Re: Tsearch2 really slower than ilike ? Oleg Bartunov (Thu 18 10:34)
• <Possible follow-ups>
• Re: Tsearch2 really slower than ilike ? Leeuw van der, Tim (Thu 18 10:53)
• mis-estimation on data-warehouse aggregate creation Kris Jurka (Tue 16 09:09)
• Re: mis-estimation on data-warehouse aggregate creation F. Senault (Tue 16 10:56)
• Re: mis-estimation on data-warehouse aggregate creation Kris Jurka (Tue 16 19:49)
• Re: mis-estimation on data-warehouse aggregate creation Simon Riggs (Tue 16 21:33)
• Re: mis-estimation on data-warehouse aggregate creation Kris Jurka (Wed 17 08:19)
• Performance difference: SELECT from VIEW or not? Alexandre Leclerc (Mon 15 23:10)
• Re: Performance difference: SELECT from VIEW or not? Tom Lane (Mon 15 23:30)
• Why distinct so slow ? Hervé Piedvache (Mon 15 21:23)
• Question on pgsql optimisation of SQL and structure (index, etc) Alexandre Leclerc (Mon 15 17:48)
• Re: Question on pgsql optimisation of SQL and structure (index, etc) Josh Berkus (Mon 15 21:01)
• Re: Large Database Performance suggestions Andrew Hammond (Mon 15 15:23)
• Some quick Opteron 32-bit/64-bit results William Yu (Sat 13 23:24)
• Re: Some quick Opteron 32-bit/64-bit results Gustavo Franklin Nóbrega (Sun 14 00:14)
• Re: Some quick Opteron 32-bit/64-bit results William Yu (Sun 14 00:54)
• Re: Some quick Opteron 32-bit/64-bit results William Yu (Sun 14 00:24)
• Re: Some quick Opteron 32-bit/64-bit results Greg Stark (Mon 15 07:04)
• Re: Some quick Opteron 32-bit/64-bit results William Yu (Mon 15 07:55)
• Re: Some quick Opteron 32-bit/64-bit results Cott Lang (Tue 23 17:20)
• Insertion puzzles vivek singh (Sat 13 11:26)
• Re: Insertion puzzles Andreas Åkre Solberg (Sat 13 13:31)
• Re: Insertion puzzles Dave Cramer (Sat 13 16:53)
• Re: Insertion puzzles Stephan Szabo (Sat 13 17:13)
• Re: Insertion puzzles Josh Berkus (Sun 14 01:37)
• Re: Insertion puzzles Dave Cramer (Mon 15 00:44)
• <Possible follow-ups>
• Re: Insertion puzzles dentfirst13(at)earthlink(dot)net (Sun 14 02:00)
• Re: Insertion puzzles J. Andrew Rogers (Tue 16 19:43)
• Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus (Fri 12 18:39)
• Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane (Fri 12 19:20)
• Re: Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus (Fri 12 21:08)
• Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane (Fri 12 21:19)
• int4 in a GiST index Mike Rylander (Wed 10 21:51)
• <Possible follow-ups>
• Re: int4 in a GiST index George Essig (Thu 11 02:50)
• Re: int4 in a GiST index Mike Rylander (Thu 11 05:53)
• Solaris 9 Tuning Tips requested Rod Taylor (Wed 10 17:06)
• Tuning suggestions wanted Rod Taylor (Wed 10 16:54)
• Re: How to speed-up inserts with jdbc Leeuw van der, Tim (Wed 10 14:27)
• simple select-statement takes more than 25 sec Cao Duy (Wed 10 09:36)
• Re: simple select-statement takes more than 25 sec Steinar H. Gunderson (Wed 10 10:17)
• Re: simple select-statement takes more than 25 sec Cao Duy (Wed 10 11:22)
• Re: simple select-statement takes more than 25 sec Steinar H. Gunderson (Wed 10 11:45)
• Re: simple select-statement takes more than 25 sec gnari (Wed 10 10:29)
• seqscan strikes again Jim C. Nasby (Tue 09 22:52)
• Re: seqscan strikes again Joshua D. Drake (Tue 09 23:14)
• Re: seqscan strikes again Jim C. Nasby (Wed 10 17:01)
• Re: seqscan strikes again Tom Lane (Tue 09 23:24)
• Re: seqscan strikes again Gaetano Mendola (Thu 11 17:06)
• Need advice on postgresql.conf settings Shane | SkinnyCorp (Tue 09 19:01)
• Re: Need advice on postgresql.conf settings Tom Lane (Tue 09 21:57)
• Re: Need advice on postgresql.conf settings Sean Chittenden (Tue 09 22:44)
• Re: Need advice on postgresql.conf settings Jeff (Wed 10 13:04)
• How to speed-up inserts with jdbc Michael Kleiser (Wed 10 13:52)
• Re: How to speed-up inserts with jdbc Jeff (Wed 10 13:55)
• Re: How to speed-up inserts with jdbc Dave Cramer (Wed 10 14:04)
• Re: How to speed-up inserts with jdbc Edwin Eyan Moragas (Thu 11 08:04)
• Re: How to speed-up inserts with jdbc Steinar H. Gunderson (Thu 11 17:06)
• Re: How to speed-up inserts with jdbc Edwin Eyan Moragas (Thu 11 21:11)
• Slow performance with Group By Erik Norvelle (Tue 09 00:10)
• Re: Slow performance with Group By Tom Lane (Tue 09 00:56)
• ext3 journalling type Dawid Kuroczko (Mon 08 12:26)
• Re: ext3 journalling type Bruce Momjian (Mon 08 14:05)
• Re: ext3 journalling type Matt Clark (Mon 08 15:14)
• Re: ext3 journalling type Josh Berkus (Mon 08 17:39)
• Re: ext3 journalling type Mark Wong (Mon 08 16:30)
• Postgresql is using seqscan when is should use indexes. Andreas Åkre Solberg (Mon 08 10:40)
• Re: Postgresql is using seqscan when is should use indexes. Russell Smith (Mon 08 12:07)
• DISTINCT and GROUP BY: possible performance enhancement? Ang Chin Han (Sun 07 11:04)
• poor performance in migrated database Carlos Lopez (Sat 06 19:52)
• Re: poor performance in migrated database Troels Arvin (Sat 06 20:07)
• Re: poor performance in migrated database Troels Arvin (Sat 06 20:41)
• Re: poor performance in migrated database Simon Riggs (Sat 06 21:41)
• Re: [ADMIN] poor performance in migrated database Carlos Lopez (Mon 08 21:28)
• Re: [ADMIN] poor performance in migrated database Tom Lane (Mon 08 23:58)
• Re: [ADMIN] poor performance in migrated database Carlos Lopez (Tue 09 14:56)
• Re: poor performance in migrated database Scott Marlowe (Sat 06 21:58)
• ia64 results with dbt2 and 8.0beta4 Mark Wong (Fri 05 23:13)
• Question regarding the file system Gabriele Bartolini (Fri 05 21:00)
• Re: Question regarding the file system Josh Berkus (Mon 08 17:45)
• Message not available
  • Re: Question regarding the file system Josh Berkus (Tue 09 01:28)
• What is the difference between these? Matt Nuzum (Fri 05 18:09)
• Re: What is the difference between these? Matthew T. O'Connor (Fri 05 19:44)
• Re: What is the difference between these? Tom Lane (Fri 05 20:32)
• postgresql amd-64 Merlin Moncure (Fri 05 15:34)
• Re: postgresql amd-64 Daniel Ceregatti (Fri 05 18:23)
• Re: postgresql amd-64 Iain (Mon 08 02:12)
• Message not available
  • Re: postgresql amd-64 Iain (Mon 08 07:36)
• Re: postgresql amd-64 Radu-Adrian Popescu (Mon 08 11:40)
• <Possible follow-ups>
• Re: postgresql amd-64 Merlin Moncure (Fri 05 21:17)
• Re: postgresql amd-64 Vishal Kashyap @ [Sai Hertz And Control Systems] (Sat 06 03:02)
• Re: postgresql amd-64 Merlin Moncure (Mon 08 13:20)
• Strange (?) Index behavior? Allen Landsidel (Fri 05 14:39)
• Re: Strange (?) Index behavior? Matt Clark (Fri 05 15:06)
• Re: Strange (?) Index behavior? Rod Taylor (Fri 05 15:09)
• Re: Strange (?) Index behavior? Allen Landsidel (Fri 05 15:32)
• Re: Strange (?) Index behavior? Allen Landsidel (Fri 05 16:54)
• Re: Strange (?) Index behavior? Bruno Wolff III (Fri 05 17:40)
• Re: Strange (?) Index behavior? Allen Landsidel (Fri 05 17:56)
• Re: Strange (?) Index behavior? Matt Clark (Fri 05 18:34)
• Re: Strange (?) Index behavior? Allen Landsidel (Fri 05 21:02)
• Re: Strange (?) Index behavior? Matt Clark (Sat 06 00:14)
• Re: Strange (?) Index behavior? Tom Lane (Sat 06 04:04)
• Re: Strange (?) Index behavior? Allen Landsidel (Sat 06 07:27)
• Re: Strange (?) Index behavior? Allen Landsidel (Thu 11 17:56)
• Re: Strange (?) Index behavior? Josh Berkus (Thu 11 18:50)
• Re: Strange (?) Index behavior? Allen Landsidel (Thu 11 19:31)
• Re: Strange (?) Index behavior? Greg Stark (Thu 11 20:49)
• Re: Strange (?) Index behavior? Allen Landsidel (Thu 11 21:13)
• Re: Strange (?) Index behavior? Tom Lane (Thu 11 21:42)
• Re: Strange (?) Index behavior? Allen Landsidel (Fri 12 20:12)
• Re: Strange (?) Index behavior? Tom Lane (Fri 12 22:35)
• Re: Strange (?) Index behavior? Allen Landsidel (Sat 13 03:02)
• Re: Strange (?) Index behavior? Allen Landsidel (Mon 15 22:22)
• Re: Strange (?) Index behavior? Joshua D. Drake (Thu 11 21:48)
• Re: Strange (?) Index behavior? Tom Lane (Fri 05 19:57)
• Re: Strange (?) Index behavior? Allen Landsidel (Fri 05 20:36)
• Re: Strange (?) Index behavior? Tom Lane (Fri 05 21:09)
• Message not available
• Re: Strange (?) Index behavior? Allen Landsidel (Fri 05 22:40)
• Checking = with timestamp field is slow Antony Paul (Fri 05 07:16)
• Re: Checking = with timestamp field is slow Michael Glaesemann (Fri 05 08:14)
• Re: Checking = with timestamp field is slow Michael Glaesemann (Fri 05 08:33)
• Re: Checking = with timestamp field is slow Michael Fuhr (Fri 05 09:13)
• Re: Checking = with timestamp field is slow Michael Fuhr (Fri 05 08:34)
• Re: Checking = with timestamp field is slow Andrew McMillan (Fri 05 08:49)
• Re: Checking = with timestamp field is slow Christopher Browne (Fri 05 12:54)
• Re: Checking = with timestamp field is slow Michael Fuhr (Fri 05 17:45)
• appropriate indexing T E Schmitz (Thu 04 22:33)
• Re: appropriate indexing Matt Clark (Thu 04 22:41)
• Better Hardware, worst Results Alvaro Nunes Melo (Thu 04 21:06)
• Re: Better Hardware, worst Results Rod Taylor (Thu 04 21:18)
• Re: Better Hardware, worst Results al_nunes (Thu 04 22:42)
• Re: Better Hardware, worst Results Matt Clark (Thu 04 22:58)
• Re: Better Hardware, worst Results Rod Taylor (Thu 04 23:00)
• Re: Better Hardware, worst Results Matt Clark (Thu 04 23:09)
• Re: Better Hardware, worst Results Alvaro Nunes Melo (Mon 08 11:46)
• Re: Better Hardware, worst Results Tom Lane (Thu 04 21:46)
• Re: Anything to be gained from a 'Postgres Filesystem'? Markus Schaber (Thu 04 11:01)
• Re: Anything to be gained from a 'Postgres Filesystem'? Pierre-Frédéric Caillaud (Thu 04 12:29)
• Re: Anything to be gained from a 'Postgres Filesystem'? Chris Browne (Thu 04 16:23)
• Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs (Thu 04 19:06)
• Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane (Thu 04 19:34)
• Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs (Thu 04 20:43)
• Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane (Thu 04 20:46)
• Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne (Fri 05 02:53)
• Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson (Thu 04 19:20)
• Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (Fri 05 04:29)
• Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (Fri 05 04:35)
• Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (Fri 05 04:34)
• Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne (Fri 05 02:53)
• index not used if using IN or OR Mario Ivankovits (Thu 04 07:51)
• Re: index not used if using IN or OR Richard Huxton (Thu 04 08:32)
• Re: index not used if using IN or OR Tom Lane (Thu 04 14:52)
• vacuum analyze slows sql query patrick ~ (Wed 03 18:56)
• Re: vacuum analyze slows sql query Doug Y (Wed 03 19:18)
• Re: vacuum analyze slows sql query Tom Lane (Wed 03 20:13)
• Re: vacuum analyze slows sql query patrick ~ (Wed 03 22:23)
• <Possible follow-ups>
• Re: vacuum analyze slows sql query patrick ~ (Fri 05 18:26)
• Re: vacuum analyze slows sql query patrick ~ (Sat 06 00:26)
• Re: vacuum analyze slows sql query Tom Lane (Sat 06 04:07)
• Re: vacuum analyze slows sql query patrick ~ (Sat 06 06:18)
• Re: vacuum analyze slows sql query Tom Lane (Sat 06 06:39)
• Re: vacuum analyze slows sql query patrick ~ (Mon 08 18:57)
• Re: vacuum analyze slows sql query John Meinel (Mon 08 19:30)
• Re: vacuum analyze slows sql query patrick ~ (Mon 08 23:20)
• Re: vacuum analyze slows sql query John Meinel (Tue 09 00:01)

---

• Main Index
• [Prev Page]
• [Next Page]

---

Mail converted by MHonArc